Requirement is to send an automatic reminder email to opportunity owners if the opportunity modified-on date is more than 10 days.
Step Go to https://us.flow.microsoft.com/en-us/ and select the D365 environment.
Step Then click Create > Scheduled flow.
Step Enter the flow name and select the starting date, select Repeat every to 1 day. You can choose the starting date as the time when employees start working every day, or in the middle of the night.
Then set flow as follow.
- The expression of “Filter Query” in “List records” is
- The expression of “Select an output from previous steps” in “Apply to each 2” is
- The condition is
- The expression in “Compose” is
replace(body('Create_HTML_table'),'<table>','<table border="1" style="border-collapse:collapse">')
- The expression of “Item identifier” in “Get record” is
The effect of this flow is that all the users who own opportunity records that “Modified On” field is 10 days ago will receive an email every day, it list the Opportunity records that “Modified On” field is 10 days ago .
I have exported the Flow and placed on github link below.
File Name-> Sendreminderemail_20200706100438.zip
Request to please download this zip and import it into your flow instance.
Original Community Forum Question – https://community.dynamics.com/365/sales/f/dynamics-365-for-sales-forum/394369/send-automatic-reminder-email-to-opportunity-owners-if-the-opportunity-modified-on-date-is-more-than-12-months?pifragment-108953=1#responses
Hope this helps!