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.
Does anyone know why this is the case?
Thanks,
HS
