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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!
Have you tried something like this?

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

Example:

Was this reply helpful? Yes No
r_voyager 130 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
r_voyager 130 on at

Like (0)

Report
Copy link

Link copied!

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..

Was this reply helpful? Yes No
Verified answer

Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!
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, ",")

Was this reply helpful? Yes No
r_voyager 130 on at

Like (1)

Report
Copy link

Link copied!

Thanks @Anchov . It worked.

Was this reply helpful? Yes No