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.
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.
Hey Leah Ju,
Fetch Xml query worked for me. Thank you.
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/
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,556 Super User 2024 Season 2
Martin Dráb 228,625 Most Valuable Professional
nmaenpaa 101,148