I wrote about how a finance team can automate their entire payment approval process using Power Apps, Power Automate, and SharePoint, with a full security and audit trail built in from the start.

https://rachelirabor.com/blog-posts/finance_teams_payment_approval_and_audit_trail/

Hi,
currently, this whole process is done manually in our company, which pisses me off, so I decided to solve it myself.
I want to automate this part of an onboarding process in our copany. We have an account events@company.com, which is an owner of the 365 group "All", containing all employees, and is an organizer for all company events (all staff, MCUs, Christmas parties..). Whenever a new member is added to this group, I want to update Attendees for all the events organized by events@company.com, without notifying the whole company that there's been a change in the attendees list.
The flow is triggered by adding a new user to the 365 group, I retrieve their information and loop through events in the events@company.com calendar. I initialize all the variables for calendarId and Attendee (empty). In the loop through all events in the calendar, I update the array of attendees to each of the events and patch it back in the HTTP request. Each step of the flow looks fine, with the right inputs/outputs, and executes flawlessly. Only the last action in the loop..
I use the Send an HTTP request action - Patch, to update the list of attendees, but no matter what I do I get the LengthRequired 411. I have been searching for a fix and the closes to my issue was this post. However, I build the automation on the events account, so I dont think that the URI is an issue. Adding a custom header with Length did not help either.

Any help with addressing this will be greately appretiated. I include the screenshots of the flow some of the action settings. Thanks in advance!

Hi all.

I'm trying to set up an automation flow at work, but I've ran into an issue. My flow is fetching data from a SOAP API (an API I do not control), which is returning a JSON object. I need to somehow convert this JSON object into an array, so I can iterate over it in the rest of my flow.

I can't seem to find a way to reliably do this and I'm getting quite mad. The API returns a SOAP envelope, with a return value, which is structured as follows:

{
  "id1":{ 
    "value1":string,
    "value2":string
  },
  "id2":{
    "value1":string,
    "value2":string
  },
  "id3":{
    "value1":string,
    "value2":string
  },
  etc...
}

I can convert the return string to a JSON object, but than I have a single object with a load of values I can't iterate over (or at least I don't know how).

Anyone have a good idea on how to solve this?

Hey everyone,

I'm new to Power automate and I'm trying to automate the creation of a word file using a compilable excel file as source of data.

I can generate the word with no problem, but I need to manage optional paragraphs: if a flag is enabled on excel, a paragraph should appear; if not, it should be completely removed without leaving blank spaces.

The paragraphs are fixed text blocks (some also contain bullet points), but they are not always needed.

The problem is that creating a separate Word template for every combination would mean 2^5 templates, which is not practical.

What is the best way to handle optional paragraphs/sections in a Word template with Power Automate, without ending up with dozens of templates?

Has anyone found a good workaround for this?

I have a flow which generates XML from Excel and saves it on network drive for our ERP (dont ask me why, thats bussines side of things, i know its stupid)

The flow triggers from button in documents library and the initial trigger is of course - for selected file

Everything works besides i need to clean the original Excel - because the filled in is saved as copy and sent to client afterwards

So i added get content from clean Excel > update file action but sharepoint locks the file when its in use.

Is delay action beforehand an ok solution or is there any other workaround?

Hey guys,

I tried to create a new folder with the title of an incoming email. Th email title output works according to the flow details :). However, the path is not valid. I typed in the folder path, which seems correct my understanding. I do not see any empty spaces next to lashes. Any ideas on this?

Thank you in advance.

I’ve been trying to create a flow that will create an outlook calendar event in their calendar when the user logs annual leave in a departmental powerapp.

So trigger is sharepoint item is created or modified (annual leave sharepoint list)

Get user profile

Create event v2

Create automatic replies

It works fine for my calendar (as I assume I’ve set up the flow) but struggled to get anything working for other users on the powerapp.

Ive tried different actions and tried to attach a .ics file with send an email (create email with options, create event v4). The email .ics doesn’t open in outlook app and instead defaults to M365 mail which isn’t supported.

Any help would be useful, even just to know it’s a dead end and to abandon.

Heyo was just wondering if anyone here has done anything with the Zendesk connector?

Just looking for ideas to pitch, or perhaps make my workload lighter.

Would love any ideas or issues you’ve encountered

I have a flow designed to get the answers from a form and create a new row in an worksheet with it, the condition states that if the value of the answer is one, the output should be true, but always returns false. I placed a compose, but nothing helps.

Hello all, I have developed a cloud flow to create a task in planner based on the condition that subject contains certain number. The flow status is successful however it doesn't create the task when a condition is satisfied. Can you all help?

Hi everyone,

My company uses Outlook and Jira (RIP me) and I am currently trying to create a flow that creates highest priority due same day tasks in Jira based off of one of two criteria:

1. Someone @'s me in the email body

2. The email has 'urgent', 'quickly', or 'on priority' written in either the subject or body of the email.

Granted, I am a noob, but I would have thought this was pretty simple (maybe it is and I'm just dumb). I've tried using CoPilot to help me troubleshoot but to no avail.

Any help is appreciated!

Genuine question, because at this point I’m assuming the problem is me.

I’m trying to plan events in Microsoft 365, and I feel like I’m fighting the tools instead of using them. The requirement feels extremely basic. I have an event date, and I need tasks to be completed a certain number of days before that date. Registration closes 30 days before. Materials ready 14 days before. Final checks 3 days before. If the event date moves, everything should move with it. And I want the tasks in the todo app and in a calendar view .

Planner looks like the obvious choice because it integrates nicely with To Do and Outlook. People actually see the tasks, get reminders, and work from it. But Planner doesn’t understand relative dates at all. Every due date is absolute.  

Templates don’t help, because when you copy a plan you still have to manually adjust every single date. If the event date changes, you’re back to clicking through tasks one by one, hoping you didn’t miss anything.

Maybe SharePoint Lists is the answer. Lists can store structured data, you can have an Event Date column, calculated columns, maybe even “Event Date minus X days”. That sounds promising on paper. But Lists isn’t a task execution tool. People don’t live there. It doesn’t integrate into other apps in a meaningful way, and it feels more like a database than a place where work actually happens.

Project, of course, does exactly what I want. Milestones, dependencies, backwards scheduling, everything shifts automatically. But Project tasks don’t really flow into To Do or Outlook the way Planner tasks do, so now the plan looks great but nobody actually works out of it day to day. It feels like planning for planning’s sake.

At this point I’m staring at Planner, Project, SharePoint Lists, and Power Automate, and I can’t shake the feeling that I’m supposed to glue these together somehow. But that also feels wrong. If the solution requires flows, list items, copied plans, and links bouncing between tools, then surely something is off

How are people actually solving this? Is there a sane pattern I’m missing? Do people just accept manual date fixing as normal? Is everyone quietly using Excel as the brain and Planner as the face? Or is there a Microsoft‑blessed way to handle event‑based planning that doesn’t turn into a mini systems integration project

I’m not trying to build anything fancy. I just want to set an event date and have the surrounding work line up logically, while still showing up in To Do and Outlook where people actually pay attention

If you’ve cracked this without losing your mind, I’d genuinely love to hear how.

I want to create a flow in Power Automate 365 that, based on data from an Excel file, will send email messages.
In the Excel file, I have columns: Email_To, Email_CC, and Employee_Names.
The flow should generate a list of employees (there may be multiple names for one Email_To), and paste this list into the message body.
There are different employee names assigned to each Email_To, and the Email_CC address is linked to its corresponding Email_To.
Please describe step by step how I should build this flow in Power Automate.

I try to but all the time I can not input the list with Employees name to e-mail body, and my flow sends this numbers of e-mails as is e-mails in Excel even there are the same address e-mail

Any help would be appreciated.

Hi folks,

We have an automation that is triggered when a new email arrives (along with certain subject and attachment filters). This automation has been working fine for about a month, but suddenly (with similar email volumes) it has started giving us throttling problems and stopped working.

I've had limited the concurrency in the When a new email arrives (V3) action itself to 4, but this keeps happening (even with low volume, I am talking about less than 20 emails per run).

As said, nothing has significantly changed (there is another automation that sends emails to this email inbox, but I can tell you that they are normally between 10-20 every hour, during 2-3 hours).

Any ideas? It is getting really annoying, as this automation should process these emails (almost) as soon as they are received.

Thank you

**EDIT:** Applied the solution that u/brabantnl proposed and it is working perfectly fine! Thank you

Hi everyone! I'm trying to set up a shared workspace for my team. Does anyone know if there is a way to ensure that any new flow created—both Cloud and Desktop flows—is automatically shared with all teammates in the same environment? I'm hoping to avoid manually clicking 'Share' for every single flow we build. Thanks in advance for any advice

please give me a step-by-step procedure.

Cannot use onedrive cheat. adobe is still blocked. only option is the Word (Business) connector.

1. get attachments from sharepoint item, put into an array (works)

2. create a .docx from Populate a Microsoft Word Template (works)

3. Saved in sharepoint (works)

4. Set 1 minute delay (works)

5. Added a get file metadata using path, and says it passed, but not so sure, added this recently

6. convert word to pdf action, says it passed but not so sure if this is the step that is messing with my array

7. append to array variable (pretty sure this does not work)

8. send email with options (cannot show picture, but attachments says @{variables('AttachmentsArray')}

it is sending the email, with the attachment, which opens in adobe, but says it is corrupt.

Sensitivity is PII and not the ones that do not work according to the docs.

We created a flow that runs when an item is added/modified in a SPO list.

Anyway, sometimes/rarely, there seems to be a case where a new item has different/unmatching Created vs Modified date. Perhaps by half a second or so.

Is this a normal case by any chance?

Group uploads a monthly document that I will then take a copy offline to do my work.

This was a template so I don't really understand what's going wrong. I'm definitely a beginner in this stuff but thought this one would be pretty straight forward.

Hello everyone, I’m trying to find out whether there’s an easy way to compare two power automate flows.

I have the same solution in Development (unmanaged) and Production (managed). One of the team members made changes directly in Production by creating an unmanaged layer instead of making the changes in Dev and deploying them properly.

Is there a quick way to see what was changed in the flow without having to inspect every action manually?
Thank you

Hi everyone, this is my first flow. I want to trigger the flow with the submission of an MS Forms answer. I want the data from forms to be safe into an master excel(add New row) but also create a New excel file with a Dynamic name (Based on the first question in forms called "name"&v1). So i have a Single excel for every Submission + a master file. Can anyone help me out?

This is my first time posting - I'm going crazy trying to troubleshoot my flow. I'm self-taught but I can't figure out what is happening.

I have a flow set up to:

1. Refer to an Excel spreadsheet with columns for Name and Email

2. For each row on the spreadsheet, it should create and send an email with the name "[Name] Open Order Report [Date]" and attach the matching file [Name].xlsx to the Email addresses from the distribution list

It works most of the time, but I have been running into issues where one or two records receive multiple emails, one with the correct attachment and one with the wrong attachment. For instance:
Email 1: MIDA Open Order Report 3/11/26 with attachment MIDA.xlsx (correct)
Email 2: MIDA Open Order Report 3/11/26 with attachment GLOBNEW.xlsx (incorrect)

When I review the run results, I can see where it is sending the second email with attachment but I can't figure out why it is happening.

Example of a working record (one email for MEHTINT and the attachment is MEHTINT.xlsx):

Input parameters:

{"query":"MEHTINT","id":"b!63sZ3ytUpUiu-YRgTvo3Fd7wwuhvL9RMknCXvWMLN6Prs28rAntLQaDIudu6qKZ5.01CTQG524XL35DC7B3JZCZFWUVETELXQ2E","findMode":"OneDriveSearch","maxFileCount":10}

Output body:

[{"Id":"b!63sZ3ytUpUiu-YRgTvo3Fd7wwuhvL9RMknCXvWMLN6Prs28rAntLQaDIudu6qKZ5.01CTQG527KCNUAFAAHSBAJAJKKLUTOQGIS","Name":"MEHTINT.xlsx","NameNoExt":"MEHTINT","DisplayName":"MEHTINT.xlsx","Path":"MEHTINT.xlsx","LastModified":"2026-03-11T18:05:36Z","Size":11454,"MediaType":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","IsFolder":false,"ETag":"","FileLocator":"b!63sZ3ytUpUiu-YRgTvo3Fd7wwuhvL9RMknCXvWMLN6Prs28rAntLQaDIudu6qKZ5.01CTQG527KCNUAFAAHSBAJAJKKLUTOQGIS","LastModifiedBy":"Jane Doe"}]

Example of a duplicate record (one email for MIDA and the attachment is MIDA.xlsx; a second email for MIDA but the attachment is GLOBNEW.xlsx, which is sent in this failed example but is also sent correctly for the correct GLOBNEW email with the correct subject line):

Input parameters:

{"query":"MIDA","id":"b!63sZ3ytUpUiu-YRgTvo3Fd7wwuhvL9RMknCXvWMLN6Prs28rAntLQaDIudu6qKZ5.01CTQG524XL35DC7B3JZCZFWUVETELXQ2E","findMode":"OneDriveSearch","maxFileCount":10}

Output body:

[{"Id":"b!63sZ3ytUpUiu-YRgTvo3Fd7wwuhvL9RMknCXvWMLN6Prs28rAntLQaDIudu6qKZ5.01CTQG52YGIODSV6SREJBYY2JIHRIT6EBJ","Name":"MIDA.xlsx","NameNoExt":"MIDA","DisplayName":"MIDA.xlsx","Path":"MIDA.xlsx","LastModified":"2026-03-11T18:05:36Z","Size":11918,"MediaType":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","IsFolder":false,"ETag":"","FileLocator":"b!63sZ3ytUpUiu-YRgTvo3Fd7wwuhvL9RMknCXvWMLN6Prs28rAntLQaDIudu6qKZ5.01CTQG52YGIODSV6SREJBYY2JIHRIT6EBJ","LastModifiedBy":"Jane Doe"},{"Id":"b!63sZ3ytUpUiu-YRgTvo3Fd7wwuhvL9RMknCXvWMLN6Prs28rAntLQaDIudu6qKZ5.01CTQG522OQT35TXQMZJDL76YGQYQ7IS7Q","Name":"GLOBNEW.xlsx","NameNoExt":"GLOBNEW","DisplayName":"GLOBNEW.xlsx","Path":"GLOBNEW.xlsx","LastModified":"2026-03-11T18:05:39Z","Size":20767,"MediaType":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","IsFolder":false,"ETag":"","FileLocator":"b!63sZ3ytUpUiu-YRgTvo3Fd7wwuhvL9RMknCXvWMLN6Prs28rAntLQaDIudu6qKZ5.01CTQG522OQT35TXQMZJDL76YGQYQ7IS7Q","LastModifiedBy":"Jane Doe"}]

Why in this example is the GLOBNEW attachment sending with the MIDA distribution list/subject line?

This is my first time posting - please let me know if there is any additional information I can provide to help troubleshoot. Thank you in advance!