Hi,
i am trying to filter an entity based a date field... but with no success, i am trying to get all records that haver the date of "yesterday"
i.e.: ReportDate=yesterday
where ReportDate is the date field!
really appreciate your help on this.
Regards,
Mohammad
Hi mokhawaja,
About Odata filter query, please take this documentation for a reference:
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-...
From the doc we know that when filter the datetime, we need to get the day, month and year of the date.
While you could also add a Condition in your flow to filter the date which is equal to yesterday.
To test this issue, I configured the flow likes below. It works as expected.
The function I use in the Condition is: @equals(items('Apply_to_each')?['date'], formatdatetime(adddays(utcnow(),-1),'yyyy-MM-dd'))
Reference documentation:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language
Please try it on your side. Hope this could be a reference for you.
Best regards,
Mabel Mao
hi @v-yamao-msft,
thank you for your suggestion, which was partially successful, but the problem that my entity that i am trying to filter contains more than 2000 records and the flow times out most of the time with no success.
so i believe that the best way is to use the odata filter... but i still could not find the formula that i can use with success... and most of the time i get a syntax error.
i could extract the date of yesterday using the action (Get Past time) before trying to filter... but my probelm is what is the formula for this Odata filter?
appreciate your help.
Mohammad
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
32 | |
15 | |
14 | |
13 | |
7 |
User | Count |
---|---|
39 | |
23 | |
14 | |
10 | |
7 |