Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Send Reminder Email only to those who have not approved

(0) ShareShare
ReportReport
Posted on 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 at
    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 at
    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 at
    Re: Send Reminder Email only to those who have not approved

    Fails here:

    GregR30_0-1635262290154.png

     

  • v-bofeng-msft Profile Picture
    on at
    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 at
    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 at
    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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,645 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow