Notifications
Announcements
hey guy can you kindly assist me creating multi approval powerutomate using dataverse just like how it done on sharepointlist , tried to implement it, but has error on the approval
Hi @swelihle ,What value does "Supervisor" holds?I would guess that it holds the GUID for that specific user, but the flow want an email, so if you can try to refer to the supervisors email instead I think it will work-------------------------------------------------------------------------If this is the answer for your question, please mark the post as Solved.If this answer helps you in any way, please give it a like.
supervisor is a lookup column that lookup user table for supervisor email,on interface it shows as email but when it submitted on dataverse it show a fullname
If it is a lookup column it just holds the Guid and the Name of the User, then you need to get the user email before that step, "Get row by ID", and get the email from there.
how to do that because by default the lookup take the first column in the table , and im using dataverse user table that is pre-installed and populated with name and email
Add the following step before the approval one in your flow
Then in you approval flow you use the "Primary Email"-field from the previous step to extract the email.
-------------------------------------------------------------------------If this is the answer for your question, please mark the post as Solved.If this answer helps you in any way, please give it a like.
it still giving me error on approval
how to add second approver , i want to have manager approving after supervisor , i have a table called manager , with name - which is lookup column that retrieve username from usertable , now i want to use that column to do second approval for manager
Hi,i guess you just could kinda duplicate the previous logic, add the table and the field to the Canvas App, then simply extend the Power Automate flow to send out a second approval by adding the a new "get row by ID" step followed by a new approval, right a after your current approval.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 711 Most Valuable Professional
Michael E. Gernaey 319 Super User 2025 Season 2
Power Platform 1919 268
