Maintenance Tasks

[SDainius]

Hello,

I want to create a maintenance plan with cycle:

1. When the maintenance plan "DueDate" is current Date the item must be created in the next list (Tickets), with "StartDate" and "Title" from maintenance plan
2. Maintenance plan Item "Start Data" must be changed to DuoDate.

Maybe anybody can have good Ideas how realize  this idea with Flow?

 

[WDRC]

@SDainius

That should not be an issue, I would suggest you do the following:

• Use a recurrence and do this daily at a set time acording to your time zone
• Then get items from IT Main Plan
• Insert a condition for today's date you will need an expression for that
• Then update items in the from the IT main plan into IT tickets 

Hope that helps, I am not an expert myself but will send you the expression if you think the above helps.

If you can post a picture of the flow you create then we can solve this one together.

Regards

Andrew

[SDainius]

Thank you, works well but only if maintenace date "DueDate" is normal date field. I can't to do with calculated "DueDate" field. With calculated field "DueDate" I got Error

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2540': 'The template language function 'substring' expects its first parameter 'string' to be a string. The provided value is of type 'Null'. Please see 

My flow is:

[v-bacao-msft · Accepted solution]

Hi @SDainius,

I am afraid I don't know how the calculated column-DueDate was created, so I can't directly determine the cause of the error.

I did a test on my side, maybe you could use it as a reference.

• Create a calculated column of type Date, using the value of the StartDate field plus the value of the Recurrence field.
• Use Get items to get all the items, configure Condition to determine whether DueDate is equal to utcNow().
• Here we need to use formatDateTime() function to format the date into the same format for easy comparison.
• If the condition is true, create a new item in another list and update the current item.

Expression:

@equals(formatDateTime(items('Apply_to_each')['DueDate'], 'yyyy-MM-dd'), utcNow('yyyy-MM-dd'))

Image reference:

The Dynamic content configured here is from the Get items action.

Please take a try again.

Best Regards,

[kmw1130]

I'm wanting something similar to a Maintenance Tasks list.  The first Monday of each Month the owner needs to review their maintenance list item(s), complete a task that it has been reviewed for the month.  I need a record that they reviewed their item each month for our Quality Department.  Should I create a separate list to track each month's review or can it be done in the same list?

thanks

Kim

[NOTgrounded]

Hello Kim,

I am looking into same functionality for my maintenance needs. Did you end up utilizing power automate? Any help would be appreciated.

aovoian@gmail.com

Thanks 

[kmw1130]

@NOTgrounded What I ended up doing was I created a scheduled flow that runs on the 1st of each month, it gets the items in a list that is filtered on which ones to create a Planner task for, then it creates an item in a SharePoint list.  Then I have a flow that when a Task is completed it updates the SharePoint list with the completed task info.