Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Dataverse PowerAutomate

(0) ShareShare
ReportReport
Posted on by

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

  • Devvj Profile Picture
    1,132 Super User 2024 Season 1 on at
    Re: Dataverse PowerAutomate

    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.


  • SL-07111355-0 Profile Picture
    on at
    Re: Dataverse PowerAutomate

    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 

  • SL-07111355-0 Profile Picture
    on at
    Re: Dataverse PowerAutomate

    it still  giving me error on approval

  • Verified answer
    Devvj Profile Picture
    1,132 Super User 2024 Season 1 on at
    Re: Dataverse PowerAutomate

    Add the following step before the approval one in your flow

    Devvj_0-1696585145262.png

     

    Then in you approval flow you use the "Primary Email"-field from the previous step to extract the email.

    Devvj_1-1696585302748.png

    -------------------------------------------------------------------------
    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.

  • SL-07111355-0 Profile Picture
    on at
    Re: Dataverse PowerAutomate

    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 

  • Devvj Profile Picture
    1,132 Super User 2024 Season 1 on at
    Re: Dataverse PowerAutomate

    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.

  • SL-07111355-0 Profile Picture
    on at
    Re: Dataverse PowerAutomate

    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

     

  • Devvj Profile Picture
    1,132 Super User 2024 Season 1 on at
    Re: Dataverse PowerAutomate

    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.

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.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Featured topics