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!

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.

Hello everyone,

I'm really new to Powerautomate, can somebody eli5 it to me because we wanted to connect our SQL database to Powerautomate online, but it needs a gateway?

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?

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?

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?

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

Got tired of manually checking a spreadsheet every day to see what needed a follow-up, so I built a system that does it itself — status updates automatically, a daily flow reads what's overdue and sends the reminder, no manual checking needed anymore.

Wrote up how it works here:
https://modestasklimovas.github.io/portfolio/case-study-assortment-automation.html

Looking to build a couple more of these for free, in exchange for using it as a case study. If you've got some recurring thing you're tracking by memory that shouldn't be (renewals, follow-ups, deadlines, status checks) — that's the same shape underneath.

Comment or DM if you've got something like that.

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.

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?

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.

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?

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

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.

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.

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.

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.

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 🤣

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?

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

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

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.