@Anonymous I have dug out one example that I use for sending reminders that a review is due in 7 days. In my SharePoint list I have a date column for NextReview and a person column for Owner.
After the Recurrence that runs at 9am every day there is a SharePoint Get items action. We than add an apply to each control and select value from the dynamic content:
The next action is to add a Compose to format today's date. I always use US format for this to avoid ISO 8601 errors. Then we add another Compose and select NextReview from the dynamic content.
Then add another Compose to calculate the reminder date:
Then format that date to to the same US format with another Compose:
The Condition is next that checks if Today is equal to
If the reminder date is today then in the red If yes channel add an Office 365 Users Get user profile (v2) action and select the Owner email from dynamic content. I've then formatted the next review date into UK format and used that in the email.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
