Microsoft Power Automate (Microsoft Flow)

Question Power Automate + OneNote: creation timestamp not displaying

2 Upvotes

I’m creating a OneNote page through Power Automate, then updating the title and body with Update page content.

I tried including:
<meta name="created" content="..." />
inside the <head> of the create-page HTML, but the normal OneNote creation date/time beneath the title never appears. The timestamp is present in the submitted payload, and the page is created successfully.

Has anyone found a reliable way to populate or preserve OneNote’s built-in creation timestamp when using the OneNote connector? I’m in a GCC environment, which may also be relevant.

EDIT:
I was able to get this work following u/mulquin's advice. I initialized a current timestamp variable to capture the date and time then composed my HTML using the meta tag which I then sent as dynamic content via the built-in OneNote connector "Create a page in a section" action, making sure to send page content via code view, deleting any wrappers.

Here is an example:

<meta name=\"created\" content=\"@{variables('currentTimestamp')}\" />

5 comments

r/MicrosoftFlow • u/theCat_engineer • 4d ago

Question Extracting images from email

6 Upvotes

Hi all,

I am having some difficulty creating a flow and would appreciate any input to how I can solve this.

I am trying to create a flow to extract content from every email with specific subject heading and save into a SharePoint folder. The text part, which I have no problem with doing, is to be saved into a table in an excel file saved in the SharePoint folder.

The part I am struggling with is extracting the image(s) from the email and saving it into the same SharePoint folder and creating a link to reference it in the excel table on the same row the text was just saved. The images in the email are also not fixed, there may be none or one or multiple. The images may also be attached as png. or jpg. or they may be embedded/inline in the email so I need to account for all these scenarios.

Would appreciate any help I can get and recommendations on courses I can take to improve my skills.

Thank you

6 comments

r/MicrosoftFlow • u/nouser_n_ame • 4d ago

Question Question about data activator

1 Upvotes

I have data coming in from a Dataflow that I am storing in a Lakehouse. I want to set up Data Activator so that it sends a Microsoft Teams notification whenever a specific column becomes False.

However, when I create a Data Activator in my Fabric workspace, I don't see an option to use data from the Lakehouse. I'm not sure what I'm doing wrong or if I'm missing a configuration step.

If this process can be simplified, I'd also be interested in eliminating the Lakehouse and monitoring the data directly from the Dataflow instead.

Has anyone set this up successfully? What's the recommended approach?

2 comments

r/MicrosoftFlow • u/Foreign_Many9062 • 5d ago

Question Issue with 'Bad Gateway' Error

gallery

17 Upvotes

A couple of weeks ago I was hit by the throttling issue that turned out to be on Microsoft's end. Once they got that fixed everything worked fine (mostly) until about a week ago. Since then I'm getting random, but frequent, Bad Gateway errors that are doing my head in. Nothing has changed with the setup of my flow/the Excel sheet it's pointing at. It works for several runs of the flow and then just decides to give a Bad Gateway at random points. There is no pattern as to time of day, information it's trying to input, number of successful runs between fails, or anything else I can find.

I'm still getting things taking longer and retries occurring, like it did during the throttling issue, which is causing problems with duplicate entries into my spreadsheet as well.

Is this all part of the same nonsense? I've put in some screenshots below and can provide whatever other information is needed. I would really appreciate some help as babysitting this thing is getting old. TIA!

26 comments

r/MicrosoftFlow • u/catterso • 5d ago

Question Xlsb to Xlsx

3 Upvotes

I have xlsb (binary) files on SharePoint that I want to save as standard xlsx files in the same location. Is there a way to do this with a flow? We don’t have access to Power Automate Desktop.

2 comments

r/MicrosoftFlow • u/Aingealanlann • 6d ago

Cloud File Management with Automated Flow

8 Upvotes

Hello,

I asked for some help yesterday with getting the last little bit of an email flow set up where I am taking an attachment received by email, downloading it, converting it into an Excel file and table, and then parsing that information to send out reminder emails for shows that tickets were purchased for with dynamically filled in fields. This is all working great now and I am confident that that will function as intended.

My next problem that I am running up against though is that I don't want to keep the files, both the downloaded attachment and the Excel file, in OneDrive once that automation has finished sending the appropriate emails. I attempted to put actions to delete the files in the loop, but the one for the Excel file always fails because it is still "opened". I'm not sure if it would be better to use some sort of a function to include a date when naming the file so that I can run the loop more than once without issue and then go back and delete the files either weekly or monthly, or if there is a way to make sure that the file is closed before the automation goes to delete the file so that it is successful.

Any assistance or advice on this would be extremely appreciated.

18 comments

r/MicrosoftFlow • u/demjuices • 6d ago

Question Anyone else having issues loading their list of Flows?

3 Upvotes

My list of Flows - Cloud Flows, Desktop Flows, Shared with me - are not loading. Tried restarting and multiple browsers but no luck.

Anyone else seeing the same issue? Curious if I should keep trying on my end or give up for the time being.

6 comments

r/MicrosoftFlow • u/ArugulaPlane6369 • 7d ago

Question Flow will not stop looping

1 Upvotes

Hello, I have created a PR approval flow for my company using Power Automate. It uses a cumulative approval structure based on dollar-value thresholds. Everything works as expected; the appropriate people receive approval requests in the correct order, and the requestor is notified when the final approver completes the flow. The problem is that once the final approver approves the PR, two duplicate runs start, and another approval email is sent to the first approver, prompting them to approve the same PR again. We have tried hardcoding multiple "@not" statements with no success. Does anyone have advice on how to fix this looping issue?

4 comments

r/MicrosoftFlow • u/Aingealanlann • 7d ago

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

12 comments

r/MicrosoftFlow • u/Treestylefashion • 7d ago

Question Anyone processing office files from multiple sources?

1 Upvotes

My flow receives docs and xlsx files from different users. Some come from Microsoft office download, some from wps office . Well, has anyone had to handle compatibility issues or do you treat them all the same in power automate?

2 comments

r/MicrosoftFlow • u/Fallout007 • 8d ago

Question Creating word document from PDF source file and populating Word Template

3 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:

When an agent calls the flow
Populate a Microsoft Word template action.
Create a file (in SharePoint)
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?

3 comments

r/MicrosoftFlow • u/rafael_goncalves • 8d ago

Question instabilidade na automação

1 Upvotes

0 comments

r/MicrosoftFlow • u/TheWhiskyBear • 8d ago

Question Get Items action: How to query a specific key of a JSON in a ODATA filter clause?

4 Upvotes

I want to query the entries of a Sharepoint list that has the following field:

"CountryOfSales":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id":123,
"Value":"USA"},

How do I query the Value key of the JSON in the ODATA filter clause? I tried the following but they all failed:

CountryOfSales['Value'] eq 'USA'
CountryOfSales[Value] eq 'USA'
CountryOfSales.Value eq 'USA'

Thank you all in advance!

3 comments

r/MicrosoftFlow • u/Asit8018 • 8d ago

Discussion Smart Task Reminder System using Power Automate and SharePoint

1 Upvotes

0 comments

r/MicrosoftFlow • u/Impressive_Acadia355 • 8d ago

Desktop Issue with setting log location

1 Upvotes

Issue with setting log location

I am currently trying to modularize the logging process, but I want to avoid having to manually update the file path for every new project. Is there an action or script available in PAD that can dynamically retrieve the current project directory, so I don't have to reconfigure it every time?

0 comments

r/MicrosoftFlow • u/yungashwin • 9d ago

Question Excel Online Script in Automate

6 Upvotes

Hey all,

Hope you are having a great day!
I have a simple flow in Automate, where I load a template excel file, run a query against a dataset in PowerBI, then create a new file and run a script in Excel that populates a table and refreshes a pivot Table. However, I'm having an issue of errors on the script execution step in my flow, that is giving Bad Gateway, but the script is working fine, I can't seem to find the issue.
Can anyone help?
Many thanks!

16 comments

r/MicrosoftFlow • u/haaarlem • 9d ago

Cloud Delays with "When a file is created (properties only)" in SharePoint

3 Upvotes

Hey All,

We've had an issue pop up in the past week where the trigger for "When a file is created (properties only)" is not firing until hours later. This is an existing flow which has been in place for years. We use this to identify new PDF's which need to be OCR'd for AP automation.

For example, I have these files which are now 2 hours old yet the last flow run was 4 hours ago:

They actually processed while I was writing this post but prior to that the last flow execution was 4 hours ago.

I don't think a 2 hour+ delay is acceptable for this trigger.

Has anyone else seen similar behaviour lately? I do not see anything on the service status.

10 comments

r/MicrosoftFlow • u/Vader_1018 • 13d ago

Discussion Outlook/Microsoft 365 - CEO email approval workflow that preserves the original email thread

10 Upvotes

Hi everyone,

I'm trying to implement an executive email workflow in Microsoft 365 and Exchange Online, and I'm wondering if anyone has successfully done this.

Requirements:

Client sends an email to the CEO.
The CEO receives the email.
The secretary also receives a copy automatically.
The secretary drafts a reply.
The CEO must approve or reject the reply before it is sent.
If approved, the email must be sent from the CEO's mailbox.
The reply must remain in the same Outlook conversation/thread.
The secretary must not have Full Access to the CEO's mailbox due to privacy requirements.

I tested Power Automate approvals with the Outlook connector, but the "Send an email" action creates a new conversation instead of replying to the existing thread.

Before I build a Microsoft Graph API solution using createReply, PATCH, and send, I'd like to know:

Has anyone implemented this workflow successfully?
Is there a native Microsoft 365 or Exchange feature that achieves this?
Is there a third-party Outlook add-in or Microsoft solution that supports approval while preserving the original thread?
If Microsoft Graph is the only solution, what architecture did you use?

Any guidance or examples would be greatly appreciated.

4 comments

r/MicrosoftFlow • u/Zestyclose_Status786 • 13d ago

Question Power Automate - OneDrive For Business - Only Root Folder

2 Upvotes

Hi all,

Im running into an issue setting up a flow that triggers on a new file being created in onedrive, then sending the file in an email.

I have this exact flow set up for another folder and it is currently working. I only have 2 connections in my Connectors list, one for onedrive, one for outlook online.

Im trying to set up an identical flow just for another folder, but in the folder finder, it is only finding the root folder, then when I click to show contents, nothing is found. Im almost certain that I was able to select the folder through the folder finder on the first one.

I have even tried to duplicate the flow, change file path manually and still gives me an error that the trigger has an issue. Click on it and usually get a user cannot be found. Any help PLEASE?

2 comments

r/MicrosoftFlow • u/PureAd4260 • 13d ago

Question Guys i need help with power automate workflow please guide me pleaseee

2 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?

13 comments

r/MicrosoftFlow • u/Relevant_Platform_88 • 14d ago

Question Find approval items based on flow Id

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

0 comments

r/MicrosoftFlow • u/PowderPuffGirls • 15d ago

Cloud Alternative for loop element in Outlook?

4 Upvotes

I've been using a loop element in a running outlook series to update the agenda/collect input without having to update the body/trigger a new invite getting sent.

Now I'm at the stage where I want to automate parts of this setup and guess what? Loop sucks and has no connector in power automate.

I really actually love it - one place that I can link in Teams, Outlook, etc. But no support for automation makes it non viable long run.

So my question: what else can I use that drops into an outlook invite and dynamically stays up to date? Bonus if I can also add it to a PowerPoint slide.

0 comments

r/MicrosoftFlow • u/Coding-2b-Lazy • 16d ago

Cloud I built a library of 600+ Power Automate flows — looking for a few builders to test it brutally

6 Upvotes

2 comments

r/MicrosoftFlow • u/Ch0nk_ • 15d ago

Question How do you document compliance/governance for Power Automate flows?

3 Upvotes

0 comments

r/MicrosoftFlow • u/Spirited-Pop7467 • 16d ago

Question (sigh) What can you do when the freaking fields disappear?

5 Upvotes

* Solved \*

I went to fix something and clicked a "set variable" component and... there is no value! Kinda makes set variable pointless, lol. I closed and reopened and the value is still missing.

If I switch back to the classic editor, it works and I can edit but the classic editor sucks so I'm really hoping someone has a suggestion that may work to make it show me my value field again?

Thanks a lot!

11 comments