Skip to main content

Notifications

Community site session details

Community site session details

Session Id : P3nD/YYS4Up/cUqOLLEy8B
Power Apps - Building Power Apps
Unanswered

sort with distinct

Like (0) ShareShare
ReportReport
Posted on 7 May 2016 18:01:39 by

Is it possible to combine in one function DISTINCT and SORT? And how can it be possible to create a Collection using distinct?

  • MK-04030856-0 Profile Picture
    on 07 Mar 2024 at 06:38:21
    Re: sort with distinct

    Seems like they listened to you and actually changed the column's name to Value by now.

     

    2024-03-07_07h35_54.png

  • jeremiah-ang Profile Picture
    4 on 28 Nov 2023 at 08:45:01
    Re: sort with distinct

    For others that may stumble on this again, the column is now called `Value`. Hence the updated code would be 

    `Sort(Distinct(Source, Column), Value)`

    jeremiahang_0-1701161040619.png

     

  • jeremiah-ang Profile Picture
    4 on 28 Nov 2023 at 08:44:22
    Re: sort with distinct

    For others that may stumble on this again, the column is now called `Value`

    jeremiahang_0-1701161040619.png

     

  • Jewlz Profile Picture
    4 on 03 Nov 2023 at 23:48:10
    Re: sort with distinct

    In order to make this work, you have to replace the sort expression column name with  the work "Value":

     

    Sort(Distinct('List name','Column name'),Value,SortOrder.Ascending)

     

    for a list named Schedule, where I am sorting by Task would like:

     

    Sort(Distinct(Schedule,Task),Value,SortOrder.Ascending)

     

    Good luck!

     

  • kahyee Profile Picture
    2 on 22 Aug 2023 at 02:51:34
    Re: sort with distinct

    SortByColumns(Distinct('Source Database','Column'),"Value")

    the Word: "Value"

  • APWatsonDBA Profile Picture
    2 on 09 Jul 2023 at 23:26:08
    Re: sort with distinct

    Does this solution really uses ";" or are they supposed to be commas?

  • grodriguezb Profile Picture
    on 21 Jun 2023 at 04:15:40
    Re: sort with distinct

     Thanks for the link to the documentation. As of today, now that column is Value. I was reading other trends and Result doesn't work for me, but with your help I noticed it was changed.

  • skylitedave Profile Picture
    652 on 11 Jun 2022 at 00:52:59
    Re: sort with distinct

    6 years later and you still saved me!!!!

  • Digital Profile Picture
    1,207 on 16 Mar 2022 at 19:45:57
    Re: sort with distinct

    @mdevaney , I agree. Why do they use Result and not Value? I've often found myself using RenameColumns to make it consistent.

  • gatafish Profile Picture
    6 on 16 Mar 2022 at 19:35:44
    Re: sort with distinct

    Nice, hadn't tried the Result. Thank You

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard