Unanswered

Repeat a Check record based on if its set to repeat

(0) Share

Report

Posted on by Sean9

124

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Sean9 124 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ivan_apps 2,189 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No