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 Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps 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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,655)