web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sorting on a distinct ...

Power Apps

Answered

Sorting on a distinct column from a merged table

(0) Share

Report

Report

Posted on by alvinlinjr

4

Hello there,

How may I sort on Column A of the following table:

Distinct(Ungroup(Table({Merged:TableA},{Merged:TableB},{Merged:TableC},{Merged:TableD}),"Merged"),'ColumnA')

The following does not seem to work:

Sort(Distinct(Ungroup(Table({Merged:TableA},{Merged:TableB},{Merged:TableC},{Merged:TableD}),"Merged"),'ColumnA'), SortOrder.Ascending)

Thanks in advance for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

WarrenBelz 154,496 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @alvinlinjr ,

Dealing with syntax only (assuming the top code works)

Sort( Distinct( Ungroup( Table( {Merged: TableA}, {Merged: TableB}, {Merged: TableC}, {Merged: TableD} ), "Merged" ), 'ColumnA' ), Value, SortOrder.Ascending )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
alvinlinjr 4 on at

Like (0)

Report
Copy link

Link copied!

Works perfectly - I was missing Value in Syntax. Thanks so much, @WarrenBelz !

Was this reply helpful? Yes No

Join the conversation