Flow using Get Items to only email once

[asmith7]

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

[VictorIvanidze]

Please show your flow.

[asmith7]

Here is the flow

Thanks @VictorIvanidze 

[Hardesh15]

@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.

@Hardesh /Gopenly.in