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
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,
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.
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
it still giving me error on approval
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.
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
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.
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
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.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1