cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JuliosJamby
Helper II
Helper II

Filter Data for the week

Hi, how do I filter my data for the upcoming week (Mon-Sun). I want the filter to work for every week and it changes dynamically. How do I go about doing it? I'm using list row present in a table.

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @JuliosJamby 

I set up a flow, you can take a try with the screenshots below.

This is my test excel

vLilyWmsft_0-1634870430336.png

Assume I run Flow once every Friday.

vLilyWmsft_1-1634870484348.png

vLilyWmsft_2-1634870499933.png

Note:Friday plus 3 days is next Monday, Friday plus 9 days is next Sunday.If you want to run Flow on Monday, change the number 3 to 7, and the number 9 to 13.

@and(greaterOrEquals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 3, 'yyyy-MM-dd')),lessOrEquals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 9, 'yyyy-MM-dd')))

vLilyWmsft_3-1634870529175.png

vLilyWmsft_4-1634871027194.png

vLilyWmsft_8-1634871426711.png

After flow runs, I will receive an email like this:

vLilyWmsft_6-1634871334515.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-LilyW-msft
Community Support
Community Support

Hi @JuliosJamby 

I set up a flow, you can take a try with the screenshots below.

This is my test excel

vLilyWmsft_0-1634870430336.png

Assume I run Flow once every Friday.

vLilyWmsft_1-1634870484348.png

vLilyWmsft_2-1634870499933.png

Note:Friday plus 3 days is next Monday, Friday plus 9 days is next Sunday.If you want to run Flow on Monday, change the number 3 to 7, and the number 9 to 13.

@and(greaterOrEquals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 3, 'yyyy-MM-dd')),lessOrEquals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 9, 'yyyy-MM-dd')))

vLilyWmsft_3-1634870529175.png

vLilyWmsft_4-1634871027194.png

vLilyWmsft_8-1634871426711.png

After flow runs, I will receive an email like this:

vLilyWmsft_6-1634871334515.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,832)