Sort multiple columns as per selected selected column

(0) Share

Report

Posted on by Sayyad

Hi,

I have to Sort the data for six columns as below details

I can sorting column 1 , 2 and 5 but 3, 4, and 6 are not working from below function. I was updating context like {sortByColumn: 1, sortOrder: !sortOrder} so on....from Onselection of six different Sort icons for each column

Sort(
 sharepointSitesCollection,
 If(
 sortByColumn = 1,
 Text('Title (SiteTitle)'),
 If(
 sortByColumn = 2,
 Created,
 If(
 sortByColumn = 3,
 'PRIMARY_OWNER'.'DisplayName',
 If(
 sortByColumn = 4,
 'SECONDARY_OWNER'.'DisplayName',
 If(
 sortByColumn = 5,
 Text('Expiration Date'),
 If(
 sortByColumn = 6,
 'External Access'
 )
 )
 )
 )
 )
 ),
 If(
 sortOrder,
 Ascending,
 Descending
 )
 )

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @Sayyad ,

Try this - note you will be limited by what you sort with Delegation as you need AddColumns to sort by complex field types and calculations.

Sort( AddColumns( sharepointSitesCollection, "SecOwner", 'SECONDARY_OWNER'.DisplayName, "PrimOwner", 'PRIMARY_OWNER'.'DisplayName', "Site", Text('Title (SiteTitle)'), "Expiry", Text('Expiration Date') ), Switch( sortByColumn, 1, Site, 2, Created, 3, PrimOwner, 4, SecOwner, 5, Expiry, 6, 'External Access' ), If( sortOrder, Ascending, Descending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Sayyad 2 on at

Like (0)

Report

can we use directly Switch instead of AddColumns ??

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@Sayyad ,

No - because you cannot sort with complex field types (it is one of the many reasons I use them very rarely)

Was this reply helpful? Yes No