Answered

Distinct values of a collection + column

(0) Share

Report

Posted on by rodh3ro

Hey,

I want to create a collection "Referencias" using DISTINCT values of column ID from a SP List "Pending" (examples at the end).

The thing here is, I also want to add the "Cab_City" column to the collection, but showing only one record (always the same value for each GUID).

I've tried something like this but is not working properly.. any ideas??

ClearCollect(Referencias;
 RenameColumns(Distinct(Pending;SP_GUID);"Value";"Col_GUID")
);;
AddColumns(Referencias;"City";LookUp(Pending;SP_GUID=Referencias[@Col_GUID]).Cab_City);;

Thanks!

(Col) Desired Referencias:

GUID	City
1	London
2	Madrid
3	Paris

(SP) Pending:

GUID	City
1	London
2	Madrid
2	Madrid
3	Paris

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @rodh3ro,

The code below will only fetch the distinct IDs, add city as a column and rename the Value field to GUID:

RenameColumns( AddColumns( Distinct( Pending; SP_GUID ) As Main; "City"; LookUp( Pending; SP_GUID = Main.Value ).Cab_City ); "Value"; "GUID" )

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No
rodh3ro 4 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks, works like a charm! (just make sure to create the collection first with collect)

Was this reply helpful? Yes No