Answered

choice drop down

(0) Share

Report

Posted on by Ramole Super User 2024 Season 1

Hi All,

i would like a help please i have 2 choice dropdown1 and dropdown2 and would like when i select dropdown1 the dropdown2 to filter dropdown 1 = example dropdown1 i select UPS now when i select dropdown2 it only show me the filter and correct one is UPS GROUND please see the screenshot Thanks

The first photo i have managed to do it but i am unable to do while inside the form.

Below is inside the form and i am unable to do the filter. the data is coming from sharepoint list dropdown choices.png dropdown choices 1.png

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

In the dropdown properties (on the right side of your screen when the dropdown is selected), you should see a "Depends on" option under the "Items" and "Value" selection. Use that to add a filter to the second dropdown that depends on the first dropdown selection.

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

i want what code to use the format please

thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This is what you would have in the Items property of your second dropdown

Filter(YourDropDownSource, ID = OtherDropDown.Selected.ID)

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

still getting error not working

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

This the original code for the second dropdown2 Choices([@'Shipments '].ShippingRoute)

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi All,
Please help i am still having problems to fix this as you see on the screenshot when i try the format code on inside the form it doent work, but if i try to test without forms just blank screen with two dropdown it will work the code, Please help Thank you

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
@Ramole,

Can you share the option items of two choices columns?
I don't think the codes you use on the combo boxes out of the form is correct, because the second dropdown items is based on the current records that you have select right Shipping Route, if you clear all record or select another Shipping Route for FedEx record, your second combo box will show another selection.
If text string of Shipping Route selection all begin with the text string of Shipping Method's selection as below screenshot, you can set Items property of second combo box as below:
Filter(Choices([@'Shipments '].ShippingRoute), StartsWith(Value,Combobox1.Selected.Value))
Note: combobox1 is named as DataCardValue1 in the Form
If this doesn't make sense, please let me know.
Best regards,
Sik

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft

Thank you so so much it works now.

Was this reply helpful? Yes No