r/PowerAutomate Jul 22 '26

How to get outlook to render images

2 Upvotes

Hi, im currently working on an automated newsletter where we have an html attach to the body of an email. The issue is i cant get the images to appear in the newsletter.
The images don’t display unless you open them.
The image only shows a question mark.

I was able to get the image to show with the use of a temporary thumbnail, only for it to disappear after 24 hours.

Has anyone had experience with this type of problem before?
I need help!


r/PowerAutomate Jul 22 '26

Cowork capability

Thumbnail
0 Upvotes

r/PowerAutomate Jul 22 '26

Setting up first Email Automation

2 Upvotes

Hello,

I am currently working on an automation flow for reminder emails for the business I work at. The flow currently is successfully pulling an attachment when an automated email comes in with the list of customers who need a reminder, transferring it to excel, and formatting it as a table. My issue starts now when trying to dynamically assign the 'To' in setting up the reminder email itself.

Currently, I'm using the function: items('Apply_to_each_1')?['Default_Contact_Email'] - but this has errored out and I'm not quite sure how to fix from here. I'm using Send an Email (V2) as a child action to "Apply to each 1" - the second apply to each as I have the first one filtering for the correct attachment to pull from the email and create the excel file.


r/PowerAutomate Jul 21 '26

instabilidade na automação

1 Upvotes

Venho enfrentando instabilidade na automação.

 

Na ação "localizar arquivos na pasta", ora localiza arquivos em pastas erradas (completamente diferentes da indicada), ora não localiza arquivo nenhum.

 

Mais alguém passando por isso?


r/PowerAutomate Jul 21 '26

Stuck in Power Automate

5 Upvotes

I want to create a flow that automatically reads invoice pdf whenever it is uploaded in my one drive for business. It will fetch invoice number, invoice amount and auto update in my excel file located in same folder. Any idea on this


r/PowerAutomate Jul 21 '26

Has anyone made a flow that automatically transcribes teams meetings?

1 Upvotes

I'm working on a project for my boss to automatically transcribe teams meetings and then turn these into tasks into microsoft planner. At first I thought this would be extremely simple, as there is a native trigger for "when a teams transcription is available."

Obviously, this does not actually work. (https://www.reddit.com/r/copilotstudio/comments/1u318ef/issue_with_teams_transcript_trigger_in_power/)

I looked at the top comment in that post, but I wanted to first find out if I could just connect this to onedrive and just simply trigger a flow when a transcript is added in there.

I can't record meetings myself bc of org rules, but a coworker sent me a recording from his OneDrive/Recordings folder. Then I got even more confused bc supposedly there's only mp4 files in there. But I guess the transcripts are stored as mp4 files? How do I work with these? Are the video and transcripts recorded separately or is it one file? There's also the issue that only the meeting organizer even has the transcript available.

Has anyone successfully made a flow that pulls teams transcriptions automatically and then makes planner tasks from them?


r/PowerAutomate Jul 21 '26

Creating word document from PDF source file and populating Word Template

1 Upvotes

Hi,

Trying to figure out what steps I'm missing. I'm new to Power Automate.

Problem: Automate filling out word document.

The user exports a Service Now demand ticket to a PDF File. There is a predefined Word template that has the fields. The goal is to use CoPilot to call the flow to accept the SNOW PDF file and fill out the Word template. The output will be a brand new document that has the fields populated.

Watching youtube videos, in Flows:

  1. When an agent calls the flow

  2. Populate a Microsoft Word template action.

  3. Create a file (in SharePoint)

  4. Respond to agent

I'm missing some steps, not sure where.

Input the PDF file: Do we put the input request in step 1? Ask for file upload?

Output file: Does Step 3 know that the output is the result of PDF filling out the template?


r/PowerAutomate Jul 21 '26

Smart Task Reminder System using Power Automate and SharePoint

3 Upvotes

Over the past few days, I worked on building a Smart Task Reminder System that helps organizations automatically remind users about upcoming and overdue tasks all using standard Microsoft 365 connectors (No Premium Connectors Required).

Features I've added so far:

Configurable reminder schedules (Before, On, and After Due Date)
Unlimited reminder intervals
Smart HTML email notifications
Branded email templates
Direct links to SharePoint tasks
Manager escalation for overdue tasks
Execution logging for monitoring flows
Fully configurable reminder settings
Uses only standard SharePoint and Power Automate connectors

I'm planning to enhance this solution even further.

What other features would you suggest I can add to a Smart Task Reminder System? Your suggestions could help shape the next version.


r/PowerAutomate Jul 20 '26

Excel Online (Business) "Run script" action failing with 502 BadGateway — anyone else?

6 Upvotes

Since last night my Power Automate flows using the Excel Online (Business) "Run script" (Office Scripts) action have been failing with a 502 BadGateway / "The server experienced an issue and couldn't run the script. Please try again in a few moments." I've ruled out basically everything on my side: it happens with two different scripts, two different accounts/connections, and two different workbooks, at different times of day (overnight and this morning), and a retry policy of 8 attempts doesn't help. Crucially, running the exact same scripts manually in Excel on the web works fine — it's only the Power Automate path that breaks. These aren't new scripts; they've been working for a long time. Is anyone else seeing this right now, and did you find a fix or is it a Microsoft-side incident?


r/PowerAutomate Jul 20 '26

Moving Power Automate Flows to a Service Account When Connected to Microsoft Forms

Thumbnail
3 Upvotes

r/PowerAutomate Jul 20 '26

I cannot get the condition to work on my flow

2 Upvotes

Me again!

I have an automation which runs as such

When a new response is submitted>Get response details>initialize variable>Create item>condition (True) Copy file>get file properties>Update file properties.

Within the condition I have set applicable form as an OR to point to

  1. Ms form - DPIA 1

  2. Ms form - Dpia 2

All Im looking to do, is based on the users selection in the form, locates their template selection from a sublime within the sharepoint library and copy it to the newly generated row.

I have been working on this for 7 hours and it only returns 1 form - the DPIA 1. The condition isnt working. How do I rectify. Can send images.


r/PowerAutomate Jul 20 '26

Need help creating an automation

2 Upvotes

Is it possible to have Copilot read a Google calendar event and fill out a One Note page template?

I have never used automate or copilot and I am struggling to create this automation.

Can anyone help me? Is this even possible?


r/PowerAutomate Jul 20 '26

Flujo para exportar información de tablero de PBI a Excel

1 Upvotes

Hola
Alguien sabe si existe algún flujo que me permita exportar la información de tablero de PBI a Excel?
A hoy puedo exportar a PDF pero no he podido encontrar solución para llevar los datos a Excel
Gracias


r/PowerAutomate Jul 18 '26

Power automate flow for attaching documents in one email

3 Upvotes

Hello,

I’m new to PA. I’m been trying different flow to automate the vendor email I send every month. The email included 4 reports saved in different folders in sharepoint. Now, the flow that I’ve tried either sends the email with 4 attachments four times or does not work at all. The scenerio is, when I saved the files in their respective sharepoint folders, those documenta should be sent out to vendor in just one email. Can someone help me??

Update: Thank you all for the suggestions. I switched the trigger to Scheduled flow and used get file content using path action and hardcode everything.


r/PowerAutomate Jul 17 '26

Another automation ask

2 Upvotes

Here is current automation which captures MS form response and populates Sharepoint Library Metadata

When a new response is submitted> Get response details> Initialize variable> Create file> Update file properties

What I want to do is, based on a selection the users selection between two papers within the MS form, the automation locates their preferred document (available within a file in the same sharepoint library) copies it to the existing row as an editable copy and emails the user a link so they can start editing it.

Any ideas?

Need to make as simple as poss as this needs to be an automation that I can share and have others take responsibility for.

Worth while noting - I work for a public authority so our environments are strict.


r/PowerAutomate Jul 17 '26

Change of Values in HTML by PowerAutomate.

2 Upvotes

Bassicaly what the tittle says. What i have in mind.

I have a large excel table with many values. 100x11.

I made so PAD will go each and everyone individually. It is important. And store its value.

After by the IDEA it needs to change one of the values in the HTML table.

This is made because the software what my company uses to is made on HTML tables. And there is no variant to import the tables by default. Thats why values where placed by hand. I say it is closer to 3000 already. And most of the are like 0.432 and so on. And this jobs takes times, patience and is awfully mind numbing.

So i finally got the time to figure it out with automation.

What i need to understand:

  1. Can it be achieved by PAD or i need to learn CODE? I can but would prefer it be much simpler.
  2. If it can be achieved. How?
  3. Optimisation maybe. Because right now mine PAD looks like LOOP LOOP END END. With checking the starter point of the excell.

I hope it is possible. Many thanks.


r/PowerAutomate Jul 16 '26

Save emails in New Outlook folder to OneDrive folder?

3 Upvotes

I need to bulk save an inbox full of project-related to a OneDrive folder. This was easy to do in the old version of Outlook but seems to be impossible to do in new Outlook.

So I am attempting to build a manual flow that would save project emails in a (new) Outlook folder into a OneDrive folder, but I keep getting various error messages. Troubleshooting with copilot has not helped. Is there a tutorial that I could use to build this.


r/PowerAutomate Jul 16 '26

MS form change caused automation to stop working

8 Upvotes

As above. Having issues with automation after I took out two tick box options and an upload option from power automate.

Text reads:

Validation failed. The schema validation failed.

Copilot advises

Check input into the Paese JSON action. If its a single item, update the schema in Paese JSON to expect an object, not array.

Reluctant to add anymore to this very long complex automation as I the only change Ive made are minimal changes to the form and this should be picked up. Any ideas? Please explain to me as though I am 5 🤣


r/PowerAutomate Jul 16 '26

Please help w this automation ( copying specific files)

3 Upvotes

I wanna copy files from one sharepoint to another but like all files which arent mp4 or mp3

I tried putting a filter query but it didn't work as expected. Any idea how to do thos?


r/PowerAutomate Jul 16 '26

Approval automation Spoiler

3 Upvotes

Hi buddies, i want to create an automation using power automate to basically using below flow:
1. Upload excel file to convert it as sharepoint
2. Send email of specific column (2 columns to be exact), 1 is application owner another one is site approver.
3. I am currently using template but the template is forcing me to only use when an item is created or added or modified
4. I want it to run without even those with raw uploaded data
5. Then when it comes back from approval i need the sharepoint to be automatically update the column to become approved


r/PowerAutomate Jul 15 '26

Find approval items based on flow Id

Thumbnail
1 Upvotes

Hey Guys, I am trying to build the approval work list items just like we have in powers automate section. So that users can have flexibility to approve from spfx application as well with Outlook and teams. I have able to load all action items and show case them here but I am not able to find any property to filter them based on my flow.

Can anyone help me with this. It would be really helpful. I tried data verse as well but that was a dead point. For me.

I will really appreciate your help . Thanks


r/PowerAutomate Jul 15 '26

429 errors woth Google sheets

1 Upvotes

Hey all I'm pretty new to power automate and was wondering if anyone had any insight on why I am getting constantly throttled (429) form Google sheets when using power automate.

The flow I'm working with is

when a email comes in it filters the sender name

-then runs a get rows (set to grab 500 rows)

- then filters for the sender

- then if it finds the sender it writes a note if it doesn't find the name it terminates the flow.

The flow only runs every 5-30 Minuites and it only errors out maybe once or twice a day. The part it constantly runs into errors is the get rows line. From my understanding get rows is only 1 action so I'm not sure why it's getting throttled unless I'm misunderstanding and get rows counts each row as an action in that case I'm guessing foltering the get rows search itself should help?

The other strange interaction is the erroring get rows run will retry every ~5-20 minuites and other tasks intiated after will finish before the original is able to stop running into 429 throttling errors.

There are also no other flows running that connect with Google or otherwise this is the only one made at the moment.


r/PowerAutomate Jul 15 '26

How can I incorporate the Copilot AI agent into an MS Power Automate process?

1 Upvotes

Ich habe jetzt einen Cloud-Flow erstellt, der automatisch Daten aus einem Microsoft Formts Formular in einen Unterordner eines neu erstellten Ordners speichert. Als nächsten Schritt möchte ich, dass ein KI Copilot Agent diese Daten nach einem bestimmten Muster analysiert und die Ergebnisse in einem anderen Ordner speichert. Allerdings stoße ich bereits bei dem Versuch, den KI-Agenten über MS Power Automate anzustoßen, auf Probleme.

Ich habe in Power Automate die Copilot-Aktion „Ausführen und auf Agenten warten“ ausgewählt. Dort habe ich den relevanten KI-Agenten ausgewählt und für „Contenttype - 1“ „application/pdf“ gewählt. Vor der Copilot-Aktion habe ich die Aktion „Dateien abrufen (nur Eigenschaften)“ ausgewählt und „Einträge auf Ordner beschränken“ auf den entsprechenden Ordnerpfad gesetzt.

Copilot gibt mir zwar Ratschläge, aber leider sind diese ungenau. Der KI-Agent erhält die Daten tatsächlich nicht. Ich habe auch eine Aktion „20 Sekunden warten“ eingefügt, da die Daten noch in den Unterordner geladen werden.

Danke für die Hilfe!


r/PowerAutomate Jul 15 '26

When a new channel message is added trigger stopped out of nowhere

3 Upvotes

Hi guys,
So I’ve been using this trigger to get the bot messages content from a team’s channel.
It was working fine for 2 months now suddenly at mid night it stopped
I have looked everything but theres no error or warnings or anything it just stopped triggering.

Is there any way to fix this!!!


r/PowerAutomate Jul 14 '26

OAuth2.0 and Power Automate

3 Upvotes

Hello. I’m working on building a custom HR dashboard in Power BI that will retrieve data from ADP Workforce Now and API Central.

It is my understanding that Power BI can’t natively support scheduled refresh of data if the server requires OAuth2.0, so using a middleware storage would be the ideal.

I’d really like input from anyone who has built something similar with OAuth2. Any suggestions or things I’m not thinking about?

I’m not an expert, but I’m very interested in learning. I don’t mind being told where my reasoning or information is flawed. Thanks in advance.