Hello all, I am new here but really need some power automate help. Thank you in advance for any tips or comments.
I am designing a power automate approval flow based on a task list in SharePoint. The SharePoint list has 4 columns, task name, preparer email, reviewer email and status. I have an app button in power app, once the preparer hit the button to submit the task to review, an approval email will be sent to the reviewers. There might be multiple reviewers in the cell of the reviewer column, I want to make sure the status will be updated to back to work if any one of the reviewers rejected the task. meanwhile, while the status is back to work, the other reviewers still can reject and share their comments. Once the preparer updated, then the preparer will need to submit again for approval and the status will be updated to completed only after every one of the reviewers approved. Is it possible to achieve in power apps? I designed a typical approval flow but the situation is, if one approver approved first, the task will be updated to completed no matter the other approver reject or approve. I have been struggling with this for a while, please help. Thank you.