cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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

 

 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:

 

caiom_0-1610723484995.png

 

 On the List, this date field is displayed as (dd/MM/yyyy):

 

caiom_1-1610723581178.png

 

 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')"

 

caiom_2-1610723909613.png

 

 Could anyone give me a hint or advise me how to do this? It would be extremely appreciated.

 

 Regards,

 Caio

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User II
Dual Super User II

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

View solution in original post

2 REPLIES 2
Dual Super User II
Dual Super User II

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

View solution in original post

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

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (44,122)