Power Platform Community Forum Thread Details

Hello,

I am trying to create a flow that helps us with our companies equipment maintenance. The list has columns for equipment name (text), assignee (person), inspection due date (Date), reoccurrence (number) and completed (choice).

I want the flow to automatically update the inspection due date once the completed column has been changed from no to yes. And then I want the flow to change the yes column back to a no without creating a new item in the list. Here's the flow I came up with:

For some reason, the flow doesn't make it to the yes part of the condition, and in times it has, my function for inspection date due doesn't work properly: addDays(utcNow(),int(triggerOutputs()?['body/Reoccurrance']))

Any advice?

*please ignore my misspelling of reoccurrence, I have another flow that uses it and don't want to change it*

Categories:

Building flows

The only change to your flow I would make is to remove the Condition action and put the logic as a trigger condition. This way, your flow will only run when Completed is equal to yes.

For the current problem, which a trigger condition will have as well... Is your Completed column a free-text column or of a yes/no type? If it is free text, remove the quotes from around "Yes". It is also case-sensitive. If your column type is yes/no, you need to go into the expression builder and insert true on the right side of your condition.

This is a good way to learn about trigger conditions: Trigger Conditions in Power Automate - EnjoySharePoint. Using them helps to prevent unnecessary runs of your flow.