web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Dataverse Tables

Power Automate

Answered

Dataverse Tables

(0) Share

Report

Report

Posted on by PAJ

280

I am trying to fetch my due date from my dataverse table and then i am trying to filter rows such that , due date = today date

Issue is that ,

The data that i am recieving has multiple due dates.

One is a formatted Value ,

"3/23/2023"

And the other one is cr011_duedate,

"2023-03-23T00:00:00Z"

Please guide me regarding how to write the filter condition if i want , 'Due Date' -1 = Today()

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @PAJ ,

Please try:

formatDateTime(addDays(item()?['crba2_duedate'],-1),'MM/dd/yyyy')
utcNow('MM/dd/yyyy')

Best Regards,
Dezhi

Was this reply helpful? Yes No

Join the conversation