[Help] Monday's Flow to get entries from a SharePoint List from the next 6 days

[caiom]

 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

[RezaDorrani · Accepted 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

[caiom]

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