Unanswered

PowerApps multi-select Listbox - Set and Retrieve values to/from SharePoint Multiple lines of text field

(0) Share

Report

Posted on by CCJones

244

I have an app where a multi-select listbox gets its choices from a lookup list in SharePoint. It should then store the selected values in a SharePoint text field in the main request list. Finally, it needs to be able to display the selected items in the list box when the form is opened for review.

I have the app saving all the selected values to the SharePoint text field using the formula below.

Concat(DeliveryMethodValue.SelectedItemsText.Value, Concatenate(Text(Value),", "))

However, it does not retrieve the values when the form is opened. The listbox shows no items as selected. I have no idea how to do this or if it's even possible.

Any ideas?

Thanks!

Categories:

General Questions

Using Apps Using Formulas

All responses (4)

Answers (0)

WarrenBelz 146,635 Most Valuable Professional on at

Like (0)

Report

Re: PowerApps multi-select Listbox - Set and Retrieve values to/from SharePoint Multiple lines of text field

Hi @CCJones ,

Sorry, I have not attempted this with a List Box - you can try with the Default.
CCJones 244 on at

Like (0)

Report

Re: PowerApps multi-select Listbox - Set and Retrieve values to/from SharePoint Multiple lines of text field

Just as an update, I tried adding the Split and RenameColumns formulas in the Default property of the ListBox and they don't work. It expects a text value.
CCJones 244 on at

Like (0)

Report

Re: PowerApps multi-select Listbox - Set and Retrieve values to/from SharePoint Multiple lines of text field

Thanks Warren. Since I am using a listbox and not a combobox, woud there be any major differences? Like I only see a "Default" field versus a "Default" and "DefaultSelectedItems" as with the combobox. Would the format of the formula to place in DefaultSelectedItems value also work in the Default property?
WarrenBelz 146,635 Most Valuable Professional on at

Like (0)

Report

Re: PowerApps multi-select Listbox - Set and Retrieve values to/from SharePoint Multiple lines of text field

Hi @CCJones ,

I believe this blog of mine sets out the process you need.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps