Odata query in power automate

(0) Share

Report

Posted on by Muhammad Anas Naeemi

390

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)

Verified answer

Guido Preite 54,084 Moderator on at

Like (0)

Report

RE: Odata query in power automate

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

RE: Odata query in power automate

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 390 on at

Like (0)

Report

RE: Odata query in power automate

Hey Leah Ju,

Fetch Xml query worked for me. Thank you.

Was this reply helpful? Yes No