filter current week items, sharepoint list.

[Ramon3]

hello everyone can someone help me with the following situation, I have a sharepoint list, with my activities, where I have the due date and would like to receive an email every Monday with the activities planned for that week, I tried use the Odata filter but it didn't work.

[abm]

Hi @Ramon3 

Please have a look at my tutorial video how to filter SharePoint Dates.

https://www.youtube.com/watch?v=FRKtB37hJ4g&t=122s

In your case use the scheduled trigger, select your time zone.

For the filter query you need to use utcNow(), formatDateTime(), addDays() (add 7 or 5 days it depends) expressions to set the dates for the comparisons.

[Ramon3]

congratulations for the video, but could you help me, as would the function to filter the items that will expire in the current week, my week starts on Monday, and I have the due date of the tasks.

[abm · Accepted solution]

Hi @Ramon3 

Follow the below steps:

Above Filter Query I have mapped the From Date and To Date under the condition.

For the above From Date Expression is as follows:

formatDateTime(utcNow(),'yyyy-MM-dd 00:00:00')

For the To Date I have added another 7 days for a week. Change the formula accordingly. See below expression.

formatDateTime(addDays(utcNow(),7),'yyyy-MM-dd 23:59:59')

Thanks

[Ramon3]

Thanks, it worked really well.