Forum Discussion
New to MS Flow : Having Trouble With a Simple Automation Task
Hello,
I'm fairly new to MS Flow. I've seen countless videos around the web on how easy it is to create automated tasks, and it seems to be when it doesn't involve automation against expiry dates; ...
I have a similar workflow for our contracts database. But the way I solved it was do the date calculation in SharePoint.
So I have a column, called "Expiry Date", and one called "Days before Expiry Date" and finally a calculate field call "Notification Date", which is calculated as follows:
=[Expiry Date]-[Days before Expiry Date]
Then in the flow, I do the same as what you have except replace the comparison with something along the lines of:
@equals(items('Apply_to_each')?['Notification_x0020_Date'], addDays(utcNow(), 0))
So that is compares todays date with the notification date and triggers the email.
Hi Stephen,
The SP list is owned by another team, I have access to it, but don't think I have rights to modify it... which means there could be a delay in getting the changes implemented.
I'll give it a day or two to see if someone recommends a solution that doesn't require modifying the list; if not, I'll give your recommendation a try and let you know how it works out. Thanks for your feedback!
The SP list is owned by another team, I have access to it, but don't think I have rights to modify it... which means there could be a delay in getting the changes implemented.
I'll give it a day or two to see if someone recommends a solution that doesn't require modifying the list; if not, I'll give your recommendation a try and let you know how it works out. Thanks for your feedback!