cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GregR30
Frequent Visitor

Send Reminder Email only to those who have not approved

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

 

 

6 REPLIES 6
v-bofeng-msft
Community Support
Community Support

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

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

Hi @GregR30 :

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

Best Regards,

Bof

Fails here:

GregR30_0-1635262290154.png

 

Hi @GregR30 :

Could you please show more details about the errow?

Please show me the setting of your flow.

Best Regards,

Bof

@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

 

 

 

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,755)