Hello,
I want to create a maintenance plan with cycle:
Maybe anybody can have good Ideas how realize this idea with Flow?
Solved! Go to 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.
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,
That should not be an issue, I would suggest you do the following:
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
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:
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.
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,
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
Hello Kim,
I am looking into same functionality for my maintenance needs. Did you end up utilizing power automate? Any help would be appreciated.
Thanks
@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.
User | Count |
---|---|
93 | |
39 | |
24 | |
20 | |
16 |
User | Count |
---|---|
130 | |
49 | |
48 | |
30 | |
25 |