web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Gallery with du...
Power Apps
Answered

Filter Gallery with duplicate data from the column

(0) ShareShare
ReportReport
Posted on by

Hi ,

 

I would like  to list in Gallery 1 the Unique Order, VCode, DateOfOrder  from the below datasource

 

 

ORDERLINE NoItemvCodeOrder Date
49R251471TPMP83497-TPL       JB11/09/20
49R251472TPMP83501-TPL       JB11/09/20
49R251431TPMG16036-TPL       JB14/09/20
49R251432TPMG16068-TPL       JB14/09/20
49R251433TPMG16089-TPL       JB14/09/20
49R251434TPMG16109-TPL       JB14/09/20
49R251421TPMG16036-TPL       JB16/09/20
49R251422TPMG16109-TPL       JB16/09/20
49R251423TPMG16166-TPL       JB16/09/20
49R251424TPMG16635-TPL       JB16/09/20
49R251425TPMG16637-TPL       JB16/09/20
49R251411TPMG16036-TPL       JB21/09/20
49R251412TPMG16166-TPL       JB21/09/20
49R251413TPMG16635-TPL       JB21/09/20
49R251414TPMG16638-TPL       JB21/09/20
821748441IO-82174844-01      B125/09/20
821748431IO-82174843-01      B126/09/20
821746401IO-82174640-01      B127/09/20
821747071IO-82174707-01      B128/09/20
Categories:
  • rsaikrishna Profile Picture
    3,703 on at

    @VTandon 

     

    Use following formula:

    Distinct(<Data Source Name>,Order>

     

    More reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-distinct

     

    Distinct function will provide unique items.

     

    Regards

    Krishna Rachakonda

    If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.
  • Verified answer
    Vijay Tailor Profile Picture
    2,961 on at

    Hi @VTandon ,

    You can use the group by Like below.

    AddColumns(GroupBy(Sort(TestAkshay,Modified,Descending),"Title","StatusGrp"),"ID",StatusGrp.ID,"Modified",StatusGrp.Modified)

    VijayTailor_0-1602239330078.png

     

    Thanks,

    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay



  • VTandon Profile Picture
    on at

    i need VCode, DateOfOrder column too...

  • VTandon Profile Picture
    on at

    @rsaikrishna 

     

    i need VCode, DateOfOrder column too...

  • Verified answer
    rsaikrishna Profile Picture
    3,703 on at

    @VTandon 

     

    ShowColumns(Distinct(<Data Source Name>,Order>),"Order","VCode",DateOfOrder)

     

    Regards

    Krishna Rachakonda

    If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

     

  • VTandon Profile Picture
    on at

    @rsaikrishna 

    distinct return a result column. ONLY

    ShowColumns is not including the

     "VCode",DateOfOrder

  • VTandon Profile Picture
    on at

    @VijayTailor please elaborate ...

  • Vijay Tailor Profile Picture
    2,961 on at

    Hi @VTandon ,

    Try like below - 

    AddColumns(GroupBy(OrderGroupBy,"Title","GroupBUOrder"),"vCode",Distinct(GroupBUOrder,vCode).Result,"vCOde",GroupBUOrder.'Order Date')

    VijayTailor_0-1602245790550.png

    Thanks,

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 204 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 122

Last 30 days Overall leaderboard