Hi All,
I'm currently trying to create a flow that sends an email notification when a SharePoint list item is due 7 days from today's date. I've currently tried several expressions that are pulling through the date but don't seem to be filtering out results that are due in 7 days - they're just pulling through everything that has a date.
At the moment my steps are as follows:
- Recurrence
- Initialize Variable (Name: Alert Date. Type: String. Value:
Solved! Go to Solution.
Hi @DI123,
You could filter directly using Filter array contained in Get Items.
In the filter condition, I feel that we need to add another part. If only the setting is less than or equal to, those items that have expired will also be inclueded, so I added a part greater than or equal to.
I have made a test on my side and the flow works well. Please take a try with the following workaround.
The two expressions are:
formatDateTime(utcNow(),'yyyy/MM/dd')
formatDateTime(addDays(utcNow(),7),'yyyy/MM/dd')
Note that they have single quotes on the outside.
Image reference:
Please take a try.
Best Regards,
Barry
Hi @DI123,
You could filter directly using Filter array contained in Get Items.
In the filter condition, I feel that we need to add another part. If only the setting is less than or equal to, those items that have expired will also be inclueded, so I added a part greater than or equal to.
I have made a test on my side and the flow works well. Please take a try with the following workaround.
The two expressions are:
formatDateTime(utcNow(),'yyyy/MM/dd')
formatDateTime(addDays(utcNow(),7),'yyyy/MM/dd')
Note that they have single quotes on the outside.
Image reference:
Please take a try.
Best Regards,
Barry
That worked perfectly.
Thank you!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
42 | |
37 | |
36 | |
23 |
User | Count |
---|---|
44 | |
31 | |
29 | |
28 | |
28 |