Are you using the Microsoft Power Automate Filter Array Action wrong?

[@iddycol]

I've watched a lot of Power Automate videos - this is one of the best I've seen. Great explanations of some advanced techniques. Thank You.

[@acreativeopinion]

Thanks for watching!

[@ernestoleon3995]

Reeeally helpful thanks!! What about if i want to update the existing data... I have not been able to modify to update existing data.

[@acreativeopinion]

Thanks for watching!
To update existing data you need to change the operator in the Filter Array action to contains. This will filter out the items from your Excel Table that already exist in your SharePoint list.

[@vaclavbenysek9576]

Hi and thank you for the video, I’ve been doing it the wrong/slow way. I have the same question as Ernesto. I get either an array of existing data from excel or list. If I have it from a list I can get the id of the item to update, but I don’t know how to get the right data for that particular row from excel. If I have excel data I can use those, but I don’t know how to get the right list item ID to update.
I managed to do it by looping through the excel data, getting array of list items where the unique identifier matches and then for each such found list item update all the values with excel data..not so pretty. Also, it unnecessarily updates items which are not different from the excel data.

[@umairismail9555]

Hi any way to filter using array / list ["Value A", "Value B"]

[@acreativeopinion]

Thanks for watching. I'm unclear on the ask. I would recommend posting your question in the Power Automate community and including screenshots: community.powerplatform.com/?redirectedFrom=community.powerplatform.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

[@MeisterCrashFM]

Really great explanation. I still have one tip. It is possible to use contains in the Get Item action. However the ODATA command is another "substringof('Text',FileLeafRef)".

[@acreativeopinion]

Thanks for watching!
Yes you can also use the substringof() operator. However, it doesn't seem to work with the time/date columns which is why a Filter Array action would need to be used instead.

[@AkishaAnthony]

How can I reach you if I have questions?

[@ianianjg8464]

Thanks for the video.

[@M4croz]

Great video!, but for some reason when im using an apply to each it doesnt loop through all my items, only 1, but i already confirmed that there are 2 items in the filter array outputs:c dont know what is happening

[@chenchen-y1s]

thanks your video, i came into one issue, one column name is lookup type, the internal name Field=Lab_x0020_Name_x003a_Country, i try the Lab_x0020_Name_x003a_Country/Ttile eq 'xx' , bad request: Column 'Lab_x0020_Name_x003a_Country' does not exist. how can i fix this ?

[@acreativeopinion]

Thanks for watching! Look up columns require an ID match. It's hard to troubleshoot a flow in the YT comment section. I would recommend posting on the Power Automate Community: community.powerplatform.com/?redirectedFrom=community.powerplatform.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Ensure you include screenshots and provide as much detail as possible.

[@chenchen-y1s]

@@acreativeopinion i guess so, check the code from website, MS PAM make is hard... LOL

[@scottryan5150]

Fantastic solution and great explanation! I learned soooo much from this one video. Thank you!

[@marksimmonds4818]

THIS! Thank you!

[@acreativeopinion]

Thank you so much for watching!