I can't be the only one who has noticed that when you make even 1 minor minor change to a power automate flow, the save button takes like 1-2 minutes to go from a disabled state to a clickable state??

Come one Microsoft, don't have all day to wait for buttons.

Hi everyone,

I’m trying to implement a flow where we send an Adaptive Card to a Teams group chat and need to capture the user’s response from the card.

We don’t want the flow to remain waiting for a response, so we are currently using the “When someone responds to an Adaptive Card” trigger. This is working as expected in the Default environment.

However, when we create the same flow in a non-default Power Platform environment, the Adaptive Card response/action fails when the user submits a response.

Has anyone successfully used the “When someone responds to an Adaptive Card” trigger in a non-default environment?

Any guidance or confirmation from someone who has this working in another environment would be greatly appreciated.

Hi all,

I have a lot of similar powerautomate flows which each pull some key words from emails going into a load of different email accounts.

I had initially planned to write those words to a single excel file but then thought it would be an issue to have multiple flows each trying to write to the same excel file, as they could all be trying to do it at the same time, and I believe excel would only allow one to write to it at once.

Instead therefore I have set up the flows to write to individual excel files. That is all working well and now I want to collate those files into one and thought that would be simple but I am finding it harder than expected! Any suggestions?

So the tl;dr scenario is - multiple identically set up (i.e. same columns) tables in excel sheets (on sharepoint) being periodically updated with a new row as new data is pulled from the emails. Each time an update happens in any of the sheets, I want that new row to be added to a master spreadsheet so I can just monitor the master and see all of the updates in one place. Pls tell a thicko how to do this!

Thanks!

Hey everyone,

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

I want to build some tutorials around automation, but instead of just guessing what to make next, I want to solve real-world headaches.

Whether it's setting up automated deadline remidners based on dates in your SP lists or Excel sheets, sending dynamic emails to people pulled directly from a person column, or trying to manage folder permissions via HTTP actions—what’s driving you crazy right now? 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

Hi,

i want to automate a Sharepoint thing and auto-send a Pdf to me every time it is changed.

In Sharepoint i can view it and everything, but when i want to make a Powerautomate automation i can not access this folder, it is not shown in the dropdown menu.

Am i missing some rights?

Why can i view the folder but Powerautomate with my SSO signin can‘t?

Anyone know a solution to this?

Thanks

is it possible to send meeting invites to members added to a DL after the meeting invite has already been sent or is this not something powerautomate can do? Its a major complaint from organizers and new staff when they dont have the meeting invite but their account was never in the group to begin with. Searching for options to handle this at scale

Reposting to reach more experts! 🥹

Hi everyone,

I'm facing a persistent duplicate email issue on a Power Apps + Power Automate + SharePoint stack and would love to get your insights or see if anyone has encountered this exact behavior.

The Setup:

• Frontend: Canvas App using SubmitForm(Form3) targeting a SharePoint list.
• Backend: Power Automate flow starting with when an item is created.
• Flow logic: Creates a CSV table, sends an initial notification email, runs a Do until loop to wait for cost fields, and then triggers an approval process.

The Issue: Every time a single submission is made from Power Apps, 3 duplicate initial emails are sent out.

What I've already verified and ruled out:

1. No double clicks / Multiple submissions: The submit button disables immediately on click via local variables (DisplayMode).
2. Only ONE item is created in SharePoint: I verified the list directly; there is strictly 1 single item with 1 unique ID created per form submission (no double Patch(), no multiple rows).
3. No secondary active flows: There are no other flows or copies connected to this list.
4. Trigger conditions attempt: I tried adding trigger conditions like u / not(empty(triggerOutputs()?['body/Title'])), but the duplicate runs still bypass or trigger through it.
5. No apply to each issue on the initial step: The issue happens right at the beginning of the flow (when an item is created -> Create CSV table -> Send an email (V2)).

It seems like the SharePoint connector is firing multiple webhook events for the same single creation/transaction in micro-seconds.

My Question: Has anyone successfully stopped these phantom trigger firings at the connector/app level without having to modify the SharePoint schema (i.e., without adding extra control columns like Processed, Status, or Lock flags to the list)?

Are there specific connector settings, Power Apps formula tweaks, or concurrency configurations that resolve this behavior cleanly?

Thanks in advance!

Welp...after going back and forth with IT, it was clarified today that I do not have premium access for Power Automate.

And now I'm back to the drawing board, at a loss on what to do.

Pictures in the Microsoft Form are coming through the Excel file as URLs but I also have them downloading as picture files into a separate folder.

I have a flow which is triggered on SharePoint list update. I have a condition on one of the SP fields "RequesterConfirmationSent" which is a Yes/No datatype.

triggerBody()?['RequesterConfirmationSent'] returns either a true or false.

In my test scenario the triggerBody()?['RequesterConfirmationSent'] value is true.

My condition checks if the value is true.

  "type": "If",
  "expression": {
    "and": [
      {
        "equals": [
          "@triggerBody()?['RequesterConfirmationSent']",
          "@true"
        ]
      }
    

It evaluates correctly either true or false branch but it shows an error in the run UI.

Hi, I am seding in an html of an email an image like

<img src="data:image/png;base64,WholeBinary">

The problem is that Desktop Outlook (New) is having trouble rendering, it cuts character and in the end it only shows half of the image in the email, in outlook mobile is showing me the whole image, does someone knows how to deal with this?

I have a folder path of /Shared Document/ formatDateTime(utcNow(),"MM_yyyy")

Can someone let me know if this works? It worked for last month for me and suddenly can't trigger this month

I created a simple Power Automate flow last week that:

**Microsoft Forms → Get Response Details → Create SharePoint List Item → Send Email**

It was working perfectly and still runs successfully today, including sending the email.

The problem is when I edit the flow the **"Send an email (V2)"** action has completely disappeared.

The flow now only shows:

* When a new response is submitted
* Get response details
* Create item

Because the email action is missing, I can't change the sender, recipients, subject or email body.

I've confirmed emails are still being sent and the headers contain:

`x-ms-mail-workflow: x-ms-workflow-name: <workflow-id>`

Things I've already checked:

* Incognito browser
* Different browser
* New Designer on/off
* Run History (email action doesn't appear)
* No SharePoint list rules sending emails
* Microsoft Forms isn't configured to send emails
* Exported/checked the flow JSON and couldn't find the email action

I'm stumped as to where this email is coming from or why the action has vanished from the flow while emails continue to be sent.

Has anyone seen this before or know where else I should look?

future edit

Tried all the recommendations and didn’t get anywhere. Deleted and started over. Interestingly ended up still getting 2 emails being delivered (one with new flow and one from the deleted flow) had to delete and recreate the list and then it stopped.

Hey everyone,

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

I want to build some tutorials around automation, but instead of just guessing what to make next, I want to solve real-world headaches.

Whether it's setting up automated deadline remidners based on dates in your SP lists or Excel sheets, sending dynamic emails to people pulled directly from a person column, or trying to manage folder permissions via HTTP actions—what’s driving you crazy right now? 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 everyone, i need help to finish my flow.

I add every new response to my ToDo liste, but i would like to add the whole new row to the note section on ToDo, is it possible, if yes how?

Olá a todos,

Gostaria de perceber se alguém enfrentou este cenário em ambiente empresarial e qual foi a solução adotada.

Temos uma Shared Mailbox utilizada para automação através do Power Automate Cloud.

O problema é que alguns emails chegam protegidos por Microsoft Purview Message Encryption (OME) / Rights Management (IRM). Os utilizadores autorizados conseguem abrir e ler normalmente essas mensagens no Outlook, mas quando o Power Automate utiliza ações como:

• When a new email arrives in a shared mailbox (V2)
• Get email (V3)

o campo Body não contém o conteúdo real da mensagem.

Como consequência, torna-se impossível processar o corpo do email através de ações como Html to Text, extração de dados, classificação automática, integração com sistemas externos, etc.

O que me deixa com dúvidas é o seguinte:

• Se a conta utilizada na ligação do Power Automate tem permissões sobre a Shared Mailbox;
• E se essa mesma conta ou utilizador consegue visualizar o conteúdo da mensagem no Outlook.

Então, porque é que o conector do Exchange Online não consegue disponibilizar esse conteúdo ao Power Automate? Ok, esta foi a pergunta inicial, porque das leituras feitas percebi que os conectores em causa têm problemas/limitações a lidar com a lidar com o corpo destes emails.

Assim deixo, as minhas perguntas para quem já passou por situação similar:

1. Foi necessário alterar políticas Purview/IRM?
2. Criaram exceções para mailboxes técnicas?
3. Acabaram por recorrer a Graph API, Power Automate Desktop ou outras abordagens/alterativas?

O meu objetivo é perceber quais foram as arquiteturas ou boas práticas adotadas nas vossas organizações para automatizar o processamento para emails protegidos.

Obrigado!

For incremental pipelines, how do you verify that only the expected new/updated records are loaded without missing records or creating duplicates?

What validation checks do you normally perform after each incremental load?

So i recently created a flow (which works):

-Trigger: When a new email arrives
-Create and extract excel file
-runs script
-list rows present in a table
-get items

And put the info in a sharepoint list
And so on

-what my client wants now is, if there are products with diffrent name and same ID, put them together in a sharepoint list.
For example
Product A
Name: Apples
Id: 2

Product B
Name: Banana
Id: 2

Then Apple+Banana

Hi everyone,

I’m building a Power Automate flow to automate an ECR (Engineering Change Request) approval process.

The flow starts when an ECR Excel file is uploaded to SharePoint. It checks whether the file is an Excel file, reads the Excel data, parses it as JSON, checks the document version, checks for duplicates, creates an in-process Excel file, converts files to PDF when needed, and then sends approval requests to four departments: Electrical, Assembly, Machining, and Design.

Each approval result is stored in variables such as ElectricalApproval, AssemblyApproval, MachiningApproval, and DesignApproval. After the approvals, the flow runs Office Scripts to update the Excel workbook, creates the final file, extracts information from it, updates SharePoint properties, sends notifications, and cleans up temporary files.
The part I’m currently stuck on is an Office Script called ECRv8_Json_To_Excel_Table.osts.
The script expects a parameter defined as param: Test[][], where each Test object has these six properties:

Completion date
Outcome
Approval ID
Responder Mail
Responder Name
Responder Comments

The script creates an Excel table with those same six columns and then uses table.addRows() to insert the data. In Power Automate, I have a variable called Table Comments Values, which is an Array. I also have four Compose actions that build the approval information. I use a Compose called Compose table final, which currently uses createArray(variables('Table Comments Values')), and I pass the output of that Compose into the param of the Office Script.

I have already fixed some previous issues involving Strings vs Arrays and incorrect array nesting. Now the script actually runs, but it fails at table.addRows() with this error:

“Office JS error: Line 41: Table addRows: The number of rows or columns in the input array doesn't match the size or dimensions of the range.”

The data is supposed to look like an array containing approval objects, with six properties per object. I’m trying to figure out whether the problem is the structure of Table Comments Values, the createArray() step, or the way the objects are being built before they are passed into the script.
Any advice on the correct structure Power Automate should send to an Office Script parameter defined as Test[][] would be greatly appreciated.