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
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 187 members 4,674 guests
Please welcome our newest community members: