Power Platform Community Forum Thread Details

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

To reproduce the problem:

Create Cloud Power automate manually triggered executing a sequential approval then start it
Create Cloud Power automate manually triggered
Create List Row Dataverse connector on
1. Table
```
msdyn_flow_approvals
```

Fetch xml query

<fetch mapping='logical' count='15' distinct='true'> 
   <entity name='msdyn_flow_approval'>  
      <attribute name='msdyn_flow_approvalid'/>
      <attribute name='msdyn_flow_approval_title'/>
      <attribute name='createdon'/>
      <order attribute="createdon" descending="true" />
      <filter type='and'>   
            <condition attribute='msdyn_flow_approval_completedon' operator='null'/>   
            <condition attribute="createdon" operator="last-x-days" value="28"/>  
      </filter>  
      <link-entity name='msdyn_flow_approvalrequest' alias='approvalrequest' to='msdyn_flow_approvalid' from='msdyn_flow_approvalrequestidx_approvalid' link-type='inner'>
         <link-entity name='systemuser' alias='requestuser' to='ownerid' from='systemuserid' link-type='inner'>
            <attribute name='internalemailaddress'/>
         </link-entity>
         <link-entity name='msdyn_flow_approvalresponse' alias='approvalresponseid' to='msdyn_flow_approvalrequestidx_approvalid' from='msdyn_flow_approvalresponseidx_approvalid' link-type='outer'/>
      </link-entity>
      <filter type="and">  
            <condition entityname='approvalresponseid' attribute="ownerid" operator="ne" valueof='approvalrequest.ownerid'/>
      </filter>  
   </entity>  
</fetch>

Then on output you will see always owner.email@contoso.com (the user who start the Approvals) instead of current step approver mail

"value": [
    {
        "@odata.etag": "W/\"70766020\"",
        "msdyn_flow_approval_title": "Title Test",
        "createdon@OData.Community.Display.V1.FormattedValue": "21/08/2025 09:45",
        "createdon": "2025-08-21T07:45:41Z",
        "msdyn_flow_approvalid": "6c1881d3-8778-47a4-a811-58c2578b6d59",
        "requestuser.internalemailaddress@OData.Community.Display.V1.AttributeName": "internalemailaddress",
        "requestuser.internalemailaddress": "owner.email@contoso.com"
    },
    {
        "@odata.etag": "W/\"70709606\"",
        "msdyn_flow_approval_title": "Title Test",
        "createdon@OData.Community.Display.V1.FormattedValue": "19/08/2025 12:16",
        "createdon": "2025-08-19T10:16:49Z",
        "msdyn_flow_approvalid": "46b214b4-0e6e-466b-a871-5243d3b8c975",
        "requestuser.internalemailaddress@OData.Community.Display.V1.AttributeName": "internalemailaddress",
        "requestuser.internalemailaddress": "owner.email@contoso.com"
    },

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!

Categories:

Building flows

Hello @AM-24080549-0,

the tasks are stored in the 'Approval Request' (msdyn_flow_approvalrequest) table and the task assignee is in the Owner (ownerid) column. The whole task information is then available if you connect the approval in 'Approval' table (title, link to item, etc.) with the connected rows in the 'Approval Requests' table (Owner, ResponseOptions, etc.)

I don't have a flow to show you the logic, but I built a delegation PowerApps app that's gathering the data across the tables.

----------------------------------------------------------------------------------
Did the answer solve your problem? Please click "Does this answer your question" to help others find the solution too!

You can find more of my solutions on my blog https://tomriha.com