Announcements
Hi ,
I would like to list in Gallery 1 the Unique Order, VCode, DateOfOrder from the below datasource
@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
Hi @VTandon ,You can use the group by Like below.
AddColumns(GroupBy(Sort(TestAkshay,Modified,Descending),"Title","StatusGrp"),"ID",StatusGrp.ID,"Modified",StatusGrp.Modified)
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
i need VCode, DateOfOrder column too...
@rsaikrishna
ShowColumns(Distinct(<Data Source Name>,Order>),"Order","VCode",DateOfOrder)
distinct return a result column. ONLY
ShowColumns is not including the
"VCode",DateOfOrder
@VijayTailor please elaborate ...
Hi @VTandon ,Try like below - AddColumns(GroupBy(OrderGroupBy,"Title","GroupBUOrder"),"vCode",Distinct(GroupBUOrder,vCode).Result,"vCOde",GroupBUOrder.'Order Date')
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 243 Super User 2026 Season 2
WarrenBelz 204 Most Valuable Professional
Mohsin Ali 122