Incompatible types for comparation

(1) Share

Report

Posted on by CU31071525-4

Hello, I need help with a thing, I need to get different values using different listbox, the problem is that when I select two or more different values, the List start only using the last value clicked. If you have a solution about how to get all the values depending on the clicked values.

For example on the video we can see 3 values "Nissan", "Honda" and "KIA", all of these have different codes, in the middle list box, we can see the codes, the problem is that I can't keep all the values whe I select two or three values.

As you can see in here, I'm using this code:

Filter('Administración SR1'; Cuenta.Value = ListBox1_3.SelectedText.Value)
 
But I need to use this form, because I need to select more items and the forme selected.Value is just for one:Filter('Administración SR1'; Cuenta.Value = ListBox1_3.Selecteditems)
 
The problem is that Is incompatible
 
Here's how I actually use it:

Categories:

Connectors

General Questions

Problema.mp4

All responses (2)

Answers (1)

Verified answer

Giraldoj 561 Super User 2025 Season 1 on at

Like (2)

Report
Incompatible types for comparation

Hi there,

you can use the In operator with the Filter function, you coude should be something like:
Filter( coll_AdminSR1, Cuenta.Value in ListBox1.SelectedItems )
You can find more information and recomendation about filter function here:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup#examples

If this helps, please mark it as the solution by clicking "Accept as solution." A "Thumbs Up" would be greatly appreciated if you found the content helpful. Thanks!
Best,
LinkedIn: https://www.linkedin.com/in/jhonatan-giraldo-2b20561b9/
CU31071525-4 10 on at

Like (0)

Report

Incompatible types for comparation

.