Hello,
I am trying to use the following to Filter rows as part of a Dataverse List Rows action in Power Automate:
cr299_EntryDateText eq '@{formatDateTime(addDays(utcNow(), -1), 'MM/dd/yyyy')}' and cr299_Status eq 'Out' and cr299_OutType eq 'Leave' and (cr299_ReturnDate ne '2009-12-12T00:00:00Z' or cr299_ReturnDate eq null)
The flow runs successfully, but the outputs always have a status of 200. I have checked the dataverse table to ensure there is an entry that meets all of the criteria. Any help would be greatly appreciated!
Respectfully,
John
Share
Report
All responses (
Answers (
525
