Answered

Power Apps Dropdown Item property settings

(0) Share

Report

Posted on by kjk4563

134

In Power Apps, when the Items property of the two dropdowns has the same value as the image above, if you select 1, only 1-1 will be visible, and if you select 2, 2-2, 3 will be visible. 3-3. I'm curious about how.

You should use this when importing values from SharePoint into Choices in Power Apps.

please tell me what to do

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi , @kjk4563

This is my test data:

ClearCollect(Items1,["1","2","3"]);

ClearCollect(Items2,["1-1","2-1","3-1"]);

Combo box 1 -items :

Items1

Combo box 1 -OnChange:

Reset(ComboBox2)

You can update your second combo box -items property.

Filter( Items2 , StartsWith(Value, ComboBox1.Selected.Value ) )

Filter( Your code in Combobox2-items property , StartsWith(ColumnName, ComboBox1.Selected.Value ) )

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
kjk4563 134 on at

Like (0)

Report
Copy link

Link copied!

@v-yueyun-msft
I made a mistake in asking the question
That answer is valid, but what I need now is something else, so I leave the question again.

i want this
If item 1 is 1, 2, 3 and item 2 is A, B, C, D, E, F, if you select 1, A and B will be displayed, if you select 2, C, D will be displayed, and if you select 3, E and F will be displayed.
I would like to know what to do.

FYI, I know that StartWith takes the starting character. Is this correct?

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi , @kjk4563

For your question "FYI, I know that StartWith takes the starting character. Is this correct?" :

Sure , your understand is right.

If you want to realize it , you can use this code in Combo box2 -items property:

Switch(ComboBox1.Selected.Value , "1" , ["A","B"] , "2",["C","D"] ,"3" ,["E","F"] , ["A","B","C","D","E","F"] )

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
kjk4563 134 on at

Like (0)

Report
Copy link

Link copied!

@v-yueyun-msft
Switch(ComboBox1.Selected.Value , "1" , ["A","B"] , "2",["C","D"] ,"3" ,["E","F"] , ["A","B","C","D","E","F"] )

Is it possible to only get the 1st, 3rd, and 5th selections from Choices(Table1.status) that I'm getting from SharePoint instead of this part [""] of the code above?

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi , @kjk4563

You can try to use this code:
[Index(Choices(Table1.status),1).ColumnName,Index(Choices(Table1.status),3).ColumnName,Index(Choices(Table1.status),5).ColumnName]

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No