Answered

Display choice column values from all rows

(0) Share

Report

Posted on by r_voyager

130

I have 3 rows in my sharepoint list having one choice column in which there are multiple values..

I want to show all choice column values from all rows in a text label separated by space.

I tried: " Left( Concat( LookUp(phasecc,UserID=TemplateGalleryList1.Selected.'User ID' ).Class,Value & Char(10 )) , Len( Concat( LookUp(phasecc,UserID=TemplateGalleryList1.Selected.'User ID' ).Class,Value & ", " ) ) -1) "

where class is choice column

but I'm getting only first row values not from all rows.

Thanks

Any help will be much appreciated.

Categories:

Using Apps Using Formulas

Connecting to Data

General Questions

All responses (6)

Answers (1)

r_voyager 130 on at

Like (1)

Report

Re: Display choice column values from all rows

Thanks @Anchov . It worked.
Verified answer

Anchov 1,951 on at

Like (0)

Report
Re: Display choice column values from all rows

I think the issue is with using a Lookup, as a lookup will only ever return one record at a time. I tried doing this with a filter function, but then I just has a table of tables. I had to "flatten out" the table like this (done with a button, OnSelect):
Clear(colFlat); ForAll(Filter(Demo.MultiChoices, !IsEmpty(MultiChoices)), Collect(colFlat, ThisRecord.MultiChoices.Value)); // You filter would be on the unique user id, in this example I am i am just filtering out items without any choices ClearCollect(colFlat, Distinct(colFlat, Value)) //this is just filtering out duplicates, may not be neccesary in your case.

Then my label (Text) looks like:
Concat(colFlat, Result, ",")
r_voyager 130 on at

Like (0)

Report

Re: Display choice column values from all rows

I'm trying to span multiple Sharepoint rows (with the same User).

Using this formula : " Left( Concat( LookUp(phasecc,UserID=TemplateGalleryList1.Selected.'User ID' ).Class,Value & Char(10 )) , Len( Concat( LookUp(phasecc,UserID=TemplateGalleryList1.Selected.'User ID' ).Class,Value & ", " ) ) -1) "

Attached the output..

But I should get all the Classes shown in question..I'm only getting first row values..
Anchov 1,951 on at

Like (0)

Report

Re: Display choice column values from all rows

@r_voyager , I don't think that would matter, are you trying to span multiple SharePoint rows (with the same User) or multiple class choices in the same SharePoint row?
Are you getting a formula error? Are you ablet to share a screenshot of what you are seeing?
r_voyager 130 on at

Like (0)

Report

Re: Display choice column values from all rows

Hi,

Thanks for your reply but it's not working.

Actually, earlier this was a single line text column, I converted it to a choice column. Can this be a reason?
Anchov 1,951 on at

Like (0)

Report
Re: Display choice column values from all rows

Have you tried something like this?

Concat(Filter(phasecc, UserID = TemplateGalleryList1.Selected.'UserID').Class, Value, ",")

Example: