web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter dependable choi...

Power Apps

Answered

Filter dependable choice selection between columns in combo box

(0) Share

Report

Report

Posted on by Aionik

103

Hi,

I want to get all matching models based on my selected device combobox. Both are choices columns in the "ModelLib" sharepoint:

Title	Device (Data Type: Choice)	Models (Data Type: Choice)
1	Laptop_1	Flex
2	Laptop_1	Hyper
3	Laptop_2	Yolo

Use case:
When I select Laptop_1 in my drp_device combobox,

I want to display the suitable models in the drp_model combobox.

I would only get Flex and Hyper in the models combobox to choose, when I have selected "Laptop_1" in the previous combobox.

My current attempt is:

AddColumns(Choices(ModelLib.Modellseries_Modell);"option"; Text(Value))

I have issuse regarding showing the output as value in the models combobox.

Any help is appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Gerard Simpson 2,987 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Aionik

Try the following in the items property of the drp_model combobox:

AddColumns(

Filter(

ModelLib,

Device.Value = drp_device.Selected.Value

),

"ModelOption",

ThisRecord.Models.Value

).ModelOption

Hope this helps

Was this reply helpful? Yes No

Join the conversation