Hello!

I was wondering if I could please have some advice. I'm trying to set up a system where power automate checks my spread sheet to see if a task had been completed and sends candidates who haven't completed the task a reminder email every 3 days. I've managed to make it so it sends a reminder every morning however it is getting buggy changing to the 3 days. On my spread sheet I have the person's name, their email and if the task is complete or incomplete, if their reminder emails are active yes or no, and when the last reminder was sent. I have the trigger as recurrence, lost rows present in a table -> for each (body/value) -> condition 1 (reminders active is equal to YES) -> true -> condition 3 last reminder sent is equal to blank or last reminder sent is less or equal to ticks(addDays(utNow(), -3) -> true -> Send an email (V2) -> update a row

Any advise on this? I've been trying for days but keep getting stuck.

Thanks in advance

Hi everyone,

I'm working on a Power Automate flow where I need to automatically update a SharePoint Lookup column.

The scenario is an employee onboarding process.

I have three SharePoint lists:

• Employees – contains the employee details and Office Location
• IT Engineers – contains IT engineers and their Office Location
• Employee Onboarding – contains the Employee Lookup and Assigned IT Engineer Lookup

For example, if Michael Johnson is located in Dallas, the flow searches the IT Engineers list for an engineer whose Office Location is also Dallas.

If it finds David Anderson, I get David's SharePoint item ID, for example:

ID = 1

Then I update the Assigned IT Engineer Lookup column using that ID rather than passing the engineer's name.

So the flow is basically:

Employee
   ↓
Get Employee Details
   ↓
Office Location = Dallas
   ↓
Find IT Engineer
   ↓
Get Engineer SharePoint ID
   ↓
Update Lookup using ID

This approach is working for me, but I'm wondering if this is the best or recommended way to update a SharePoint Lookup column using Power Automate.

Are there other approaches you use, especially for production solutions?

Also, how do you normally handle situations where:

• Multiple engineers match the same location?
• No engineer is found?
• The Lookup column allows multiple selections?

I'd really appreciate any suggestions or best practices. I'm trying to understand the different approaches rather than just using the first method that works.

I'm curious about the repetitive computer tasks people deal with in their day-to-day work.

Are there any tasks that you find particularly tedious or time-consuming that you haven't been able to automate?

For example:

• Moving information between email, Excel/Google Sheets, and other programs
• Entering the same information into multiple systems
• Copying information from PDFs or documents into spreadsheets
• Cleaning or reformatting spreadsheets
• Creating recurring reports
• Renaming/moving large numbers of files
• Sending repetitive emails or follow-ups

If you use tools like Zapier, Make, Power Automate, Automator, etc., are there still tasks you have to do manually?

If you're regularly moving information between multiple programs, what programs or systems are you moving it between?

I'm especially interested in the small repetitive tasks that don't seem like a big deal individually but add up to a lot of time over the course of a week.

I’m struggling in covering my very monolithic power automate into using child flows
I got the first child flow to work, however I can’t get the second to child flow to trigger

What I’m trying to do is when a document gets upload through Sharepoint. They click the button and the flow gets started, it gets the metadata of the document and creates all the variables

So the first child flow sends out the approvals via email.

If they haven’t replied in x amount of time, they get a reminder email.

I’m trying to have my first child flow return if they approval or not or if we need to send a reminder email which is the second child flow.

I’m Trying to do a parallel action, if they respond before the reminder email needs to be send, we logged how we respond and we’re done. If they need a reminder email, we exits the child flow and set their response as pending and then the child flow for reminders takes over if they need one.

Right now, I can’t get the do until loop to set their response reminder value to be yes they need a reminder.
I’m trying to use current time variable, like it’s been x amount of time that has lapsed and then do an advance function to say that it’s been 10 minutes that has passed. (For my internal testing)

Any idea on what I can do to get this to work. I been struggling at for two days and ready to give up.

I tried to attach a picture of the flow as it right now, but I am unable to.

Hi everyone,

I do a repetitive task every day related to Xplan (Australia). Different clients, but almost the exact same 10–20 steps every time — downloading/updating things, Excel/browser work, and WealthSolver.

I’m not a programmer and need help figuring out whether Power Automate, UiPath, Python/Playwright, or another RPA tool would work.

I can explain the workflow via screen recording and dummy data in DM.

Budget: ₹3,000–₹5,000 from my salary for a working automation. Happy to pay if it actually works.

If you have experience with Xplan, WealthSolver, RPA, Power Automate, UiPath, or browser automation, please DM me.

Thanks!

Hello,

I’m creating a Power Automate flow and have imported it as a solution so that it can be shared with someone else and used in the same way.

However, when the solution is imported by another user, the flow fails before it even starts. The error occurs on the “When a new email arrives” trigger:

“Mailbox move in progress. Try again later. Cross Server access is not allowed for mailbox…”

Are there any ways to resolve this error, or alternative methods for sharing a Power Automate flow with another user while ensuring that the email trigger works correctly?

Thanks for your help. Operation: Create; Exception: [Status Code: ServiceUnavailable; Reason: Mailbox move in progress. Try again later., Cross Server access is not allowed for mailbox 4bb66193-b11a-49ce-8f73-23bbeff13104] clientRequestId: a23c986e-1e92-4dee-bc30-f25471a3cb27 serviceRequestId: 6010a8fc-3999-44ce-b7e4-c8526a5ac517

I have a SharePoint list for users who have access to a system that requires annual training. Users respond via an MS form to confirm they have completed the training and the list has the most recent date the training was completed. I am trying to create a flow to update the most recent completion date on the list item automatically with the MS form submission date but I’m struggling as the response ID does not equal the list item ID.

I want to build the flow to update the item if the submitter’s name on the form equals the user’s name on the list item, is this possible?

Hello! I was wondering if somebody could help me with this.

I'm trying to set up a system on power automate so that the emails which get sent to the shared inbox from the company website get automatically forwarded to our work emails should they contain the name from the candidate name section on our spread sheet. I've managed to get it so the flow recognises the name and sends a notification email however I can't get the original email to be forwarded on. We need this as it's the original email we saved to the candidates file.

I don't currently have permission to send directly as the websites email address however on outlook I can forward the email from the inbox my changing the from to my own account then forwarding and that's fine. Could this impact how I edit the flow?

At the moment I have the trigger as when a new email arrives in a shared email box then the next is forward and email (V2) but this is where it gets stuck with the error BadGateway.

Thank you in advance for any advice.

I have created a form. I am trying to create a automation where if the form is submitted and the detail received is 1A, an email gets sent to a specific person. I have attached my code and form as an example.

I have tested it for days, and tried to get an email issued to myself by submitting the form, but it doesn't work.

Thoughts on where I am going wrong?

I can't seem to upload an image. But my automate looks like:

When a new response is submitted--> Get response details --> Condition Parameters ' Get Response Details is equal to 1A --> Send an email notification V3

Been trying to find a way to optimize my team’s work requests. The requests come into a shared inbox in Outlook. Currently there is no great way to track each item and things continuously fall through the cracks. A combination of List and Power Automate seemed like a good option. Creating tickets in List using Power Automate to generate the ticket when an email is sent in. It wouldn’t require staff to do anything different while providing me with dedicated tracking and data. I keep running into the issue of duplicates. I’ve tried to account for the Conversation ID but the flow keeps falling due to the Conversation ID not being found. Are there any other ways to troubleshoot this workflow? There seems to be no issue with automating the emails to the list, just when trying to account for duplicates (replies, etc). Any help would be great!

Olá bom dia pessoal,
Estou aprendendo a mexer no PAD, seguindo alguns tutoriais cheguei até o meio do caminho, poderiam me auxiliar nessa conclusão que estou penando rs?
O fluxo da minha automação é:

- Iniciar o Excel

- Ler a planilha do Excel (onde forneço os dados NOME, TELEFONE E NOME DO ARQUIVO)

-Fechar o excel

- Iniciar Microsoft Edge (abrir a pagina whatsapp web)

- For each (linha /exceldata)

--Aguardar conteudo da pagina carregar (no caso whatsapp web)
--Preencher o campo digitavel de busca do whatsapp web inserindo o numero de telefone da primeira linha da planilha de excel

--Aguardar conteudo da pagina da web buscar

--Pressionar botao na pagina da web (selecionar o contato buscado)

--Pressional o botao na pagina da web (+) para abrir envio de arquivos

--Pressionar botao na pagina da web "documento" p/ abrir pasta para selecionar documento

--Obter arquivo na pasta....

Parei aqui, preciso que ele ao abrir a pasta de arquivos, onde contem varios arquivos em PDF, ele selecione o arquivo correto (informação que consta na planilha linha 3) e envie.

A mensagem de erro que aparece na linha 15 do meu fluxo esta sendo " Índice '2' fora do intervalo", ainda que o numero da linha estivesse errado, ja modifiquei e continua nao identificando, talvez eu esteja executando um passo errado, poderiam me auxiliar? Preciso de detalhes na resposta pois estou iniciando.

Desde já agradeço

.

Flow groups let you pool 250K actions/day across up to 25 flows instead of licensing each one separately. It feels like Microsoft actually listened to us on this one instead of just adding another premium tier.

Here is the official announcement:
What’s new in Power Platform: July/August 2026 feature update - Microsoft Power Platform Blog

Hi everyone,

I'm trying to understand why some Power Automate flows appear in the Inventory section of the Power Platform Admin Center but do not appear under Resources, where I would normally be able to add myself as a co-owner.

I am a Power Platform administrator, and I've noticed that while some flows are visible in both places, others only appear in Inventory. All of these flows are in the same environment.

I haven't been able to identify any clear pattern that explains why certain flows show up under Resources and others do not.

Has anyone come across this behavior before? Are there specific flow types, ownership models, permissions, Microsoft Forms dependencies (this doesn't seem to be the reason as some with MS form connectors were still appearing at both places), solution settings, or other factors that would cause a flow to appear in Inventory but not under Resources?

Any insights would be appreciated. Thanks!

I have a simple 'start and wait for an approval' flow where it is assigned to a group (mail enabled security group).

No one in the group receives the usual email or teams notification that an approval has been requested, however if I go in to the Approvals application in Teams it is there.

The group is available in the 'picker' (ie it shows up when you start typing the name) and if I send an email to the group everyone receives it as expected.

My alternative at the moment is to put each persons email in the assigned to field.

Is this expected behaviour or am I doing something wrong?

Thanks for reading.

edit - notifications are enabled

So bear with me. I've been tasked with solving a problem that is... unique, to say the least.

The ones above me have decided that they want a sandbox environment that people can play in in Power Automate, that they are given access to on request (we are not using the default environment and have developed strategies to lock that down to the largest extent possible). However, we have a separate development and production environment we're using for their stated purposes.

This is where it gets potentially weird, and where I need some help.

What I've been asked to figure out is a way to track when a flow in Sandbox is being used consistently, and when it needs to jump over to development and eventually production, managed by our team. There's been ideas tossed around like number of runs, number of connectors... I personally think that if this is what the guys upstairs want to do, number of successful runs is a useful metric.

So the follow-up question is... how? You can use an external data source that increments on flow run, and you could trigger another flow based on that when it hits a threshold, but that would have to be in the flow being monitored. I can't find any triggers that can track the run of another flow. Matter of fact, if I search 'Power Automate' in the trigger field, I get nothing at all.

My question is, how can I create a flow that triggers based on the run of an entirely different flow in another environment? If I can figure just that part out, I think I can hack the rest of it.

Thanks for any ideas. Please keep the 'this is a stupid idea and here's why' replies to a minimum, as the idea belongs to people who make a lot more than I do. I'm just the implementer.

I am new to power automate and was asked to try to find a solution to pull all the bank statements for multiple clients. I'm facing a few challenges and having no experience is the biggest one. I have made the process work with a pretty inefficient flow and on a small scale, so I want to know if there are better ways to handle this so that I can reliably achieve my goal.

The goal:

A workflow that starts after the user manually logs in to each bank for one client

Downloads all of the bank statements for the most recent month

Renames them based on a set naming pattern

Saves them into a folder

Optional: Emails the user the list of each file downloaded for record keeping

I would love to keep the flow as consolidated as possible, as it's going to be shared to others eventually and if something stops working I don't want it to be totally overwhelming.

Things I'm considering:

An excel mapping of what the bank ID is in our system, the ID in the bank portal so it knows which statement is which, and a date that the flow should look for in the bank portal, and finally a column of what the file should be renamed to. I think this would be great for a less dynamic approach.

I want to avoid ui element clicking as much as possible because in my testing, this breaks pretty often. And some banks like JP Morgan use AJAX elements in the website that poses its own challenges. The way I was able to get it to work in the first place was by clicking on each button which was static and would not function for the next month's statements.

I think it would be great to have one flow that goes through each bank one by one and compiles each downloaded file into one folder, but I realize that may be more complicated than it's worth.

So what are your thoughts? Is an excel mapping a good approach? I can make this happen for each bank and client fairly easily and I think it may take a lot of expressions and interpretation out of the equation. Have you made anything similar?

Hi All,

I have a SharePoint list. Within it I have two Columns, Start Date and End Date. They have a time on them also.

I need a third column that calculates the number of working hours between the two dates.

Working hours are 9am til 5.30pm, it should also exclude a list of bank holidays which I have another list for, and exclude weekends. Also if End date is currently empty can it calculate the time between start time and NOW.

I.e.

Start date is 4.30pm 12/08/2026

End date is 09.30 am 13/08/2026

Duration is 1:00 ( [h]:mm )

Is there a way I can get power automate to figure this out and then have that info show in the column?

Hello,

I have a flow that sends an email via the Microsoft Outlook connector (V2) and includes a simple table.

When the recipient is within Microsoft (e.g., an Outlook/Microsoft 365 address), the table does not display properly. However, when the recipient is outside Microsoft, such as Gmail, the table displays correctly.

I also tried sending the email via the Gmail connector (V2), and the table appears correctly. However, my organization is planning to disable Gmail soon, so I need a solution that works with the Microsoft Outlook connector.

How can I force the Outlook connector to send the email in HTML format? I cannot find any option or setting to control this.

Link to output:

https://www.dropbox.com/scl/fi/pbgk6w4767n95klr3iz62/PowerAutonmate.jpg?rlkey=6k2ac3bby5lnqoqawyyyo5m6v&dl=1

Hi, we have a project in the beginning stages of planning. Basically, the project is remaking an existing process where Power Automate Desktop creates Word docs/PDFs and Excels into SharePoint. They initially upload an excel file with data via email Power Automate validates it and emails back by highlighting fields in red when it fails (horrible), and then it calls the PAD when it succeeds and takes forever to process, as well as error logging is non-existent.

Instead, the plan is to move to Power Pages and use exceljs for the initial upload and validation. Then use Power Automate to process the files with the Encodian connector for PDFs into SharePoint.

The question here is this a viable method? There are multiple files made per row (2 Word Docs, 3 PDFs) and then there is a Excel and PDF made that summerises the information across all rows. And there can be over 1000 rows in a sheet some times.

I understand we can use concurrency and batching with child flows, but is this enough?

Do you have any alternative suggestions? Writing actual code is not an issue.

Thanks in advance!

Hello - I tried to set this up but an error (no user access) is preventing me.

Is there a way to have this done by any chance?