Odata query in power automate

(0) Share

Report

Posted on by Muhammad Anas Naeemi

386

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

All responses (3)

Answers (2)

Muhammad Anas Naeemi 386 on at

Like (0)

Report

RE: Odata query in power automate

Hey Leah Ju,

Fetch Xml query worked for me. Thank you.
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/
Verified answer

Guido Preite 54,077 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