Condition Expression Result False

[ScottInSB]

Hello there,

Newbie to SharePoint. I'm trying to move items from one list to an "archive" list based on a Status (Choice) column being updated with a selection of "Complete". I've been through a bunch of other messages here to create an automated workflow and am hitting a road block. Whenever I do a test run, the flow runs successfully but the condition expression comes back as "False".

The flow is below. It may look like a mess as I've borrowed from other flows. Hopefully someone can help me figure this out.

 

 

 

 

 

[v-mengmli-msft]

Hi @ScottInSB ,

Please check the status dynamic content in condition.

If you are using 'Status' instead of 'Status Value', the condition will always return false. This is because 'Status' returns an array, it isn't equal to a string.

Best regards,

Rimmon

[ScottInSB]

Hi @v-mengmli-msft,

I did what you said. When I use Status Value, it automatically adds an Apply to Each for to entire condition. 

 

When I run,  it comes back with an Action Failed.

[creativeopinion]

@ScottInSB You should't need an Apply to Each action in your flow since your flow is triggered when an Item is Created or Modified. The reason Power Automate is automatically adding Apply to Each actions to your flow is because the Department, Status, Contact and Currently Assigned To columns accept multiple values. Even if there is a single value stored in your SP list, it will return the values as an array.

If you don't require multiple values for those columns, I would recommend toggling the Allow multiple selections off.

I think you'll find these YT Tutorials helpful: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:

1️⃣ Looping through a Single Item

2️⃣ Creating Unnecessary Nested Loops

3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

I'll also cover:

✅ How to avoid the Apply to Each action with a single item array

✅ How to use the item() function to access dynamic content in an array

✅ How to prevent unnecessary nested Apply to Each action loops

✅ How to use the Select action

✅ How to convert an array to a string with the Select action

✅How to use the Filter Query field

✅ How to count the number of items in an array

✅ How to use a condition control

✅ How to use the concurrency control

✅ How to set a top count

✅ How to use Compose actions for troubleshooting

-----

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

[ScottInSB]

@creativeopinion I viewed the video but am still running into issues. When I run a Test, it comes back with everything below Apply to each 3 faded out:

 This is what the flow looks like:

 

Department and Status consist of multiple selections, and more than one can be selected at the same time. Contact and Currently assigned to are claims and can also have more than one selected at the same time.

The key here is that if Status has "Completed" selected, the item with its current selections needs to be moved to the archive list. 

Sorry if this is very basic. Again, I'm a newbie. 

[creativeopinion]

@ScottInSB According to your original post, you only want to update the item if the status column is Complete. You should evaluate that first. Ideally, you should add a trigger condition so your flow doesn't even trigger unless the item has been updated to Complete.

However, can you clarify why more than one status would be selected? Confirming that the flow should only trigger if the status only contains Complete an no other status? Is that correct?  

The nested Apply to Each actions are the issue in your flow. You need to parse your multiple choice selections. You aren't doing that which is why each time you add dynamic content into your flow—it's automatically adding an Apply to Each action.

[ScottInSB]

@creativeopinion , I made some adjustments to the list. A Yes/No column has been added to indicate if the item is complete or not. This is what I'm now using as as the condition, instead of the Status field. I've also updated the Status to Complete instead of Status Value, since the Item will be complete when the Complete checkbox is checked and the item is moved to the Archive list. Test results in a True expression result, however, the flow is not completing, it appears to be hung up on Currently Assigned To. This and the Contact fields will typically have names, but not always. There may be situations where it is left blank.