Answered

Display SP multi-select option field as text

(0) Share

Report

Posted on by senna

189

I have a canvas app where a user will enter some details that gets stored on a SP list, there are a few steps to it but at the end of the process there is a text agreement that people have to click accept on, the agreement contains some some of the fields the user has filled out before.

There is a multi select field called "years" where they would select a couple of years, if the user selected "2001,2006,2009" i would want the text to display;

"Years Selected = 2001,2006,2009 ...."

This is what i'm trying but getting an error;

"Years Selected = " & gallery1.Selected.years.Value & " and more text...."

Error;

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

Have you tried wrapping the Value in Text() or after value are there any properties you can select value.displayname for example...

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report
Hello @CiaranCampbell ,

A multi-selection imply the use of a table, which is a collection of values and not a single exploitable value.

I'm not sure if you're using a combo box or a list box, but both should work the same as they return a table if you enable multi-selection.

I suggest using "Concat()" which can concatenate multiple value from a table.

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-concatenate

"Years Selected = " & Concat(gallery1.Selected.years,Value) & " and more text...."

Can you try this code and see how it goes?

Was this reply helpful? Yes No
senna 189 on at

Like (0)

Report

@phipps0218 Thanks for replying, i had tried but nothing will display after "value.", tried wrapping in Text(), no luck either. I had hopped Concat() was the answer but cannot get that to work either

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

Can I please see the entire formula?

Was this reply helpful? Yes No
Verified answer

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (1)

Report

You need to use concat like this:

Concat(Gallery1.SelectedItems, years, "deliminator"

Was this reply helpful? Yes No
senna 189 on at

Like (1)

Report
Thank you @phipps0218 that solved it, here is the full working concat for anyone else in the future

Concat(gallery1.Selected.years,Value, ", ")

Was this reply helpful? Yes No