How to display a collection in a combo box when a selection in another combo box is made

(0) Share

Report

Posted on by LS579

134

Hi,

I have a Power Apps SharePoint Integration form that has two cascading combo boxes. The first combo box displays Client names and the second displays roles depending on each client that is selected. I am switching this from an InfoPath form and in that, the second combo box is pulling from a different SharePoint list. I couldn't figure out how to do that, so I figured creating collections for each client would do the trick, but now I'm trying to figure out the function to show each collection when each client is selected. I am trying to use an If() function, however all I have so far is If(cboClient.Selected.Value = "Client Name", .

Thanks In Advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @LS579, In the first combo box (cboClient), you can Set the 'Items' property to your Clients SharePoint list. Then on the second combo box: Set the 'Items' property to

Filter(RolesList, Client.Value = cboClient.Selected.Value)

where 'RolesList' is the SharePoint list containing roles, and 'Client' is the column containing client names in the Roles list.

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Was this reply helpful? Yes No

LS579 134 on at

Like (0)

Report

Something with this is not working. I have tried the code above and even tried connecting it to the same list as cboClient and the combo box drops down like there are options, but no text is showing. I checked the text properties and the text is set to show as black, so that's not the issue. And there aren't that many roles per client, five roles max.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@LS579 Do you have labels that are mapped to desire field in your gallery?

Was this reply helpful? Yes No
LS579 134 on at

Like (0)

Report

I'm sorry, I am unsure of what you are asking. There isn't a gallery in my app, just the mobile form shown in the picture

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

@LS579, on the RBAC Role ComboBox.Items property use:

ShowColumns(Filter(RolesList, Client.Value = cboClient.Selected.Value),ColumnToShowData)

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Was this reply helpful? Yes No

LS579 134 on at

Like (0)

Report

That formula is giving me an error at cboClient.Selected.Value Where "Value" isn't recognized.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report
@LS579, try this:

ShowColumns(Filter(RolesList, Client.Value = cboClient.Selected),ColumnToShowData)

Was this reply helpful? Yes No
LS579 134 on at

Like (0)

Report

That did not work either. It just made the two incompatible. I tried a mixture of things including This.RBACRole.Value in place of Client.Value, removing ".Value" from both sides, SelectedItems instead of just Selected, etc. Nothing wants to work with that formula.

Was this reply helpful? Yes No