Power Platform Community Forum Thread Details

Hi. I was able to build my first Flow due to the great discussions on this forum. It works but needs to be extended.

I have a list of Tickets cleverly named Tickets. That list includes a number of columns, including a Subject (brief description, single line) and a Description column (detailed description, multi lines). Most tickets are entered directly into the list via a PowerApp that I've written.

However, we have recurring tickets that I want to automatically create on either a Monthly, Quarterly, or Annual basis.

To accomplish this I created a list also cleverly called ScheduledTickets. This list includes the Subject and Description columns but also a NextScheduledDate and Frequency columns.

My Flow runs once a day, and runs (Condition=true) when the NextScheduledDate is less than or equal to now() for an item within ScheduledTickets.

All of that works correctly up to a point. Right now, if run again another ticket is created in the TIcket List as the condition is still true.

What I want, and haven't quite figured out, is how to update the ScheduledTickets list item's NextScheduled Date so that it only creates a ticket at the appropriate time.

My Frequencies are Monthly, Quarterly, and Annually.

A sorta good enough solution would add 30 days to the Monthly Frequency, 90 days to the quarterly, and 365 days to the Annual. Optimal would be if the monthly was say initially created on the 15th of month 1, it would schedule on the 15th of the following month, and the same for quarterly and annual.

I think I know enough that I need to create a Date variable and a formula that does a DateAdd of some sort, and then updates the appropriate record in the ScheduledTickets list. I also believe it should all be part of the same flow so that a failure in step 1 (creating the Ticket list item) would cause the flow to stop, and therefore never updating the ScheduleTickets list item.

Thank you in advance to anyone who responds. You folks are really wonderful to help those of us just starting out with PowerApps.

Categories:

Building flows