Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Answered

Odata query in power automate

Posted on by 382

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

pastedimage1675695638221v5.png

Categories:
  • RE: Odata query in power automate

    Hey Leah Ju,

    Fetch Xml query worked for me. Thank you.

  • Verified answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    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:

    pastedimage1675742782550v3.png

    (2)using it in the flow:

    pastedimage1675742880654v4.png

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

    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:

    pastedimage1675743093675v1.png

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

    pastedimage1675742711349v2.png

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

  • Verified answer
    Guido Preite Profile Picture
    Guido Preite 54,065 Moderator on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans