web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Incompatible types for...

Power Apps

Answered

Incompatible types for comparison... combobox

(0) Share

Report

Report

Posted on by BiTry

313

Hi,

Incompatible types for comparison... why ?:(

Gallery item
Filter(EXCELSource,'típusa'=ComboBox1.SelectedItems)

'típusa'-> Text format in Excel, Excel is imported in the app.

Combobox value.

["típusaa","zavar","jatékos","Enyhe","Mozg ","Nem "," figyelem "]

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

theapurva 970 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
hello @BiTry.
Here you were trying to compare text with number of records as ComboBox1.SelectedItems would give a table of records.

so, please use as below:

Filter(EXCELSource,'típusa'=First(ComboBox1.SelectedItems).Value)

Was this reply helpful? Yes No
BiTry 313 on at

Like
a
(0)

Report
Copy link

Link copied!

I see, this works :)... but it doesn't filter by multiple selection in the gallery,

Was this reply helpful? Yes No
Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
you can try this for mutiple items but its not delegable:

Filter(EXCELSource,'típusa' in ComboBox1.SelectedItems)

Was this reply helpful? Yes No
BiTry 313 on at

Like
a
(1)

Report
Copy link

Link copied!

Excellent!:) With an Excel source, delgable is not a problem,

Was this reply helpful? Yes No

Join the conversation