Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Dataverse - Leave request table shows different data in power automate?

Posted on by 281

Hi, 

I have create an automation that when someone applies for leave an employee's name, their request date, and status get uploaded into a SharePoint list. 

I am wanting to create another automation that when the leave request is approved it changes that status in SharePoint from 'in review' to 'approved'. 

I have started the automation off like this:

pastedimage1651470038537v1.png

Status is equal to approved - I am basing this condition off information in the dataverse:

pastedimage1651470104463v2.png

When I run the flow the condition comes up as false when though in dataverse 'leave request table' is says approved. 

When I also look at the raw outputs of the modified trigger of 'leave request' table, there is no cdm_status ??? to indicate whether the leave request has been approved or denied. 

However, if I was to run the leave request table data in a list rows flow the cdm_status column is there but instead of saying 'approved or in review' like on dataverse it has random numbers like 754400000.

pastedimage1651470399252v3.png

Does anyone know why this is the case?

Thanks,

HS

  • Suggested answer
    Parag Chapre Profile Picture
    Parag Chapre 12,268 Most Valuable Professional on at
    RE: Dataverse - Leave request table shows different data in power automate?

    Hi HSDynamics,

    You cannot use Status directly into condition but you can use something like this.

    pastedimage1651723680974v1.png

    You can also refer this documentation.

    Get Lookup Display Name and Choice (Option Set) Value Label in a Single Query Using a Microsoft Dataverse Connector FormattedValue Property (linnzawwin.blogspot.com)

  • huijij Profile Picture
    huijij 19,809 on at
    RE: Dataverse - Leave request table shows different data in power automate?

    Hi Sir,

    Please hold on to wait answers from others on the forum.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans