SharePoint List with a Choice column that is set to “allow multiple selections”

Like (1) Share

Report

Posted on 3 Aug 2021 17:11:40 by chendricks

I have SharePoint List with a Choice column (Department) that is set to “allow multiple selections”.

I created the Power App through SharePoint using the Integrate, Power Apps, Create links and this created a Power App with the standard Browse, Detail and Edit screens.

On the Browse screen I have resolved my label issues using the Concat(ThisItem.Department,Value & ", ").

On the Detail screen it is not displaying the values, in the Combo Box, that are already in the SharePoint field for this record.

On the Edit screen, I can choose items from my SharePoint list, in the Combo Box, but the form will not submit.

Categories:

Connecting to Data

I have the same question (0)

All responses (5)

Answers (2)

Caz_16 82 on 03 Aug 2021 at 20:35:52

Like (0)

Report

Re: SharePoint List with a Choice column that is set to “allow multiple selections”

So when you allow for multiple selections as you are in your SharePoint list, it is stored in the SharePoint data source a nested table. Meaning, for each record (or row) for your main table "Incident Management" in the department column is a table which contains a second list with the selected values. So you should be able to unpack that nested table using a Data Card, and the following:

Choices([@Table].Column)

As regard to Patch(), since you need to convert the values in the dropdown to a Table, which is then patched to the record, I recommend the following method in this post: https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-patch-main-table-and-nested-table/m-p/809085#M257987.

Also a note, I would recommend not having spaces in your column or table names. Use underscores ("_") instead.

Caz

Was this reply helpful? Yes No
chendricks 17 on 03 Aug 2021 at 21:43:22

Like (0)

Report

Re: SharePoint List with a Choice column that is set to “allow multiple selections”

@Caz_16 thank you so much for the reply.
The department card is called "Department_DataCard2" and "DataCardValue18" is already set to "Choices([@'Incident Management'].Department)" as seen in 2nd attached image, unless you are saying I need to apply this somewhere else.

Was this reply helpful? Yes No
Verified answer

Caz_16 82 on 04 Aug 2021 at 12:32:41

Like (2)

Report
Re: SharePoint List with a Choice column that is set to “allow multiple selections”

Couple of basic troubleshooting steps to try:

1) Delete the data card, and re-add it to your app. Then try and read the values with your code above
2) Remove your SharePoint Data source and re-add it to your app. (SharePoint can be touchy and lose connection to your app occasionally).
3) Check to make sure that the item you select on the Browse screen is being carried over to the Details screen. Usually PowerApps does this by assigning it to "ThisItem". However it is a best practice to use a global variable instead. On your Browse screen gallery, set the OnSelect property to include

Set(ItemSelected,ThisItem);

Then on all your other screens use ItemSelected.Value (or whatever) to access the record. ThisItem for me has caused issues in the past. Also check and ensure all of your Select(Parent) items are correct.

After those steps I cant really help more without more details of your data model and your app. As you can see the Choices(_) method is working for my simple test.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on 04 Aug 2021 at 12:43:07

Like (1)

Report
Re: SharePoint List with a Choice column that is set to “allow multiple selections”

Hi @chendricks

On Edit Screen, please make sure the Update property is set to

DataCardValuex.SelectedItems

DataCardValueX - Replace your

1. The above property is valid If you use SubmitForm(FormName).

2. If you use the Patch function then the previous Update property is not valid. In this case, Attributes is a multi-select choice

Patch( 'Issue tracker', Defaults('Issue tracker'), { Title: DataCardValue9.Text, Attributes: DataCardValue17.SelectedItems } )

SP List

Was this reply helpful? Yes No
Verified answer

chendricks 17 on 04 Aug 2021 at 15:55:49

Like (0)

Report

Re: SharePoint List with a Choice column that is set to “allow multiple selections”

@Caz_16 - Deleting the card and re-adding it resolved the problem on my Detail screen.
Thank you!

Was this reply helpful? Yes No