Odata query in power automate

(0) Share

Report

Posted on by Muhammad Anas Naeemi

436

Hello community,

I want to apply a query in List rows trigger that wherever the created on date is equal to current date it should list that row. Below is the screenshot where I want to apply this query.

formatDateTime(triggerOutputs()?['body/createdon'], 'yyyy-MM-dd') eq

formatDateTime(utcNow(), 'yyyy-MM-dd')

I tried this but it is not working

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Guido Preite 54,086 Moderator on at

Like (0)

Report
Copy link

Link copied!

you should put

Microsoft.Dynamics.CRM.Today(PropertyName='createdon')

in this way you get the cases created during the same day as you are executing the flow

Was this reply helpful? Yes No
Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Muhammad,

You can try to use 'Fetch Xml Query' to achieve your goal easily:

(1)Filter and download fetchxml:

(2)using it in the flow:

====================

If you must use Odata query in power automate, you can refer the following two ways:

1.You can use 'FetchXml Builder' tool of XrmToolBox to convert fetchxml code to power automate parameters:

2.Or you can refer to the following link to use another way:

https://technologyblog.rsmus.com/microsoft/power-automate-date-filtering-on-todays-date/

Was this reply helpful? Yes No
Muhammad Anas Naeemi 436 on at

Like (0)

Report
Copy link

Link copied!

Hey Leah Ju,

Fetch Xml query worked for me. Thank you.

Was this reply helpful? Yes No