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!

All responses (6)

Answers (0)

v-jefferni on at

Like (0)

Report

Re: Gallery checkbox follows sequence not the actual order

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.
biancadevera on at

Like (0)

Report

Re: Gallery checkbox follows sequence not the actual order

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?
v-jefferni on at

Like (1)

Report
Re: Gallery checkbox follows sequence not the actual order

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.
biancadevera on at

Like (0)

Report

Re: Gallery checkbox follows sequence not the actual order

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.
AJ_Z 3,720 on at

Like (2)

Report

Re: Gallery checkbox follows sequence not the actual order

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
biancadevera on at

Like (0)

Report

Re: Gallery checkbox follows sequence not the actual order

Please help @WarrenBelz @RandyHayes @Pstork1 @AJ_Z