Unanswered

Am I right in my thinking? this will only delete entries labeled completed, cancelled, or removed?

(0) Share

Report

Posted on by rmartori

So I am making a bot that basically moves any row with the status of Completed, Cancelled, or removed to a archive file.
Then deletes that row. Do I need to add anything special to the key value or will it only delete those three entries based on the Array filter above? Or is there an expression I should put in key value just in case>

I have the same question (0)

All responses (3)

Answers (0)

creativeopinion 10,480 Super User 2025 Season 2 on at

Like (0)

Report

Re: Am I right in my thinking? this will only delete entries labeled completed, cancelled, or removed?

@rmartori What's your flow trigger? Are you using the List Rows Present in a Table action in your flow to loop through all rows in your table to run a condition check on each one?

If you are, it's more efficient to use a Filter Array action to filter out the rows you want to loop through first.

To learn more about how to use the Filter Array action, please refer to this YT Tutorial: Are you using the Microsoft Power Automate Filter Array Action wrong?

In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.

1️⃣ Cross-Referencing Data

2️⃣ Filtering by Key

3️⃣ Substring Matching

Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

IN THIS VIDEO:

✅ 3 Ways to Use the Filter Array Action

✅ How to use the Scope Action to Group Actions

✅ How to Check the Number of Items returned from a Filter Array Action

✅ How to Cross-Reference Data in Excel with a SharePoint List

✅ How the Filter Array Action Works

✅ How to Access the Dynamic Content from a Filter Array Action

✅ How to Filter Items by a Key

✅ How to Filter Items by Matching a Substring

✅ How to Use Multiple Conditions in a Filter Array Action

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!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
rmartori on at

Like (0)

Report

Re: Am I right in my thinking? this will only delete entries labeled completed, cancelled, or removed?

Sorry, right now it is manual but I plan to have it check once a week.
The full flow is the screenshot below. But it is a list rows then for each has the condition, the update and the delete.

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

Like (0)

Report

Re: Am I right in my thinking? this will only delete entries labeled completed, cancelled, or removed?

@rmartori Thx for sharing the screenshot. My original recommendation still stands. It's a lot more efficient to use a Filter Array action. The List rows present in a table action will only allow you to have a single filter query argument. If you can use a single argument such as checking if the Status column is Not Equal to a specific value, then you can use the Filter Query field in the List Rows Present in a table action.

If not, then you'll need to use a Filter Array action. Tip: You can use a single filter query argument in the List Rows Present in a Table action (this will reduce the number of rows returned from this action) in combination with a Filter Array action.

Reference this section of this YT tutorial for how to add multiple conditions to a Filter Array action.This will help you troubleshoot your flow. I cover how to do that in this section of the tutorial.

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!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No