Control Box with multiple selection in PowerApps Form

(1) Share

Report

Posted on by IvenSch

376

Hello together,

I`d like to have a field in my PowerApps Form that allows selection of multiple values.

But although I have created such a column in my linked SharePoint list, it only shows a dropdown in PowerApps.

Does anybody know why?

Categories:

Building Power Apps

I have the same question (0)

All responses (22)

Answers (0)

poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
@IvenSch

In Power Apps, when you're using a form connected to a SharePoint list that contains a column for multiple selections (e.g., a Choice column set up for multiple selections), it should automatically translate to a combo box control in your Power Apps form.

If for some reason, this is not happening for you, then it might be due to some form settings on your end, or there could be some synch issue between Power Apps and SharePoint.

Here are some steps to try and fix the issue:

1. Check Column Type in SharePoint: Make sure your SharePoint column is of type 'Choice' and is configured to allow multiple selections. If it is not, please modify the column settings in SharePoint to allow multiple selections.

2. Refresh Data Source in Power Apps: Sometimes, changes made in SharePoint may not be reflected in Power Apps immediately. In such cases, you might want to manually refresh the data source in Power Apps. Here's the formula for doing that:

Refresh('Your SharePoint List Name')

After using the Refresh function, try to re-add the data source to your form and see if the issue is resolved.

Alternative way to refresh: - click Data on left side, then your data source, ellipses on the right, click Refresh button, try this as well.

3. Manually Change the Data Card Control to Combo Box: If the above steps do not work, you can manually change the data card control in Power Apps form to Combo Box. Here's how you can do that:
- Select the Data Card and unlock it. You can unlock the data card by selecting the data card and toggling the 'Lock aspect ratio' switch to Off in the 'Properties' pane.
- Delete the current dropdown control inside the Data Card.
- Insert a Combo Box control in the Data Card.
- Set the Items property of the Combo Box to the column from the SharePoint list that allows multiple selections. If your SharePoint list column name is 'Choices', the formula would look like this:

Choices('Your SharePoint List Name'.'Column Name')

- Set the DefaultSelectedItems property of the Combo Box to:

ThisItem.'Column Name'

Please replace 'Your SharePoint List Name' and 'Column Name' with your actual SharePoint list name and column name respectively.

Hope it helps @IvenSch

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

Like (0)

Report

Hi @IvenSch,

You should create a choice column in your SharePoint list and then refresh the data source in your power apps once you do that you will get a form that will use a Combo-Box allowing multiple choice selections for that column. You can also add a Combo-Box instead of Drop-Down manually and configure the update and default properties manually.

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
IvenSch 376 on at

Like (0)

Report

Thanks a lot dear both for your help. Unfortunately these options do not work as it seems.
Attached you``ll find some screenshots from my actual settings.

2023-08-03 10_01_...

2023-08-03 10_07_...

2023-08-03 09_59_...

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

Like (0)

Report
Hi @IvenSch,

Try following these steps.

add a new choice column

fill out the fields as in the screenshot below or change according to your preferences.

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
IvenSch 376 on at

Like (0)

Report

I already did this several times, but it always only shows a dropdown menu when inserting the field to PowerApps Form, although my choice in SharePoint is Radio Button

Was this reply helpful? Yes No
IvenSch 376 on at

Like (0)

Report
If I add
ThisItem.'Column Name'
to DefaultSelectedItems I get a warning: "This formula uses a range. This is not currently supported for evaluation"

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

Like (0)

Report
Then, try the following steps:
Click on the data card where the Combo-Box needs to be added.
If it shows a popup saying 'Unlock and Add,' click 'Unlock and Add.'
After you have successfully added the Combo-Box, copy the name of the Drop-Down and remove it from the data card.
Rename your Combo-Box and paste the previously copied Drop-Down name.
Finally, update the 'Items' property of your Combo-Box to 'Choices(listName.ChoicesColumnName).'
If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
IvenSch 376 on at

Like (0)

Report

I`m sorry, but this also doesn`t work here 😞
The DataCardValue is also already a combo box, but I do not understand why this doesn`t work.
Also if I add a seperate Radio button, it is not possible to add the column to it. It always shows a drop-down.

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

Like (0)

Report

Just try removing the DataSource and form and add them again and see if it helps

Was this reply helpful? Yes No
IvenSch 376 on at

Like (0)

Report

Unfortunately not 😞
So I have to work with drop-down further, although I do not understand where the mistake is

Was this reply helpful? Yes No