
Announcements
Below is a snippet of my flow, the end date is a field from a sharepoint list, and I want to compare the current date to end date - 7 (Send out an email a week before the enddate). Please help me figure out how to do the -7 or if there is another method.
I am aware of formatDateTime(addDays(utcNow(), -30), 'MM/dd/yyyy') but I don't know how to apply that to a sharepoint field.
Hi @Anonymous
Pls try using the below expression inside 'Compose' action:
formatDateTime(addDays(utcNow(), -7), 'yyyy-MM-dd')
subtracting 7 days to current date to get a week past date.
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks