Hello, I have created a PR approval flow for my company using Power Automate. It uses a cumulative approval structure based on dollar-value thresholds. Everything works as expected; the appropriate people receive approval requests in the correct order, and the requestor is notified when the final approver completes the flow. The problem is that once the final approver approves the PR, two duplicate runs start, and another approval email is sent to the first approver, prompting them to approve the same PR again. We have tried hardcoding multiple "@not" statements with no success. Does anyone have advice on how to fix this looping issue?

Hello,

I am currently working on an automation flow for reminder emails for the business I work at. The flow currently is successfully pulling an attachment when an automated email comes in with the list of customers who need a reminder, transferring it to excel, and formatting it as a table. My issue starts now when trying to dynamically assign the 'To' in setting up the reminder email itself.

Currently, I'm using the function: items('Apply_to_each_1')?['Default_Contact_Email'] - but this has errored out and I'm not quite sure how to fix from here. I'm using Send an Email (V2) as a child action to "Apply to each 1" - the second apply to each as I have the first one filtering for the correct attachment to pull from the email and create the excel file.

My flow receives docs and xlsx files from different users. Some come from Microsoft office download, some from wps office . Well, has anyone had to handle compatibility issues or do you treat them all the same in power automate?

Hi,

Trying to figure out what steps I'm missing. I'm new to Power Automate.

Problem: Automate filling out word document.

The user exports a Service Now demand ticket to a PDF File. There is a predefined Word template that has the fields. The goal is to use CoPilot to call the flow to accept the SNOW PDF file and fill out the Word template. The output will be a brand new document that has the fields populated.

Watching youtube videos, in Flows:

1. When an agent calls the flow

2. Populate a Microsoft Word template action.

3. Create a file (in SharePoint)

4. Respond to agent

I'm missing some steps, not sure where.

Input the PDF file: Do we put the input request in step 1? Ask for file upload?

Output file: Does Step 3 know that the output is the result of PDF filling out the template?

I want to query the entries of a Sharepoint list that has the following field:

"CountryOfSales":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id":123,
"Value":"USA"},

How do I query the Value key of the JSON in the ODATA filter clause? I tried the following but they all failed:

1. CountryOfSales['Value'] eq 'USA'
2. CountryOfSales[Value] eq 'USA'
3. CountryOfSales.Value eq 'USA'

Thank you all in advance!

Issue with setting log location

I am currently trying to modularize the logging process, but I want to avoid having to manually update the file path for every new project. Is there an action or script available in PAD that can dynamically retrieve the current project directory, so I don't have to reconfigure it every time?

Hey all,

Hope you are having a great day!
I have a simple flow in Automate, where I load a template excel file, run a query against a dataset in PowerBI, then create a new file and run a script in Excel that populates a table and refreshes a pivot Table. However, I'm having an issue of errors on the script execution step in my flow, that is giving Bad Gateway, but the script is working fine, I can't seem to find the issue.
Can anyone help?
Many thanks!

Hey All,

We've had an issue pop up in the past week where the trigger for "When a file is created (properties only)" is not firing until hours later. This is an existing flow which has been in place for years. We use this to identify new PDF's which need to be OCR'd for AP automation.

For example, I have these files which are now 2 hours old yet the last flow run was 4 hours ago:

They actually processed while I was writing this post but prior to that the last flow execution was 4 hours ago.

I don't think a 2 hour+ delay is acceptable for this trigger.

Has anyone else seen similar behaviour lately? I do not see anything on the service status.

Hi everyone,

I'm trying to implement an executive email workflow in Microsoft 365 and Exchange Online, and I'm wondering if anyone has successfully done this.

Requirements:

Client sends an email to the CEO.
The CEO receives the email.
The secretary also receives a copy automatically.
The secretary drafts a reply.
The CEO must approve or reject the reply before it is sent.
If approved, the email must be sent from the CEO's mailbox.
The reply must remain in the same Outlook conversation/thread.
The secretary must not have Full Access to the CEO's mailbox due to privacy requirements.

I tested Power Automate approvals with the Outlook connector, but the "Send an email" action creates a new conversation instead of replying to the existing thread.

Before I build a Microsoft Graph API solution using createReply, PATCH, and send, I'd like to know:

Has anyone implemented this workflow successfully?
Is there a native Microsoft 365 or Exchange feature that achieves this?
Is there a third-party Outlook add-in or Microsoft solution that supports approval while preserving the original thread?
If Microsoft Graph is the only solution, what architecture did you use?

Any guidance or examples would be greatly appreciated.

Hi all,

Im running into an issue setting up a flow that triggers on a new file being created in onedrive, then sending the file in an email.

I have this exact flow set up for another folder and it is currently working. I only have 2 connections in my Connectors list, one for onedrive, one for outlook online.

Im trying to set up an identical flow just for another folder, but in the folder finder, it is only finding the root folder, then when I click to show contents, nothing is found. Im almost certain that I was able to select the folder through the folder finder on the first one.

I have even tried to duplicate the flow, change file path manually and still gives me an error that the trigger has an issue. Click on it and usually get a user cannot be found. Any help PLEASE?

I wanna copy files from one sharepoint to another but like all files which arent mp4 or mp3 I tried putting a filter query but it didn't work as expected. Any idea how to do thos?

Hey Guys, I am trying to build the approval work list items just like we have in powers automate section. So that users can have flexibility to approve from spfx application as well with Outlook and teams. I have able to load all action items and show case them here but I am not able to find any property to filter them based on my flow.

Can anyone help me with this. It would be really helpful. I tried data verse as well but that was a dead point. For me.

I will really appreciate your help . Thanks

I've been using a loop element in a running outlook series to update the agenda/collect input without having to update the body/trigger a new invite getting sent.

Now I'm at the stage where I want to automate parts of this setup and guess what? Loop sucks and has no connector in power automate.

I really actually love it - one place that I can link in Teams, Outlook, etc. But no support for automation makes it non viable long run.

So my question: what else can I use that drops into an outlook invite and dynamically stays up to date? Bonus if I can also add it to a PowerPoint slide.

* Solved \*

I went to fix something and clicked a "set variable" component and... there is no value! Kinda makes set variable pointless, lol. I closed and reopened and the value is still missing.

If I switch back to the classic editor, it works and I can edit but the classic editor sucks so I'm really hoping someone has a suggestion that may work to make it show me my value field again?

Thanks a lot!

I have a folder where I save reports created in wps office. I’d like power automate to automatically convert new documents to pdf and move them to another share point folder. Is there a recommended approach or is a premium connector required?

Issue Observed with Folder Structure Replication

While testing the Power Automate flow that copies updated content from Folder1 to Folder2, I observed that the folder hierarchy is not being preserved correctly.

Source Structure:

Plain Text

Folder1

└─ Folder1

└─ Folder2

└─ foldercopy

└─ Dummy-Excel.xls

Expeted Destination Structure:

Plain Text

Folder2

└─ Folder1

└─ Folder2

└─ foldercopy

└─ Dummy-Excel.xlsx

Actual Result:

Folder2

├─ Folder1

├─ Folder2

├─ foldercopy

└─ Dummy-Excel.xlsx

Instead of recreating the complete folder hierarchy and copying only the file into its corresponding path, the flow is processing intermediate folders (Folder2, foldercopy) as separate items and creating them independently at the destination. This results in duplicate or flattened folder structures and multiple copies of the same content.

The requirement is to copy updated / edited / modified files and folder from one folder to another and recreate the necessary parent folder structure in the destination, rather than treating each folder creation/modification as an independent item to be copied.

I am building a flow to send an email with multiple attachments submitted through a Microsoft Form. I’ve done this hundreds of times. Suddenly, Friday, I started receiving this “This expression has a problem.” error when trying to enter this expression in the Append Array Variable step.

Is anyone else seeing this? Been altering my syntax for hours trying to get around the error with no success.

Hey guys is there any way to make flow solve this problem?

Does anyone know if there's a way in 2026 to convert .xls files to .xlsx or .csv using Power Automate without relying on Premium connectors or any third-party connectors?

Hey everyone,

I run a small YouTube channel called Automate M365 where I focus entirely on making straight-to-the-point, step-by-step Power Automate tutorials. No fluff or long intros, just diving into the logic because I know how annoying it is to sit through a 10-minute video just to find a 30-second fix for a broken expression.

Instead of just guessing what peice of content to build next, I want to make stuff that actually solves real-world headaches.

What’s that one manual task or broken flow that’s driving you crazy this week? Drop it in the comments below. I’ll honestly try to look through them and build the exact solution in a step-by-step video for you.

If you want to check out the channel or subscribe to see if I build your fix, the link is here: https://www.youtube.com/@AutomateM365

Let me know what you're stuck on, hopefully we can figure it out.

Hello, I am trying to figure out how I can have the responses from question 6 be autosummed and give me total score. I want the total score to then be assigned a value on question 7. For example if the sum of my responses in question 6 totaled 8, I would be auto assigned 'Emerging.' I want to do this through power automate or the auto grading technique, however I am very unfamiliar with this. Any way to do this? A detailed step by step would be appreciated or even a phone call. I am brand new to power automate and struggling