Answered

Display Unique Values in Gallery

Like (0) Share

Report

Posted on 28 May 2023 08:48:27 by marctimothy

Hello!

I am trying to display the order numbers in the gallery title. I was able to do it using distinct in the Text property.

Distinct('Promotion - Order Table', OrderID)

However, I also want to access the dates associated with the OrderID and display it as well as the orderID subtitle. If i use distinct, I can only access the OrderIDs. If i use Groupby, i experience the same problem, I can only access the collection name and its values which are the orderIDs.

Please help.

Thank you!

Categories:

General Questions

table.PNG

Target.PNG

Original.PNG

All responses (3)

Answers (2)

marctimothy 39 on 28 May 2023 at 09:21:59

Like (0)

Report

Re: Display Unique Values in Gallery

Hi! Thank you to the both of you! The solutions worked! Been looking for these answers for hours!
Verified answer

WarrenBelz 148,894 Most Valuable Professional on 28 May 2023 at 09:16:14

Like (2)

Report
Re: Display Unique Values in Gallery

Hi @marctimothy ,

Try this

AddColumns( GroupBy( 'Promotion - Order Table', "OrderID", "Data" ), "OrderDate", First(Data).'Order Date' )

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
Verified answer

cha_cha 4,932 Moderator on 28 May 2023 at 09:14:00

Like (1)

Report
Re: Display Unique Values in Gallery

Hello @marctimothy

PowerApps can identify distinct records and you can use a combination of ForAll, Distinct and AddColumns function.

ForAll( Distinct( AddColumns('Promotion - Order Table', "IDDate", { OrderID: OrderID, DateColumnName: DateColumnName } ) , IDDate), ThisRecord.Value )