I am having issues with my automated flow. I want to update the file when the Status value is changed to Completed but if I set the output to True it malfunctions and I tried False but it still malfunctions.. I have attached pic.

(0) Share

Report

Posted on by rfclitadim

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (0)

creativeopinion

10,502 Super User 2025 Season 2 on at

Like (0)

Report

@rfclitadim To troubleshoot your condition action you should add a couple of Compose actions before the Condition action and insert the dynamic content you are evaluating in your Condition action. Run a test and view the outputs of the Compose action to see if they are what you are expecting.

Because you are using the is equal to operator, it's looking for an exact match. If the dynamic content output isn't matching the values you've manually inputted into the second value field of the condition row—it will return false.

I cover how to do that in the first section of this tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No

rfclitadim 19 on at

Like (0)

Report

@creativeopinion Thanks but this did not resolve my issue. Hopefully you can direct me on how to revert back to my previous flows which was working fine or how to restore older flows.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@rfclitadim Can you share a screenshot of where the flow is erroring out? Unfortunately you can't restore previous flow versions. What I recommend before editing a flow that is already working is to make a copy of it first before you make any edits.

Was this reply helpful? Yes No
rfclitadim 19 on at

Like (0)

Report

@creativeopinion I don't get any errors. It happens that one flow overrides the other flow. I will show my flows below:

My flow plan is below (I am new to this and its really frustrating for me) please can you provide me a flow plan with how I can achieve this?

I have a SharePoint list with the these columns (Title, Category, Status, Priority, Email Sender, Date Received, Date Assigned, Date Completed, Marked As, and Assigned To).

Flow A: I want a ticket created in my SharePoint list when an email is sent to itadmin@retail-fcl.com. The ticket created will have Status column as Unassigned, Date Received column will have time and date it was created and Marked As column will be PENDING.**The above flow (A) works ok**

Flow B: When I assigned the ticket to an agent in the Assigned To column, the list should be updated with these values; Status column will now be Assigned, Date Assigned column will be the date and time it was assigned and Marked As column value will now be OPEN. **The above flow (B) works ok**

Flow C: When Status column value is changed to Completed update with the Date Completed column showing the date and time , Marked As value updated to CLOSED. This works but soon after it reverts back to Flow B.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@rfclitadim If you don't have trigger conditions for your Flow B—this flow will trigger any time an item is created or modified. You need to use trigger conditions to ensure that Flow B is only triggered when an item is modified and if the Assigned To column is not empty.

Without the trigger condition in place, Flow B will be triggered as soon as an item is created (which isn't your intention).

Flow C needs to also have a trigger condition to only trigger when the Status column value is Completed.

---

Compose a Trigger Condition

For testing purposes, create a brand new flow. Use the When an item or file is modified trigger.

Add a Compose action to store the Status value dynamic content.

To get the expression you need for the trigger condition—use a Filter Array action. Leave the From field blank. Use the two value fields.

In the first value field, insert the Status value dynamic content. Leave the operator as is equal to. In the second value field insert the Status you want to filter by. In your case it will be PENDING. Important: The text is case sensitive. It should match whatever you have in your SharePoint list. In my case I'm filtering by items with a Current status.

Click on the three dots and select Peek Code.

Highlight the text, between the double quote marks including the @ symbol. Copy this text to your clipboard.

Delete the Filter Array action.

In the flow trigger, click on the three dots and select Settings.

Scroll down to the bottom and click Add to add a new Trigger Condition.

Paste the expression from your clipboard into the Trigger Condition field.

Press Done and test it out. First, change the status of an item to anything BUT Pending. The flow should not trigger. Next, change the status of an item (or create a new item) with a Pending status. The flow should trigger.

You can confirm this by the output of the Compose action which will output the Status that triggered the flow.

... more to come...

Test this out for now.

Was this reply helpful? Yes No
rfclitadim 19 on at

Like (0)

Report

@creativeopinion Thanks but the steps you provided does not follow what my issue was:

"
I have a SharePoint list with the these columns (Title, Category, Status, Priority, Email Sender, Date Received, Date Assigned, Date Completed, Marked As, and Assigned To).

Flow A: I want a ticket created in my SharePoint list when an email is sent to itadmin@retail-fcl.com. The ticket created will have Status column as Unassigned, Date Received column will have time and date it was created and Marked As column will be PENDING.**The above flow (A) works ok**

Flow B: When I assigned the ticket to an agent in the Assigned To column, the list should be updated with these values; Status column will now be Assigned, Date Assigned column will be the date and time it was assigned and Marked As column value will now be OPEN. **The above flow (B) works ok**

Flow C: When Status column value is changed to Completed update with the Date Completed column showing the date and time , Marked As value updated to CLOSED. This works but soon after it reverts back to Flow B.
"

Was this reply helpful? Yes No
rfclitadim 19 on at

Like (0)

Report

@creativeopinion Please see below what I am trying to build:
I have created a SharePoint list with the these columns and their Type (Title, Category (Type; Choice), Status (Type; Choice), Priority (Type; Choice), Email Sender (Type; Single line of text), Date Received (Type; Date and time), Date Assigned (Type; Date and time), Date Completed (Type; Date and time), Marked As (Type; Choice), and Assigned To (Type; Person or Group).

I want a ticket created in my SharePoint list when an email is sent to xxx@xxx.co.uk. The ticket created in my SharePoint list will have the "Status" column value as Unassigned, "Date Received" column value will have time and date it was created and "Marked As" column value will be PENDING.

When I assign the ticket to an agent (xxx@xxx.co.uk) in the "Assigned To" column, I want the list updated with these values; "Status" column will change value to Assigned, "Date Assigned" column will show the date and time it was assigned and "Marked As" column value will change to OPEN.

When the Status column value is changed to Completed, I want the SharePoint list updated with the "Date Completed" column showing the date and time, and the "Marked As" column value updated to CLOSED.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@rfclitadim Can you show a screenshot of your Flow B in the Classic Designer with all actions expanded in the edit mode as well as Flow C?

I assume that Flow B and Flow C are both using the When an item is created or modified trigger. This means that both flows will trigger each time an item is created or modified. What I was suggesting in my original post was to add a trigger condition to each of these flows so they only trigger when specific conditions are met.

For example, Flow B should only trigger when the Assigned To column is not empty and if the Status is Pending. Flow C should only trigger when the Assigned To column is not empty and if the Status value is Assigned. Without a trigger condition, both of these flows will trigger each time you make a change to a SharePoint item. The purpose of the trigger condition is to check your SharePoint item first before triggering your flow.

Was this reply helpful? Yes No
rfclitadim 19 on at

Like (0)

Report

@creativeopinion I have managed to rebuild the flow to update my list when I assign the ticket to an email/user but now it keeps recurring every 3 mins . This is the flow below.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@rfclitadim Can you show the full flow? What's the trigger? If you are using the When an Item is Created or Modified trigger, the flow will trigger every time an item is created (when you create a new SP item) or when an item is modified (any change you make to any item).

Have you added trigger conditions to your flow? If not, I would recommend that you add trigger conditions to only trigger your flow when certain conditions are met.

Was this reply helpful? Yes No