You’re offline. This is a read only version of the page.
Announcements
136
Hello
I need some help with the flow. The date filter is not working as it should.
It is a recurrent flow that should send emails on the 1st of each month with tasks allocated for that month only e.g 1 - 31 Jan.
On GetItems i have
StartDate ge ' @{formatDateTime(addToTime(startOfMonth(utcNow()), 1, 'day'), 'yyyy-MM-01THH:mm:ssZ')}' and EndDate le '@{formatDateTime(addToTime(startOfMonth(utcNow()), 30, 'day'), 'yyyy-MM-ddTHH:mm:ssZ')}'
but in January the flow started from Week 2 (08/01) instead of Week 1 (01/01)
SP list
any ideas?
The problem is you are adding a day to start of the month, removing that should fix your issue.
So you are checking for start dates greater or equal to January 2nd instead of January 1st, which for your data does mean January 8 is the first line to process.
Share
Report
All responses (
Answers (
