Dynamics Community Forum Thread Details

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

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:

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

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.