Unanswered

Gallery checkbox follows sequence not the actual order

(0) Share

Report

Posted on by biancadevera

I have this gallery checkbox that concatenates in a column in my SharePoint list. The problem is the order gets messy. For example, I have A, B, and C checkboxes. User 1 checked A, B, and C. The data in my SharePoint list will show A,B,C. User 2 checked C, B, and A. The value will show C,B,A. The thing is the values are the same but the order won't sort it properly.

How can I have the right values? The order should be A, B, and C regardless what user checks first.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

biancadevera on at

Like
a
(0)

Report
Copy link

Link copied!

Please help @WarrenBelz @RandyHayes @Pstork1 @AJ_Z

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

What formula are you using to concatenate and send the data to sharepoint :).

Also just in case we need it what are we calling these checkboxes?. What are you expecting it to look like in sharepoint

Was this reply helpful? Yes No
biancadevera on at

Like
a
(0)

Report
Copy link

Link copied!

Here's my formula:

Checkbox within the gallery (galCompany):
Default: ThisItem.Value in colBuilding

galCompany
Items: Choices ([@Corp].'Management')

Data card
Default: colCompany
Update: colCompany

What I want to see in SharePoint are the values checked (collected) The order should be A, B, and C regardless what user checks first. With gallery checkbox, it captures what you select first then throw it to the list.

If gallery checkbox doesn't work for this, do you have any suggestions? I'm trying to add multiple checkboxes within the data card but I can't get it to work.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @biancadevera ,

The point is you need to sort the collection before the values get concatenated like below:

Concat(Sort(colCompany, CompanyName, acsending), CompanyName)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
biancadevera on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni I'll try this. Another concern I have is whenever I export my SharePoint to Excel file, it concatenates but the data is like this A;#B;#C.

Will concat fix this as well?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @biancadevera ,

If it is a Choices column in your SP list, when export the list to Excel, the ;# symbols among the choice values will always be there by design. If it is a People column you will even see the Id value for each value. You could manage to remove them in Excel.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No