Answered

Display Unique Values in Gallery

(0) Share

Report

Posted on 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:

Building Power Apps

table.PNG

Target.PNG

Original.PNG

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

cha_cha 4,932 Moderator on at

Like (1)

Report
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 )

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,051 Most Valuable Professional on at

Like (2)

Report
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

Was this reply helpful? Yes No
marctimothy 39 on at

Like (0)

Report

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

Was this reply helpful? Yes No