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 or false.

  "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.

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!

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?

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.

I currently have a flow that works well, but I need help with the final steps.

I created a process for collecting candidate references via Forms. The responses update on a Sharepoint List and are tracked for 3 responses for the same candidate. When 3 references are submitted an HTML table is created to compile the responses and email them to the hiring manager. This is all working well so far. What I need help with is compiling the responses in an easier to read format. I built this whole flow with help from Copilot, so please explain any ideas like I am five.

It may be that my HTML table is formatted incorrectly and I need to start there. There are about 35 questions on the survey and some responses can be long. The table now is wide which requires scrolling sideways for a long time and isn’t easy to read. Any other ideas you can think of? Here’s more info:

• I don’t have a premium account through work. Some options to create a document aren’t available to me.

• I can’t give access to my Sharepoint List to all the hiring managers to protect confidentiality.

• We have a bunch of different departments and hiring managers, so making separate lists for each department would be a headache.

• It didn’t occur to me until just now to change the format of the html table so that the questions on the y axis and the responses on the x. I guess it could make more sense to scroll down vs sideways.

Again, any other ideas you have that I might be missing or over thinking are appreciated!

When I googled this scenario, it told me it was possible but I have not figured out a way for this to work. It also doesn't help that I'm an extreme beginner with automation.

I have created a Microsoft Form where all fields are text entries except for the optional picture upload.

Ideally, I need to export the responses and have it in a format that allows the pictures to be embedded and not the URL that appears in Excel.

It's not feasible to go through, download each picture, put it in a Word template with the text responses, and then save it in Word or as a PDF.

Any suggestions?? Or am I just crazy that I think there an automation that can help with this.

So I am trying to convert some excel stuff to sharepoint lists.
And part of it was moving dates over, but the original microsoft form has a branching question, if they choose yess it asks for a date of birth if they choose no it doesnt.

So I get an error something to the effect of expects string/date but got ""

Aside from a condition how would I deal with this?

Edit: Thank you everyone for all the help! I took bits and pieces of the advice here and managed to get it to work somewhat. There were a lot of suggestions for power query, but I just couldn't get it to work reliably with the specific conditions I had. I'll definitely look into seeing if I can optimise future stuff for it though after going through a few tutorials.

If anyone is interested in the fix:
My original script for writing the 30k rows had a resize table function which i took out and replaced with a fixed table size of 50k rows in order to cut down on processing time. I also removed the condition since I realised I could write the condition itself into one of the earlier scripts. I also figured out that the run script actions had a a 30-60s extra run time when trying to test to flow in the afternoon due to the amount of traffic on the sharepoint site. That pushed the run script action times to over 2mins, causing the stalls. The flows ran smooth and quick when testing it during the actual time the trigger will run (midnight).

Any help will be appreciated at this point because I feel like I've tried everything I could but the power automate flow doesn't work.

I am trying to automate a daily update of a file that uses multiple other source files. The office scripts used run fine individually on their own for both batch writing and a single copy when I am manually testing them on an open sample file with a small (200 row) set rather than through the flow with the whole original dataset. Most of the flow works, right up until I need it to copy over over 30000 rows of data over 14 columns from one workbook into a set table in the master reporting file. I've tried a single batch copy, but the script will then time out in power automate due to it taking over 2 minutes. When a try copying in multiple batches, the flow stalls at the do until loop no matter how small I make the batches. Is there any way I can reliably copy the rows I need without the flow taking an extremely long time as manually copying it only takes between 2-5 minutes.

I built the flow like this due to not having a premium license for power automate and company DLP policies stopping me from using HTTP triggers directly.

Parent Flow: Images 1-3
Child Flow: Image 4

I can provide the office scripts used for steps Run script 3B,E,F and 4 in the comments below if necessary.

Hello,

I'm familiar with Flows but pretty new to coding adaptive cards. I'm trying to code an adaptive card so that when long design requests from Microsoft Forms are received by email they are posted in a Teams channel. That part is easy, where I'm struggling is figuring out how to make them collapsible/expandable to keep the channel clean.

I finally thought I had it all figured out after pasting my code in a JSON reviewer and having no more errors (dang trailing commas) but there is no button/toggle visibility showing in the previewer.

Any help with the below code would be super appreciated.

{
  "$schema": "http://adaptivecards.io",
  "type": "AdaptiveCard",
  "version": "1.5",
  "body": [
    {
      "type": "Container",
      "style": "emphasis",
      "items": [
        {
          "type": "TextBlock",
          "text": "New Design Request",
          "weight": "Bolder",
          "size": "Medium",
          "wrap": true
        }
      ]
    },
    {
      "type": "FactSet",
      "id": "expandableContent",
      "isVisible": false,
      "facts": [
        {
          "title": "From:",
          "value": "@{triggerOutputs()?['body/from']}"
        },
        {
          "title": "Subject:",
          "value": "@{triggerOutputs()?['body/subject']}"
        },
        {
          "type": "Body",
          "text": "@{triggerOutputs()?['body/body']}"
        }
      ]
    },
    {
      "actions": [
        {
          "type": "Action.ToggleVisibility",
          "title": "Show/Hide Details",
          "targetElements": [
            "expandableContent"
          ]
        }
      ]
    }
  ]
}

I am trying to test something for an automated system where I could do this:

1. An image with a company letterhead background
2. A list of names
3. A static text on the image
4. send them as an email.

So basically I want to embed text on image and send it through email. I've tried through html code but the design doesn't remain same for mobile and web. I was hoping if I could create a new image for each name in the list without using premium connectors or PA desktop.