Unanswered

Filter Array

(0) Share

Report

Posted on by CU06021343-1

Hello, I'm trying to filter the items in the Code column that are in the excel table and that are not in the SharePoint list, but the Filter Array is returning all items, those that do not contain and those that do.

What do I need to correct to filter only those that are not in the SharePoint list?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi @jcnascime1

I think highlighted expression is wrong,

item() represent each row of excel with respect to values dynamic content, so here we need to check code column of excel not the entire row. For that if the column name of Code column is Code , use item()?['Code'] like that

Hope it helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
CU06021343-1 on at

Like (0)

Report
Copy link

Link copied!

yes, I'm applying it this way

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @jcnascime1

Could you show me how the output of Isolated Items looks like?

Was this reply helpful? Yes No
CU06021343-1 on at

Like (0)

Report
Copy link

Link copied!

Here it is

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @jcnascime1

I think you may have to convert the code column to int type while comparing, you have to change the expression from item()?['Code'] to int(item()?['Code'])

Hope it helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
CU06021343-1 on at

Like (0)

Report
Copy link

Link copied!

returned this error

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @jcnascime1

One doubt

Does code column only has integer values ?

Was this reply helpful? Yes No
CU06021343-1 on at

Like (0)

Report
Copy link

Link copied!

Yes, only columns with integers

Was this reply helpful? Yes No