cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
asmith7
New Member

Flow using Get Items to only email once

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

3 REPLIES 3
VictorIvanidze
Community Champion
Community Champion

Please show your flow.

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.
asmith7
New Member

Here is the flow

 

asmith7_0-1660227188095.pngasmith7_1-1660227220448.png

Thanks @VictorIvanidze 

@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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,057)