Skip to main content
Community site session details

Community site session details

Session Id : Iyav+v17rFXfdbm+PD0B3P
Power Automate - Using Flows
Unanswered

Send Reminder Email only to those who have not approved

Like (0) ShareShare
ReportReport
Posted on 22 Oct 2021 20:06:08 by 8

I have this flow working where it will run on a timed loop to send a reminder out that approval is needed. If it times out or if all approvers.. approve then it also works. I have been looking all over the forums. Can anyone show me in a picture format the flow to only send a reminder email to those who have not approved? I believe it requires some use of a array variable but not sure how to put it together. 

 

Current flow is as follows:

GregR30_0-1634933109307.png

 

 

  • GregR30 Profile Picture
    8 on 03 Nov 2021 at 20:19:58
    Re: Send Reminder Email only to those who have not approved

    @v-bofeng-msft 

     

    I think the issue is during the select pieces.. what am i supposed to put on the Left side to match the right side:
    every approver name or email address mapped to Owner (Value)?

    Same with the Select 2 map all the potential responses to Owner (Value)?

     

    What is Test1 for example:

    GregR30_0-1636043542467.png

    And flowing through here:

     

    GregR30_1-1636043600604.png

     

     

     

     

     

  • v-bofeng-msft Profile Picture
    on 28 Oct 2021 at 05:50:36
    Re: Send Reminder Email only to those who have not approved

    Hi @GregR30 :

    Could you please show more details about the errow?

    Please show me the setting of your flow.

    Best Regards,

    Bof

  • GregR30 Profile Picture
    8 on 26 Oct 2021 at 15:32:19
    Re: Send Reminder Email only to those who have not approved

    Fails here:

    GregR30_0-1635262290154.png

     

  • v-bofeng-msft Profile Picture
    on 26 Oct 2021 at 01:45:47
    Re: Send Reminder Email only to those who have not approved

    Hi @GregR30 :

    Sorry,it's my fault.I have updated the reply now.

    Best Regards,

    Bof

  • GregR30 Profile Picture
    8 on 25 Oct 2021 at 12:29:22
    Re: Send Reminder Email only to those who have not approved

    I cannot read the screenshots. Any way you can make them bigger?

  • v-bofeng-msft Profile Picture
    on 25 Oct 2021 at 03:09:41
    Re: Send Reminder Email only to those who have not approved

    Hi @GregR30 :

    I've made a test for your reference:

    vbofengmsft_0-1633485864635.png

    Filter Rows:

    msdyn_flow_approvalrequestidx_approvalid eq @{outputs('Create_an_approval')?['body/name']}

    vbofengmsft_1-1633485930567.png

    Filter Rows:

    msdyn_flow_approvalresponseidx_approvalid eq @{outputs('Create_an_approval')?['body/name']}

    vbofengmsft_2-1633486059837.pngvbofengmsft_3-1633486167617.pngvbofengmsft_4-1633486188437.png

    Note:

    About the filed name "msdyn_flow_approvalresponseidx_approvalid " ,you could get it in your default environment:

    vbofengmsft_5-1635131352269.png

     

     

    Best Regards

    Bof

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete