Hi all 🙂
I'm looking to send an email at the middle point of two dates that are stored within a Sharepoint list. I had set up the middle date as a calculated field within the Sharepoint List however I have now found out that I can't create a flow based on a calculated field.
Is there a way to build into my Power Automate that it will take the start date and end date and find the middle date and trigger an email on the middle date?
Im a newbie so any help is appreciated 🙂
Thanks
Hi @eilidh3
Here is a really good community blog talks about how to do that.
How to find the number of days between two dates u... - Power Platform Community (microsoft.com)
You can do that, then divide the days by two and use the addDays() expression to add the number of days to the date.
Hope this can help you.
Cheers.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.