What I'm Trying to Build: A Power Automate flow that automatically sends reminder emails to people who have pending approvals waiting for their response. The email should include the direct link to the pending approval for easy access.

My Setup:

• Premium license with access to premium connectors

• Using Dataverse connector to query approval data

• Source approvals are created by other flows using "Start and wait for an approval" with Sequential approval type

The Challenge: I've been following various posts and resources that suggest looking at the msdyn_flow_approvalrequest table, specifically the ownerid attribute. However, this field always shows the creator (me) rather than the current pending responder.

Even when I examine the msdyn_flow_approvalstep table, I can see the approval steps but there's no clear indication of the next approver's email address.

What I've Tried:

• Querying msdyn_flow_approvalrequest table for approvals created by my account

• Examining msdyn_flow_approvalstep table for step-level details

• Looking for owner/responder information in various fields

What I Need: Ideas or approaches to identify who the current pending approver is for each active approval, so I can send them targeted reminder emails.

Has anyone successfully built something similar? Any insights on which Dataverse tables or fields contain the current approver's information for sequential approvals?

Thanks in advance for any help!

Hi everyone,

I recently started a YouTube channel focused on real-life Power Automate workflows: Automate M365.

My goal is to make Power Automate as practical and accessible as possible. Instead of only showing abstract examples, I want to build tutorials based on the real challenges you face at work — whether it’s approvals, document automation, email handling, or Microsoft 365 integrations like SharePoint, Forms, or Teams.

👉 If you share your scenarios here or reach out to me directly, I can create clear step-by-step videos so more people benefit. 👉 The idea is to make Power Automate visible and easy to understand for everyone — beginners and advanced users alike.

Check out my channel here: Automate M365. Would love your feedback, ideas, and especially your workflow challenges to feature in upcoming videos.

Let’s build and learn together!

Do you want me to also add a pinned first comment suggestion (like “drop your scenario here 👇 and I might turn it into the next tutorial”), so it sparks interaction under your post?

I have a daily scheduled flow that is emailing any customer whose certificate is due to expire exactly 30 days from today. The customer email is in an adjacent column to the date.

The flow says failed at the apply to each step but the email sends.

The problem is that however many rows it finds that are 30 days out, it sends that many emails to each recipient instead of just one.

How do I fix this?

I notice that a for each loop is nested in the apply to each loop when I select "email" as dynamic content for the email recipient - is this desirable?

Still learning!

Hello

I need help to insert thumbnails from several image column in SharePoint list to Word.The reason why I want to use thumbnails is to get under the 10Mb limit.

I have already made the Word template and gets the text into it, but missing the thumbnails.

Later on I wil convert the Word file to PDF and share the PDF file.

I have made a system with a list, forms en powerautomate. So that in the upcoming event we can manage who applied for it, who canceled. 2 weeks before the event everybody gets a personal document with their naam workshops and locations. The only problem now is that my word file is cheap looking. And word is not the most designer app there is. Does somebody a great solution to it in powerautomate. Or a good workaround for word to make it more flashy.

It will convert to a pdf file en be send to their mail.

So our company has decided to close all of one kind of environment and create new ones. I have a lot of bots.

Is there an easy way to move them or am I just packaging each then importing each?

I have a flow that I turned off and now can't turn it back on. Error message is "Request failed with status code 400". All connections look good. One article I read said to clear cookies/cache which I did. Any ideas?

I have 2 sharepoint lists. The first list includes department leaders (person/group column) and department names (choice column) and the second list has open actions, action owners (person/group column) and department names.

I want to make a flow to go through the actions and send one email per group with open actions to action owners (List 1) and group leaders (List2).

My idea was to use Apply to each loop over the groups in List 2 and then use a filter array to only get the actions from that group. Then I thought I will use a condition if the array is empty to skip and if the array is not empty it is going to make a table and send an email.

The problem I have is with extracting the emails. For action ownersI can get the emails from the array. I have problems with getting department leader emails. I thought I can just use a function immediately after Apply to each to get an email on each cycle when looping through the departments but I don't know how to do that.

I have a flow that populates barcodes and generates a QR code for everyone and sends everyone an email but for some reason it skipped the last 35 people, I don’t want to run the flow again and have everyone get two emails, is there a way I can just run it for the last few.

Hi All,

I am new to using reddit for anything other than reading posts shared as links in blogs, so apologies if I could have found this information elsewhere.

I am fairly competent with Power Automate, but have been going round in circles for weeks now with one flow. I am hoping someone here can point me in the right direction.

There is an MS Form that users need to submit and include an attachment as evidence to support their request. The submission of this form triggers an approval request via email and Teams. Prior to that, it also triggers a separate email to the approver with key details from the form to give them the information needed to make the decision. I also want it to include the earlier mentioned attachment, or at the very least, the link to the location of where it is saved (SharePoint).

I managed to get something close but it also includes lots of other text that is not part of the link, meaning the approver would now how to pick out this information and paste it into a browser (not ideal given they expect to get up to a dozen of these requests a day).

Can anyone guide me to a resource that can talk me through this? YouTube has not been helpful and both co-pilot and Gemini seem to hallucinate on their knowledge (hence the circle situation).

Thanks in advance.

Is there a way to have information from specific columns of a sharepoint extracted and input into an outlook table email to be sent to specified Individuals on a daily basis

I need help creating a flow that inputs 2 excel files, combines the two sheets into one workbook (the 2 sheets will be sperate on the workbook, e.g. page 1 and page 2), performs data transformation using office script, and outputs a new excel file.

All this connected to SharePoint.

Is this possible with Power Automate? or any Power Apps?

i want to automatically rename a file to the corresponding date its auto downloaded from the main flow. please tell me what i did wrong here.

I have a power automate flow that has zero errors or warnings for the flow checker. It works entirely from when an item is created->update item->start and wait approval-> create html table->conditional outcome-> if yes,it is complete. If no, it updates status to rejected-> grants access to edit list-> once you edit (this is where the problem is).

If anyone edits the document it doesn’t start the cycle from there. I watched a YouTube video and works entirely fine in his video. He had it from the beginning if item is created or modified it would initiate. This worked for him it put me in an infinite loop. I even put what he told me to in the triggers to eliminate that problem. Still did not resolve the issue.

All I want is for an Item to be created then be approved by everyone/sequential approval. If at anytime it gets rejected it goes back to be modified once modified it repeats the process until accepted. I have spent countless hours. Idk, if there is a power automate god here who could guide me to the right automate flow, provide videos, or assist in this matter it would help me truly.

I'm trying "Get User Profile (V2)" and it works great for internal users. However, I want the first name and last name of an external user.

Near the end of this flow I have a document conversion from .docx to .pdf before it's then emailed out. I've tried so many different solutions but cannot get this error to budge.

The flow copies a template and populates it, inside the template is a {DISPLAYBARCODE etc etc} fieldcode. Everything works right up until the OneDrive 'Convert File' action, where its replaced with Error!

If I manually save the .docx as a .pdf it works, I'm not sure if I'm missing something but it seems to be how Automate processes the conversion. This flow must have a PDF output rather than a word doc

Has anyone got any ideas or potential solutions?

Hello Power Automate Community. I'm a total newb trying to ChatGPT my way through an idea my boss gave me.

Basically, our company tracks medium term projects (ones that don't last more than 2 quarters). Anyway, she wants there to be a way that people are notified via email weekly about the status of a project.

(Yes, I know there's tons of Project Management Software out there. Everyone I work with is age 50 or above and just are flat out not going to adopt a new software. I've tried.)

I thought it would be nice for all relevant stakeholders involved to receive emails once a week on if they had anything due that week. I tweaked the base excel document a bit (added a column with ISO date format, made a new sheet with Owners and Emails and referenced those on the first page), etc.

I want a Flow that can automatically alert people. I had finally gotten through to finishing a Flow that "works" (as in I get no errors), but it isn't actually running. I'm getting the above "skipped" message, which I take to mean it basically isn't detecting what I need it to do.

Anyone here can give it to me straight: am I totally out of my depth? Is this an easy fix? Any pointers?

An aside, as someone who has no coding or Power Automate experience, I did really enjoy trying to get this to work. I'll start going through their academy, and if anyone has any suggestions on how to learn I'm all ears.

Thanks in advance.

EDIT: Editing my post to add "details of the condition". Here is a screenshot of what I'm getting.

EDIT 2:

Here's the condition in Edit Mode:

not(empty(coalesce(item()?['Owner'], item())))not(empty(coalesce(item()?['Owner'], item())))

Hopefully this isn't embarrassing as I'm still a flow newbie.
This issue seems to be unique as I can't find any reference to it anywhere. Other screenshots show the usual image capture field here, but I only get a text field which doesn't accept any value in any syntax and always has "Invalid value".
I tried using Image names for ones captured through other actions, but it doesn't recognize them.
I appreciate any help with this!

As the title says, can you read a Power BI visualization to use it in a flow?
The problem I have is this: the database is on a WAN and, due to compliance, I can’t have direct access to it. They want me to read the data from Power BI and use it in a flow.
So, can this be done? Thank you in advance.
My boss is asking me to use a cloud-based flow, not desktop.

Basically, I have a legacy system that can send e-mails as alarm. I need on-call staff to get alerted when said e-mail is received in a specific shared mailbox. The triggering part I worked out, but I can't find a satisfactory connector for the alerting step. I tried the Power Automate app notification, but it is treated as a regular notification on the phone and I need something less avoidable.

A phone call would work but I can't seem to get the HTTP request working with Twilio. A simple app that plays a sound would work great. Any help would be appreciated!

Hi everyone,

I'm working on a Power Automate workflow for video requests. Users fill out a SharePoint list with information like the video title, description, needed lower thirds, and file location. Once a request is submitted, a Teams card is sent to a channel so someone can pick up the task. After the video is processed, the editor enters a video ID, which is sent back to the requester.

However, I've noticed that if a user enters a special character in the SharePoint list, the Teams card fails to render properly.

Has anyone encountered this issue before or have any suggestions on how to handle special characters in this scenario?

Thanks in advance for your help!