r/PowerAutomate

What am I missing with this software?

The interface is so clunky and cumbersome it almost always feels like I could just do every automation by hand and it would be less frustrating.

How are people dealing with this because there’s just no way that this product as is just sucks this bad. Is there some kind of software you’re using on top of it that’s writing the actions in the background or something?

reddit.com
u/bafadam — 1 day ago

What's the best way to jump from CoPilot to Power Automate?

I want a digest of my inbox (2 diff folders) and a digest of my calendar every morning emailed to my inbox or even a pop up alert. Screw it, I don't care if it's a document in Sharepoint I need to look at every day. I tried making it with Copilot and Power Automate. I asked questions, showed screenshots, etc. and it collapsed. On the other hand, I've used ChatGPT and n8n in the same way and no issues whatsoever. So why can't Microsoft products all do the same? Help me pls!

reddit.com
u/ZACTCTZACTCT — 22 hours ago

Version mismatch PAD and Machine Runtime

Has anyone else run into a Power Automate Desktop / Machine Runtime version mismatch recently?

I’m currently seeing the following setup:

  • Power Automate Desktop (Microsoft Store): 2.70.187.26189
  • Power Automate Machine Runtime: 2.71.115.26224
  • Microsoft Power Automate Edge extension: 2.70.0.35

My local desktop flow can sometimes launch Edge successfully, but when the same desktop flow is triggered from a cloud flow, browser automation fails with errors like:

WebExtensionHostIncompatibleException

and:

The version of Power Automate for desktop app installed through the Microsoft app store on your machine is different from the version of Power Automate for desktop machine runtime installed through the Power Automate for desktop executable installer.

The cloud-triggered flow opens Edge, but it stays on about:blank and PAD cannot take control of the browser.

I already tried:

  • reinstalling the Power Automate Edge extension
  • restarting Edge and PAD
  • restarting the machine
  • testing with a minimal desktop flow
  • testing the same minimal desktop flow through a cloud flow

The local test can work, but the cloud-triggered test still fails.

The strange part is that the Machine Runtime is already on 2.71, while PAD from the Microsoft Store is still on 2.70, so I currently can’t get both components onto the same version.

Is anyone else seeing this right now? Did your Machine Runtime update ahead of PAD as well?

If so, did you solve it by downgrading the Machine Runtime, switching away from the Store version of PAD, or just waiting for the next PAD release?

reddit.com
▲ 35 r/PowerAutomate+1 crossposts

Excel + Power Query and Power Automate

I am trying to have Microsoft Power Automate to refresh a report that exists in Salesforce. That report is linked to an excel file via a powerquery.

I have created a script on OfficeScripts that have workbook.refreshAllDataConnections(). It does update a pivot table, so I can tell that the script is runnint

The table that PQ puts the data in is set to not do Background Refresh and to refresh when opening the file.

 

What is the best way to have PA to refresh Excel’s PQ?

Table properties on

https://preview.redd.it/73bhc3gob7kh1.png?width=461&format=png&auto=webp&s=d9b9c3fe3e4f39fd0daeca18781a42204453a704

reddit.com
u/__wisdom__1 — 2 days ago

Reminder emails

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

reddit.com
u/misfit18241 — 3 days ago

Child flow help!

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.

reddit.com
u/NullReferenceGhost — 4 days ago

What tasks at work have you tried to automate but still have to do manually?

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.

reddit.com
u/Constant-Day6997 — 4 days ago

Flow to update list item

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?

reddit.com
u/WesternPriority8217 — 6 days ago

Power automate forwarding emails from a shared inbox

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.

reddit.com
u/misfit18241 — 6 days ago
▲ 6 r/PowerAutomate+1 crossposts

Creating a flow for getting excel columns and putting them in a new workbook

Hello. I am somewhat new to Power Automate and largely am using Copilot to help me create flows. Since I am new and lack experience in both programming and Power Automate it could be that I am naive and my challenge is not possible to solve. However it seems like it should be possible.

My challenge is to get 7 columns from an excel table on a sharepoint, only entries with a DateFrom the last seven days(thats one of the columns), put the columns in a new excel workbook. Then I would like to post that newly created workbook in a weekly e mail. The data would refresh itself every day but the email will post weekly. Is this even possible ? If so how would i best go about doing it or prompting Copilot to help me create it ?

reddit.com
u/TsaeOps — 8 days ago

Difference between start time and end time for working hours.

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?

reddit.com
u/Alternative-Day5268 — 8 days ago

Table is not showing properly, while sending an email via Microsoft Outlook:

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

reddit.com
u/urielpr — 9 days ago
▲ 3 r/PowerAutomate+1 crossposts

Flow run failed but no error message or failed action is shown.

error

Flow run history shows a "Failed" status. However, when I open run details to investigate, none of the actions or steps are marked with a red 'X'. How can i check where error to fix this. Thank you.

reddit.com
u/Civil-Net7819 — 10 days ago

Ideas for best way to handle bank statement download automation

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?

reddit.com
u/BeanCounter4Life — 8 days ago
▲ 8 r/PowerAutomate+2 crossposts

Copilot Studio: End Conversation Fixes Duplicate Responses but Breaks Follow-Up Context

I have a main Copilot Studio agent and a connected agent. When a user asks a question, both the connected agent and the main agent were responding, which resulted in multiple responses for a single query.

To resolve this, I added an End Conversation node at the end of the topics, and the duplicate response issue was fixed.

However, a new issue appeared. Follow-up questions no longer retain context because the conversation is being ended. For example, if a user asks a question and then follows up with "How many of those were raised in March?" or "What about it?", the bot no longer understands what "those" or "it" refers to.

Before adding End Conversation, follow-up questions worked correctly, but I was getting multiple responses. After adding End Conversation, I get only a single response, but follow-up questions lose context.

Has anyone faced a similar issue? What is the recommended approach to prevent duplicate responses while still maintaining follow-up conversation context in Copilot Studio?

reddit.com
u/Miserable_Focus_8610 — 9 days ago

Is there a way to use Power Automate to post a message in a Channel in a Teams group WITHOUT being a member of that group/channel?

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?

reddit.com
u/pcgoesbeepboop — 10 days ago

Power Automate limitations or other options

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!

reddit.com
u/IpipyReq66 — 10 days ago

LoopIndex not working - looking for input on my flow

I am tinkering with Power Automate to help with some Quickbooks tasks. I created a flow that works once, and I need it to loop.

Before the loop, it looks like:

1 - Start of autogenerated actions
2 - 7 A series of Click UI elements
8 - End of autogenerated actions

After I add in the loop, it is:

1 - Start of autogenerated actions
2- 7 A series of Click UI elements
8 - LoopIndex (from 1-7 with increment of 1)
9 - End Flag
10 - End of autogenerated actions

When I run it with the loop, once it gets to the end of the 2-7 steps, it flashes quickly back and forth a few times between Loop and End Flag before ending.

What settings do I need to update?

Edit: I'm using the App on Windows 11.

Screenshot: https://imgur.com/a/27GCsEO

u/rpgedgar — 11 days ago

Power Automate Mobile App being retired 31/08/2026

Just went into the app this morning and saw the notification. Shame really, as I liked triggering flows in the app, push notifications from flows and keeping an eye on running flows etc.

I can’t figure out how to add an image here to share the full message.

But here is the link to the article.

learn.microsoft.com
u/Greater88 — 13 days ago