Hi, I have built an automation that looks at a Sharepoint list and a date field within that list. If the date within the field is within the next 60 days it emails out. I want it to only email once, currently it is emailing everytime it runs. Is anyone able to help?
Thanks
Amanda
Please show your flow.
@asmith7 I would suggest use one compose-1 and add days 60 to your SP date column. And then use another compose-2 utcnow('yyyy-MM-dd').
Now use filter query in get items- SPListColumnInternalName le 'composeOutput-2' and Compose-1Output gt 'Compose2Output'
Pls make sure that your Date format is same.
Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |
User | Count |
---|---|
49 | |
29 | |
23 | |
20 | |
20 |