Hi,
We've got a SharePoint List with tasks, which are assingned within several teams, with Planned Date, Completed Date, among other columns.
Every Monday, the Flow should pick all entries with "Completed Date = blank" and "Planned Date = today +6", and paste into another place.
The "Planned Date" column on SharePoint List is formatted as below:
On the List, this date field is displayed as (dd/MM/yyyy):
The Flow works correctly with simple steps and manipulations. The problem is when I try to insert the expression to get values "Today +6". I've digged the web into it but the pieces of info I found and put together didn't allow it to work.
The latest configuration of the Filter Query I've tried is the following:
"Date_x0020_Completed eq null and Planned_x0020_Date eq addDays(utcNow(),6,'dd/MM/yyyy')"
Could anyone give me a hint or advise me how to do this? It would be extremely appreciated.
Regards,
Caio
Solved! Go to Solution.
Hi @caiom
Filter query syntax - https://youtu.be/yeAnuTB85eg
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
Hi @caiom
Filter query syntax - https://youtu.be/yeAnuTB85eg
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
Hi Reza,
Thank you very much for your response which pointed to your great video. It's very clear, concise and helpful. I managed to fix the Filter Query exactly how I needed/wanted. Thank you very much.
Regards,
Caio
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
34 | |
15 | |
15 | |
13 | |
7 |
User | Count |
---|---|
41 | |
31 | |
25 | |
11 | |
11 |