web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sort Gallery by multip...
Power Automate
Unanswered

Sort Gallery by multiple choice columns

(0) ShareShare
ReportReport
Posted on by 578

I'm working on a nested gallery using SharePoint data. The data is sorted by Regional Office and it is working fine. The issue is that I need to sort by a second column (State). Both the Regional Office and the State are choice columns. 

 

Sorting / Grouping by Regional Office works fine:

SortByColumns(
 GroupBy(
 AddColumns(
 Filter(
 'Catalog',
 Year = "2021"
 ),
 "RO",
 'Regional Office'.Value
 ),
 "RO",
 "GrouppedROs"
 ),
 "RO",
 Ascending
)

 

When I try to add a second sorting parameter (State), it fails:

 

SortByColumns(
 GroupBy(
 AddColumns(
 Filter(
 'Catalog',
 Year = "2021"
 ),
 "RO",
 'Regional Office'.Value,
 "TheState",
 'State'.Value
 ),
 "RO",
 "GrouppedROs"
 ),
 "RO",
 Ascending,
 "TheState",
 Ascending
)

 

I get an error that says in part that "TheState" column doesn't exist:

 

Annotation 2021-09-03 111216.jpg

 

I have the feeling that all the issue is that I'm creating or placing TheState column in the wrong place. Any idea what am I doing wrong?

Thanks in advance.

 

Categories:
  • Ashwin7104 Profile Picture
    671 on at

    Hey @emfuentes27 ,

     

    Try the below code - I have used ShowColumns instead of Add Columns to ensure TheState exists.

    GroupBy(
    SortByColumns(
     ShowColumns(
     Filter(
     'Catalog',
     Year = "2021"
     ),
     "RO",
     "TheState"
     ),
     "RO",
     Ascending,
     "TheState",
     Ascending
    ),
     "RO",
     "GrouppedROs"
    		)

    - 

  • emfuentes27 Profile Picture
    578 on at

    Thanks for the suggestion @Ashwin7104, but as far as I know I have to use AddColumns also, otherwise how would I define "RO" and the 'TheState". I use AddColumns to define Regional Office.value, as "RO", and "TheState" from State.value?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 377

#2
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 130

Last 30 days Overall leaderboard