
Announcements
Hey , I have a dataverse table PromotionProcessStages with Columns Stage(Text) , StartDate, ReminderDate, EndDate (all 3 columns of type datetime)
I have another dataverse table DBSendreminder where iam defining a single value for how many days email reminder notification need to be send to particular user in NoOfdays Column
The NoOfDays value can be 3 or 4 or 5 anything
I want a flow that checks StartDate for each Stage and send email , example if NoOfDays is set as 5 it should send mail any 5 days before the ReminderDate for that particlular Stage . If NoOfDays is set as 3 it should send mail on 3 days before the ReminderDate for that particlular Stage. It should be dynamic flow . if the reminder Date is today's date also it should satisfy.
How do I achieve this , What condition should I write in the flow so it sends mail that many number of times specified in powerapp.
For Example For Stage 02. Define Affordability and Eligibility Matrix if Start Date is 05/02/2024 (2nd May) and ReminderDate is 05/15/2024(15th May) then flow show send reminder email on any 5 days before or on 15th May 2024 ( 5 days can be daily 1 email for 5 continuos days or alternate days etc)