In SharePoint Designer Workflow, each instance creates an entry in a task list.
Is there a similar concept in Power Automate so that one can check which approvals are pending for a particular person.
Regards,
Elan
Hi @Elan22, it's very straightforward. All you need to do is to have a column in your SharePoint list for the approver and columns for the other approval details:
When you are creating an item in the list add the approver's email address. Then in your flow add a Start and wait for an approval action:
Once the approval is done you then update the item back in the SharePoint list with a SharePoint Update item action, selecting the outcome, completion date, responses comments, and responses approver name from the dynamic content box.
You can then easily check your SharePoint list to see which approval details are empty and who was assigned to each one, perhaps via a view if the list is a big one.
You could have another flow with a Recurrence trigger set for, for example, every 1 week which would check the list and if the approval column is equal to null then send automatically send an email to the approver to remind them.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
Hi @Elan22 ,
You could consider checking the approval process related entities in CDS to see if they contain the information you expect to see.
If you use the relevant actions in Power Automate to achieve similar requirements, as far as I know, there does not seem to be such a function.
Best Regards,
WarrenBelz
146,618
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,962
Most Valuable Professional