Answered

Help me build flow to send email based on approval status

(0) Share

Report

Posted on by Community Power Pla...

Hello there. Can anyone help me? So I have this flow here that triggers when an item is created or modified in my Sharepoint list. After that, I made an IF condition where whenever there is a "Pending" in the ApprovalStatus column in my SharePoint, it will notify the Admin by sending an email. (at the If Yes).

Therefore at the 'If No' part, I want to make the flow read if and only if ALL values in the ApprovalStatus column =" Approved", only then it will send a thank you email to the admin. This is where I'm stuck. If there is another proper approach you can also suggest to me. Thank you in advance.

MY FLOW:

MY SHAREPOINT LIST COLUMN:

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

Is your single list item associated with multiple Approvals?
If your flow is running on the Approvals list, it will run for each item separately, so you should not add that logic in no. Otherwise you will receive an email for each item.

Instead, you can create a separate flow, HTTP triggered or Manual
Add the Get items action with Odata filter Approval Staus eq 'Pending'.
If it returns 0 results, send thank you email.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Dear @SudeepGhatakNZ ,

It works! thank you very much.

Was this reply helpful? Yes No