Hi all,
I want to select all items in a list with a specific date.
For example:
My Power Automate is running, when a new item in a SP list is created. One filed of this list is "Expiration Date".
So when a new item is ceated with Expiration Date: 12.12.2020 I want to select all other items with the same "Expiration Date". I suppose this would work with "Get Items" and the ODATA filter but I don´t know how.
Solved! Go to Solution.
You can, as you suggested, use a Get Items action with an OData filter.
Your filter should look something like this:
You can, as you suggested, use a Get Items action with an OData filter.
Your filter should look something like this:
hi @Chriss1982 you can follow this example
Date is my column list, and I compare with my exp date
Proud to be a Flownaut!
Hi @Chriss1982
The date format that you need to have the date in the query is yyyy-MM-dd. You can refer to the other responses to construct the query accordingly. Note that this would work on columns of type date only. If it has time also, the format needs to be yyyy-MM-ddThh:mm:ss.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
26 | |
25 | |
22 | |
22 | |
18 |
User | Count |
---|---|
59 | |
41 | |
34 | |
30 | |
30 |