Unanswered

Multiselect Combobox and sharepoint list

(0) Share

Report

Posted on by russrimm Microsoft Employee

Hi all,

I have a sharepoint list column (currently set to single line of text) that i've been flipping back and forth from single line of text to choice and trying to figure out the most straightforward solution.

I have a multiselect allowed combobox, and need it to addcolumn to show a translated version of what's in the list for the selected record.

Column name in the SPList is "Race", and values in the SPList could be things like W, B, PI which is White, Black, Pacific Islander, for example. I do want to allow multiple race selections. There's values in each record already so I want to display all the current values (translated from code to actual race).

I'm using a form so trying to do it using SubmitForm vs Patching it as well.

I'm finding many examples but haven't been able to apply any to my scenario yet to actually get it to work yet.

Thanks in advance for any assistance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
So you want to add a column that transforms the abbreviation into the whole race? That would look like this:
AddColumns( TestTable, "RaceTerm", Switch( Race, "W", "White", "B", "Black", "PI", "Pacific Islander" ) )

Was this reply helpful? Yes No
russrimm Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks that's helpful - i'm struggling to figure out what to set for Default and DefaultSelectedItems in order to show all the values stored and Update for the datacard to properly update it when the form is submitted? And is it easier to save multiple selected combobox values to a single line of text Sharepoint list column (comma delimited?), or multiple lines of text, or choice ?

Thx again!

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

Like (0)

Report
Copy link

Link copied!

@russrimm wrote:
i'm struggling to figure out what to set for Default and DefaultSelectedItems in order to show all the values stored and Update for the datacard to properly update it when the form is submitted?
You mean like resetting the combobox once a user submits a form? For that you can use Reset() after the Submit function.

As for storing multiple selections in a SharePoint column, it depends on how you want to access that data later. Comma separated is pretty safe since you can display it in an easy-to-read format such as 'Value1, Value2, Value3'.

Was this reply helpful? Yes No