Sending Reminders with Flow

(0) Share

Report

Posted on by user8290

Hello,

I am working on creating an approval flow for website updates, which is supposed to do the following:

- when an item is created in the SP list --> an email goes out to the assigned approvers informing them of the request --> I then have 6 parallel branches from that action:

1 & 2: start and wait for an approval (approver 1 and 2) --> condition (outcome is equal to Approve)

If YES: send email to creator of request --> update item in SP (approved? choice column, status is changed from Pending to Approved)

If NO: send email to creator of request --> update item in SP (approved? choice column, status is changed from Pending to Rejected)

The rest of the parallel branches are Delay actions, 2 delay actions per approver following the format below:

Delay 1 & 2: Delay 2 minutes and then 4 minutes (for test purposes) --> condition: approver 1 approved? value is equal to Pending --> if YES, send reminder email to approver 1 asking them to approve or reject the request.

Delay 3 & 4: Delay 2 minutes and then 4 minutes --> condition: approver 2 approved? value is equal to Pending --> follows same steps as above.

This is where I'm running into the issue. Initially when I was testing the reminders, I waited 2 minutes and then 4 minutes after getting the first approval request from MS Flow, and the reminders came. However, if I do approve or reject fom the first approval notification from Flow, I am still receiving the reminder even though the approved? value is no longer Pending.

Does anyone know how to fix this? It's quite urgent!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

VDS_Mantra 175 on at

Like (0)

Report
Copy link

Link copied!

Hi,

there might be the reason that share point is not updating with the correct status on time, Instead of sharePoint result put the approval result in condition. Hope it will work for you.

Was this reply helpful? Yes No
user8290 29 on at

Like (0)

Report
Copy link

Link copied!

I see ... usually the SP List does update it and it still doesn't work.

Can you please expand on what the condition should be exactly?

Was this reply helpful? Yes No
Verified answer

VDS_Mantra 175 on at

Like (0)

Report
Copy link

Link copied!

You can use the Approval result Variable in condition with And condition. the same variable name by which you are passing the value in SharePoint.

Approval Result - does not equal to - Approve/Yes
And
Approval Result - does not equal to - Rejected/No

I hope it will work, If it still does not work then please share more info about your flow with snapshot.

Was this reply helpful? Yes No
user8290 29 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I tried running the flow once again to make sure it sends the reminders if I don't respond to the initial approval notification. I ran into some issues, here are the variations I have tried so far:
- I did the start and wait for an approval action --> inserted 2 parallel conditions
- the first condition is Outcome is equal to Approve (this condition works fine)
- the second condition is outcome is not equal to Approve and Outcome is not equal to Reject
Because the second condition is being run after the approval action, it won't send the reminder unless the approvers responds to the first one which is against what I am trying to accomplish.
- the second variation I tried is that next to the start and wait for an approval action, i had a parallel action Delay --> delay 2 minutes (for testing purposes) --> condition: status value is not equal to Approved and status value is not equal to Rejected --> if YES, a reminder email goes out.

Here, even if I responded to the first start and wait for an approval notification and the status field was updated to Approved/Rejected - the delayed condition would still come up as true and I would still receive the reminder email.
Please let me know if there is a way to fix this - it's quite urgent.

Was this reply helpful? Yes No