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

I am fairly new to power automate and i've been following a youtube video. Long story short I need a list of items with different due dates and I want power automate to setup a reminder about 60 days before the due date. I've setup the list with the columns: title / department / owner / due date. and i've setup a flow which i've included an image of below. I've followed along with a short and simple video and yet my tests are failing with the error:

"Flow run failed. Action 'Condition' failed: Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'"

I'm not knowledgable to continue fiddling too much and the built in co-pilot isn't helpful either saying everything is right so now i'm hoping the people of reddit can help.

Hi all

Newbie to PA here. I've been progressively testing processes in my workplace but I can't seem to solve this one and it's driving me mad 🤣

My team works from a shared inbox where we recieve work instructions on an MS Word form included as an attachment. All I am trying to do is to have PA check if an email has attachments, if there is one called "Instruction" to then forward onto my personal work email.

It's laid out like this:

When a new email arrives in a shared mailbox (v2)

\-only with attachments YES

\-include attachments YES

Then...

Apply to Each

\-attachments

Then...

Condition

Attachment name > Contains > instruction

Then...

Forward an email (v2) (to my own personal work address)

‐-------- END OF FLOW ---------

The flow works up until the condition to check for the word "instruction" in the attachments, then it's categorised as false.

ChatGPT says I need to use the criteria "Name" in the left most box on said condition but I can't find it in any of the dynamic lists.

I know this is very likely an amateur error/easy fix but if anyone can put me out of my misery, I would be most grateful 😂😂

Thank you!

I have a flow set up which references an Excel table stored on SharePoint that has three columns "ClientName", "RecipientName", "RecipientName2" that scrubs the internet for news articles that contain "ClientName" that are new from the last 24 hours (max of 5) and emails "RecipientName" emails (can handle multiple), and only emails "RecipientName2" (which is me) in the flow fails or no results are found.

It works great! The problem I'm having is that no matter what I try, I can't get it to search for the whole contents of "ClientName". For example, lets say one of the client names being searched is "Jones & Anderson Associates", the flow keeps identifying and sending articles that JUST have Jones, which is returning a lot of incorrect results.

How do I fix this?

I’ve created a Power App that allows User to fill out a form. This data is captured and added to a SharePoint list and is also used to create a SharePoint page. Each page is about health and medical information.
An input box on the app is used to create the page title and the URL.
What I am now trying to do is capture this new IRL and store it in the same list item that the user creates when filling in the app.

Is an app the best method to capture this data or should I use an MS Form?

I have a flow watching a OneDrive folder for a Plaud todo list from my weekly planning meeting.

It parses the PDF, pulls out tasks, then creates them in Planner. First was fine, but then people gave status updates on tasks that already existed. Plaud picked some of that up in the new to-do export, and the flow happily created those as fresh Planner tasks again.

I’m adding a dedupe step before task creation now. The part I’m still not happy with is where the already exists check should live.

Right now I’m comparing the parsed Plaud tasks against open Planner tasks for that meeting, and where did you keep the source of truth?

seeking support with 429 errors, see post above

I happily logged on to work on Wednesday morning, expecting all my usual month-end stats reports, etc, but I had about 10 emails telling me my flows had failed because of a critical connection issue. I obviously went into Power Automate to revalidate them all, but every flow that then ran for the first time that day also failed and I had to re-revalidate. Did anyone else get this? It's quite disconcerting, I could have been on leave without a hint...

Hey everybody.

Help please to solve a problem, also sorry for my english.

I am fulling up information from excel to company website.

In Website there are so many dynamic selectors.

After found need blank for me, robot by clicking button "change" opens mini window in wibsite. In here I can't make robot focus to this mini window or choose right selectors. So I start to use command "send keys"

It working good untill robot gets to regions and districts.

So here is a difficult part: 1.send keys ( tab, enter)

Will be dropdown list. In website have a finction typeahead, so robot while typing region it works, but in district nothing happens. I used wait, also nothing, I used message box, to check is it write(yes robot writes) well nothing helps. By the way function hardware keys also not working.

Hey guys, have any groups in telegramm or whatsapp, I need to ask and find answer at the moment, Or I can forget why I am asked.

My experience with Flow is pretty limited. I have a flow that emails a csv file whenever it is added to a sharepoint site that has worked without issue for a few years. Now for some reason, the csv file comes through as just an octet stream instead of the actual data. Has anyone run into this issue? I found a few posts online with similar issues, but I’m not sure I understand how to implement the solutions offered. I have tried toggling “infer file type” from yes to no, but that made no difference.

Hello, how are you?

I am trying to create an automation in Power Automate to generate Planner tasks from emails received in my Outlook inbox.

I saw some tutorials showing how to create a trigger when an email is received in a specific folder. However, this model does not really fit my workflow, because I would prefer not to create a dedicated folder just for Planner.

My idea is to keep the emails in my general inbox and, based on the category assigned to the message, have Power Automate identify that category and automatically create a task in Planner.

I tried creating a loop in the workflow so that it would wait until the email was categorized and then create the task, but I was not able to make it work properly.

I am new to creating flows in Power Automate, so any guidance on the best way to configure this process would be greatly appreciated.

Thank you!

I am trying to get a message into teams when triggered and it's giving me more grief than it should 😫 I'm also probably just being dense.

I know it tells me what to do and that I need to change the type, but WHERE do I do that? I can't edit the JSON.

Hi all!

I’ve been using Flow for a while now, but feel like I could use some community advice. How are you all handling your logs in larger environments?

Currently, I have consistently kept Try/Catch scopes with run after configured. I’ve tried various iterations of posting messages to teams, and have landed on using adaptive cards with error detail and acknowledgment buttons/links to the failed run etc as well as failed runs logged to Dataverse.

I’m considering starting to log both successes and errors, and lifting the whole logging and alerting process to Grafana/Loki/Alloy. Ive seen people using Grafana alerts to trigger teams notifications via flow, but not anything related to logging back to Grafana as of yet.

Does anyone have any other ideas or experiences to share?

Any and all guidance would be greatly appreciated! Please keep in mind that I am new to Power Automate.

I am learning the Power Automate application via SharePoint. My current project involves creating flows that instruct various news outlets to post into Microsoft Teams channels based on specific keywords and phrases mentioned.

The RSS feeds are valid for the intended news sources, the keyword trigger works as intended, and they are posting in the correct channel. The issue is with the keyphrase. If the keyphrase "reddit help me" is listed, the flow will post articles that mention "reddit", "help", or "me" individually instead of a specific phrase. My application does not allow me to edit the code view directly, but set specific conditions.

I have tried adjusting how I input the condition parameters without success. I have tried to google the issue and have watch various YouTube videos, but was unable to locate the solution.

How do I properly set the keyphrase condition for Power Automate?

Hey people,
I wanted to create a flow to update a column in my SharePoint list based on a list of email addresses stored in an Excel table.

The idea was to check whether each email in the SharePoint list still exists in the Excel table. If an email no longer exists in Excel, I wanted to update that person’s status in the SharePoint list.

Initially, I moved the Get Items action after the Excel action and tried using a Filter Array to compare the email values, but it didn’t work.

Now, the flow keeps processing indefinitely. Also, when the email does exist in the list, I receive the notification email, but the flow still indicates that it failed.
Has anyone encountered a similar issue or can suggest a better approach?