cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BQC
Level: Powered On

Sort by two items in gallery

Hello,

I am trying to sort my gallery by two items from my google sheets datasource.

I haven't had any succes at finding a code which can help me with that yet, so hoping that You guys can help me.

my current code is:

 

SortByColumns(Indkøberhåndtering;"Status"; Descending)

As now it is sorting on (column)Status, through my datasource(Indkøberhåndtering) but i also want it to solve on  another column(ForventetAfsluttet) in my datasource. 

If you need more information please let me now.

Thank you in advance!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Sort by two items in gallery

Hi @BQC 

The SortByColumns function enables you to provide multiple columns. Here's how your formula would look:

 

SortByColumns(Indkøberhåndtering;
"Status";
Descending;
"ForventetAfsluttet";
Descending
)

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Sort by two items in gallery

Hi @BQC 

The SortByColumns function enables you to provide multiple columns. Here's how your formula would look:

 

SortByColumns(Indkøberhåndtering;
"Status";
Descending;
"ForventetAfsluttet";
Descending
)

View solution in original post

BQC
Level: Powered On

Re: Sort by two items in gallery

Thank you @timl !

Have a great day

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,406)