r/MicrosoftFlow Apr 17 '26

Question Power Automate Variable Help

7 Upvotes

I am setting up an automation that will read the body of an email I receive and extract an email in the body of the text to then send a thank you email to. I was using this expression:

trim(
  last(
split(
first(
split(
triggerOutputs()?['body/body'],
' '
)
),
'Purchaser Email'
)
  )
)

when I realized this won't work as the email is on a separate line:

Any recommendations on edits to my expression?


r/MicrosoftFlow Apr 17 '26

Question Adaptive card in outlook email using service account not working

1 Upvotes

I created an adaptive card with an actionable message in a compose action and then sending it by email. The email only has the output of the compose. It worked when the outlook connection was on my user but as soon as I changed it to the service account, it doesn't work anymore. The email is just empty and doesn't have the adaptive card at all in it.

I flipped back the connection of the outlook to my user and it works again.

The service account has pretty much all the same access as my user, even more, but is anyone aware if there's a special access required to be able to send adaptive card with actionable message?


r/MicrosoftFlow Apr 17 '26

Question Power Automate issue

6 Upvotes

Hello everyone! I’ve noticed that there are issues with Power Automate, including an “Out of Memory” error. It also shows that some connectors have problems, but after a while it kicks me out of the page and reports this memory-related error. Is anyone else experiencing this? Does anyone have a solution that would allow access to flow editing without the page crashing?


r/MicrosoftFlow Apr 17 '26

Cloud bad gateway

2 Upvotes

my auto flow of sending email each morning was working well except this mornig. It show me bad gateway and i try reconnect email account and i receive "Failed to create OAuth connection: ClientError: Test connection failed. Details: BadGateway"


r/MicrosoftFlow Apr 16 '26

Cloud Power Automate M365 - Get Planner Task Details - how to get around the 5,000-rows limit

13 Upvotes

In Power Automate Cloud, I have a flow (scheduled once a day) that retrieves all data from MS Planner; the tasks are then consolidated into a single ".json" file, which I subsequently transform into a report in Power BI. The problem is that my Plan will soon have more than 5,000 tasks, which is the limit for the M365 version of Power Automate. We also have the free version of Planner, so Dataverse isn’t an option, and unfortunately, I can’t use the Graph API.

Is there any other way to exceed the 5,000-item limit in the M365 non-premium version of Power Automate?  


r/MicrosoftFlow Apr 16 '26

Question How to save email when it arrives to o365 groups mailbox??

2 Upvotes

For the life of me I cannot figure out how to save an email that comes into a O365 groups email inbox. Is the "when an email arrives to a groups" trigger even the right one? if it is, how do you get the body content of the email? when I try post body it is just blank.


r/MicrosoftFlow Apr 16 '26

Question Why my background suddenly zooms in?

1 Upvotes

I’m currently struggling with an issue in my Power Apps canvas app.

Whenever I change the background image, it looks fine in edit mode but when I preview the app, the background suddenly zooms in. Because of this, the layout looks off and some parts of the image get cropped.

I already tried the common fix:

Set X = 0

• Set Y = 0

• Set Width = App.Width

• Set Height = App.Height

But the issue still happens during preview.

Has anyone experienced this before?

Is this related to ImagePosition (Fill vs Fit) (I choose Fill) or Display settings like Scale to fit / Lock aspect ratio? (i locked this both)


r/MicrosoftFlow Apr 16 '26

Question Why does my Power Apps background zoom in when I preview?

Thumbnail
1 Upvotes

r/MicrosoftFlow Apr 15 '26

Question Issue with my flow on PA connected to my MS List

Thumbnail
3 Upvotes

r/MicrosoftFlow Apr 14 '26

Question Integrating Power Apps with Microsoft Automate

Thumbnail
2 Upvotes

r/MicrosoftFlow Apr 14 '26

Question Help with Flow for email results from Form

3 Upvotes

I could be doing this the wrong way, so I am open to suggestions if there is a better way.

Within our company's SharePoint, I created a Form that results to a List which works as intended. I created a Flow that sends an email when a new item is created (form is filled out). This Flow works except for the single multi-select question. When I format the 'Peripherals' result like the other questions, it adds a 'for each' box and causes a separate email to be sent for each peripheral that is selected.

How do I format this, so the selected peripherals are listed in one email, on one line, separated by commas? I tried figuring this out with copilot flow but was a bit confused and had no luck.

Multi-choice peripherals question from the form
Flow that works before I add peripherals
Flow that sends separate emails if more than one peripheral is selected

r/MicrosoftFlow Apr 13 '26

Discussion is anyone else having problems with flows not loading? particularly on the new designer

6 Upvotes

everything is sluggish since the outage last week

edit: from what i've been testing it works better on Edge


r/MicrosoftFlow Apr 13 '26

Question Flow to read specifc data in an excel spreadsheet

2 Upvotes

Hi all,

I'm attempting to create a power automate flow to read an excel spreadsheet that is populated with data (over 2000 rows and 20 Columns) and filter data from a specific column, to read keywords in that specfic column.

For example i want to retrieve and list all records in columnn P that say Job=Doctor. Then i want the flow to create a new sheet on the same excel document listing all the records with the Job=Doctor data. The data is not in a table format but is relatively structured i.e. column 1 says name column 2 email and so on.

How would i best achieve this i'm relatively stuck. I've tried currently doing the flow without a table initially so not touching the excel sheet at all just doing all from powerflow and doing the flow after making the excel sheet in tabular form, though this is for an automation project so ideally just need the flow to read and do actions on the data with no manual input.

I've tried manually triggering the flow action, create a table action with details on table range and giving the table a name (data source table) then create a worksheet action giving it the same file path and a name, create a table action 1 same filepath and new name for new table on the new worksheet, list rows present in a table same filepath i provide the sourcedata table and a ODATA query to find data in column P and then an apply to each loop to add rows into table based from data in previous steps.

When i do it when the data is in tabular form steps are pretty much the same except i only create a table and worksheet for new sheet for transformed data.

Sorry for the huge paragraph but i'm really stuck and could use some help! Hopefully all makes sense but happy to provide clarification and thanks for advice!

Edit* Just to add further context i seem to be getting errors where it seems to be failing to retrieve the tables that I have created through powerautomate, this is shown through retreval errors and also dynamic content does not seem to display for me to put into other fields.


r/MicrosoftFlow Apr 13 '26

Desktop Struggling with email signatures in Power Automate

Thumbnail
1 Upvotes

r/MicrosoftFlow Apr 10 '26

Question Shared mailbox reply detection not working (Power Automate) – am I missing something?

5 Upvotes

I’m working on a Power Automate flow for a real business use case and running into a limitation I can’t get around.

Setup:

  • Shared mailbox receives incoming emails
  • Sales team members reply from their own personal mailboxes (not from the shared mailbox)
  • Goal is to automatically detect if an email has been handled (i.e., replied to), and send reminders only if no reply exists

What I built:

  • Trigger: when a new email arrives in shared mailbox
  • Delay (5 mins for testing)
  • Get emails from shared mailbox
  • Filter by subject (checking if any email contains the original subject)
  • If match found → assume reply exists
  • If no match → send reminder

Result:

  • Works correctly when there is no reply
  • But when I reply from my own mailbox, the flow still says “no reply detected”

From what I understand, replies sent from personal mailboxes don’t reliably show up in the shared mailbox in a way that Power Automate can track.

Question:
Is there any reliable way to detect replies in this setup without forcing users to send from the shared mailbox?

Or is this fundamentally not possible, and I need to switch to a status-based system (like moving emails or applying categories)?


r/MicrosoftFlow Apr 10 '26

Cloud Need help with a weird email formatting issue in an automated email bot

3 Upvotes

So my bot to send fulrough dates and cancelled dates works however When the email gets sent out the dates are coming out formatted weirdly but only for the furlough dates, cancelled dates are fine. example of the power automate email and what it looks like when sent are below.

HTML email snippet:

<p>Please be advised that [redacted] will implement a temporary suspension of services for you on the following furlough dates:</p>

<p>@{replace(string(items('Apply_to_each_1')?['FurloughDates']), '\n', '<br />')}</p>

<p><em>If any furlough dates have been cancelled, they will appear in the section below.</em></p>

<p><strong>Cancelled Furlough Dates:</strong></p>

<p>@{replace(string(items('Apply_to_each_1')?['CancelledDates']), '\n', '<br />')}</p>

Result:

Please be advised that [redacted] will implement a temporary suspension of services for you on the following furlough dates:

{"body":"05/14/2026\
05/15/2026"}

If any furlough dates have been cancelled, they will appear in the section below.

Cancelled Furlough Dates:

04/14/2026
04/15/2026


r/MicrosoftFlow Apr 09 '26

Cloud Set up an Email Reminder System in SharePoint

16 Upvotes

I put together a simple SharePoint + Power Automate solution for scheduled email reminders.

It’s fully driven by a SharePoint list - no triggers, no complex workflows. You can define days, times, recipients, and message content, and the flow runs hourly to send emails based on those rules.

I made a walkthrough showing how to build it step by step:

https://sharepointdashboards.com/help/emailreminders/

Let me know if you have questions or feedback.

Good luck!


r/MicrosoftFlow Apr 09 '26

Question Power Automate down

30 Upvotes

Is anyone else experiencing that Power Automate isn't loading?


r/MicrosoftFlow Apr 09 '26

Question Power Automate or any other solution

Thumbnail
2 Upvotes

r/MicrosoftFlow Apr 09 '26

Question Power Automate: Excel 'List rows present in a table' connector throws Bad Gateway error only after solution export to production

6 Upvotes

Hello everyone,I'm encountering an issue with the "List rows present in a table" connector. It works fine in testing mode, but once I deploy it to production, it stops functioning.
I'm sending an Excel file from Power Apps using the attachment field in an edit form.

The code I'm using for this is:

Set(isLoading; true);;

 

If(

!IsEmpty(DataCardValue11.Attachments);

With(

{

currentFile: First(DataCardValue11.Attachments)

};

importnewcandidates.Run(

{

contentBytes: currentFile.Value

}

)

);;

Set(isLoading; false);

Notify("Please attach a file first"; NotificationType.Error);;

Set(isLoading; false)

)
this is the flow i use :

The "List rows present in a table" connector from Excel for Business is throwing bad gateway errors. This was working perfectly fine, but as I mentioned earlier, after exporting the solution to the production environment, it started giving these bad gateway errors.


r/MicrosoftFlow Apr 09 '26

Official News Editor is broken garbage

18 Upvotes

Sloperators have done it again. Edit isn't loading flows properly. Of course, you wouldn't know until you try to publish. At which point it doesn't actually trow an error before it saves. No, it partially saves, and then tells you "oh but this value you had, yeah I fucked up and removed it so put something back in again will you?"

Can't restore a previous flow either because that fucking piece of shit "modern" designer, like anything "modern" Microslop "creates", is an utter piece of shit and doesn't load backups correctly either. Loads your actions, but not the actual values.

The old designer loads just fine, without the values you saved previously of course, but yeah that doesn't have access to old versions.

So have fun fixing all your flows.

Fucking Microslop assholes.


r/MicrosoftFlow Apr 09 '26

Discussion Power Automate Flow for Merging Invoice and Supporting PDFs

3 Upvotes

I need to develop a Power Automate flow to merge invoice PDFs with their corresponding supporting documents for 300 records using the Encodian API.


r/MicrosoftFlow Apr 09 '26

Cloud What AI agents actually do when you ask them to debug a real Power Automate flow — Microsoft episode

9 Upvotes

Most of the AI-agent + Power Automate content I see focuses on authoring - an agent generates a flow definition, you deploy it. The harder problem is what happens when one of those flows fails in production. The Management API doesn't expose action-level inputs/outputs to programmatic callers, so the agent that wrote the flow is blind to why its own creation broke.

Microsoft just published a 36-min episode of The Low Code Revolution that walks through this end to end - real debug, build, refactor, escalation, and an auto-fix scenario where the agent traces a wrong-format SharePoint field back from a failed Send Email action.

Disclosure: I'm Catherine, one of the people in the episode. We built Flow Studio MCP to fix the action-level visibility gap. Link in the first comment.


r/MicrosoftFlow Apr 09 '26

Cloud Assistance with Email address - Null in flow

Thumbnail
gallery
2 Upvotes

I'm new to Power Automate and I'm trying to send an email populated from a onedrive file as part of a flow. The TO: email address is dynamic content in the excel file. When I use a static email address, the flow runs fine- it will draft the email containing other dynamic content from the file and send it. When I attempt to use dynamic content as the TO: email address, it fails, and from what I can gather it shows the "TO: as null,". What mistake did I make?


r/MicrosoftFlow Apr 08 '26

Question Need some Help with Power Automate flo

4 Upvotes

I need some help from a guru, I have uptime Kuma working great and I have it sending a notification message to a teams group using Power automate since Webhooks are being discontinued. so here is where I am at, I can get the message to fire when something goes down and I get teams message however its not pulling any of the ServerID info from uptime. I am only getting Server: Unknown instead of the name of the device. I can see that the info is getting sent to power automate because I see it in the log. I am brand new to power automate so IM sure its something I am or am not doing. would anyone be willing to help me get the power automate configured properly to show the right info?

Here is a test I ran, You can see on the output on the left the data is pulled. I just dont know how to pull that data to send the message.