Power Platform Community Forum Thread Details

Do Until Action and sending reminders

Hello,

I am building a flow in which I would like to send an email with options (options are approve or reject) and depending on the choice they choose an 'approval status' field will be updated in the sharepoint list.

But there are instances in which they do not answer ot the first one, so I would like to create an action which would wait 7 days, and if the 'approval status' field is still equal to pending, then another email with options is sent out ---> if they respond to this reminder email, it will follow the same conditional step where the approval status is updated.

Once the person responds to either of these emails, there will be a last condition checking the approval status of the item and informing the creator if it's approved or rejected.

It would look something like this:

1. When an item is created

2. Send email with options --> condition --> selected option is equal to approve --> update item 'approval status'

3. Do Until --> Approval status value is not equal to pending --> delay 7 days --> get item --> send email with options --> condition --> selected option is equal to approve --> uodate item

4. condition --> approval status is equal to approved or equal to rejected --> send email to creator of request.

I have tried creating some but I am not able to understand some parts. I don't want the reminder to be sent out till 7 days after, and I don't understand the 'count and timeout' fields in the Do Until action. I have also never used the 'Get items' actions so if someone could explain how I should create my flow to work the way I would like, I'd appreciate that!

@user8290 see below

I initialize a counter variable set to 1, and a do until counter =3 as an example.

Within the Do Until, I created a scope and inside that is where I send the email with options Approve, Reject.

click on the settings for the send email with options and set the timeout to PT7D (7days)

If the user responds, I set the counter to 3 right away to stop the loop so the email is just sent one time.

If the user doesn't respond, the send action will timeout 7 days after per the timeout setting and will trigger the

"Catch" scope (configured to run after timeout). So when it timesout, I increment the counter to one to loop back and send the same email as before (no need to get the item again)

So it will send it 3 times per the Do Until counter equal to 3. You can change this as you please.

You can also evaluate the response from the email, that is what that compose action is if needed.

Last action is another scope named "Finally" which you should check all the boxes in the configure to run.

This is used to process an action say if after 3 attempts to ask for approval and the user didn't reply, you can send an email to yourself or whoever saying "No response received" or something.

Quick Links

Leaderboard > Power Automate