13
I have a simple flow that updates a sharepoint list column with values from an excel spread sheet. I want to skip and move on to the next item if the update fails for whatever reason.
For example, the Field DRF is a drop down lookup, if the value i am updating it with does not exist in the look up it fails, i just want it to move on to the next update item. How can i set that up? Any help would be appreciated! Thanks
@Truss79 I would recommend that you pull the Get Items action outside of the Apply to Each loop. It's more efficient to run that action once in your flow, and use a Filter Array action instead to filter out the item you want to Update. I cover how to do that in 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
---
Can you click to expand the Select actions in your flow?
Share
Report
All responses (
Answers (
