Unanswered

dropdown and combobox on choice data type columns

(0) Share

Report

Posted on by blabla70

Hi. as a data source I have the SP List with 20 columns type text and choice, and it shoud have grow up to 2000 rows. I need to filter the values based on 5 columns, dependent on each other. So far I am filtering 3 text type data, successfully, by using a dropdowns.

To further refine the filtering, I need to add two more controls, but possibly on the choice type columns, Level1 and Level2 columns.
I have tried adding these columns, but columns are not being detected, from the dropdown and combobox (image below). If I change the column type in the text, so the columns are detected and it works fine.
What would be a proper way to filter the choice type data? Is there any better solution?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

vikas1606 206 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @blabla70 ,

Choice column binds to dropdown or combo box has a bit different approach. You need to use the below statement on the Items property to bind the data.

Choices([@'SP List Name'].'Column Name')

I hope, This would answer your question.

Was this reply helpful? Yes No
blabla70 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, this answers one part of the question.
The other part is: How to filter 5 (or more, what's the limit?) dropdowns with choice source ?

I am also wandering should the source for 5 cascading dropdowns be the choice type only or the combination of tex and choice type columns. Is there any better solution to narrow down the filtering of 5 or more dependent cascading values?

Thanks in advance

Was this reply helpful? Yes No