cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
biancadevera
Helper III
Helper III

Gallery checkbox follows sequence not the actual order

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!

6 REPLIES 6
biancadevera
Helper III
Helper III

AJ_Z
Super User
Super User

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

 



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

biancadevera
Helper III
Helper III

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.

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.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

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?

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.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (3,825)