So i have a check form where there is a inspection on cars right now they can only schedule 1 check but i want users to set the check to repeat. Eg- check repeats every week, month, year, every 10 days, every 3 weeks, every 2 years, etc. So i want users to have custom ability to re-schedule checks if they want to.
so users select re-schedule and then dataverse creates new records based on when users want it to be re-schedules (Daily, weekly,monthly, yearly), Users will then need to select when they want it to end either by date or when certain occurences is reached
I think you got the right idea creating a table where you can define the recurring event parameters. Your app should record the interval that the user wants recurrence on and what the ‘action’ is. You’ll want to record the last time this event was executed too.
your flow should run pretty frequently and read all ‘recurrence definitions’ and execute those that meet the criteria based on current time and last execution date.
let us know if you have any specific questions about your design.
Yes, a Power Automate flow on a Daily Trigger is how I would go about this. That flow would query all the Daily, Weekly, Monthly, Yearly rows relevant TODAY, then fire the appropriate logic for each path. Most likely, I would use child flows for each path, just because that would be a clean way to organize the logic, but it isn't necessary: you could do it all in one.
@dpoggemann @ivan_apps @EricRegnier @ChrisPiasecki @cchannon tagging top solution authors for help 🙂
Currently exploring power automate to achieve this for the daily repeat of the checks
mmbr1606
22
Super User 2025 Season 1
stampcoin
17
ankit_singhal
11
Super User 2025 Season 1