Answered

Collection with LookUp with condition comparing nested Record

(0) Share

Report

Posted on by simondpalmer

131

Hi I have an existing Table called "ListItems" which I want to add a "Color" column with RGB info depending if a nested record value ""Phase.Value" matches the "Value" of another table - return column "PhaseColor" (in this case "IndexedPhases").

I have tried the following but it does not recognize "Phase.Value" as valid. Does it not reference the "Collect" source (ListItems) for this value similar to how ForAll function works?

Collect(ListItems, {Color : LookUp(IndexedPhases,Phase.Value=Value, PhaseColor)});

ListItems table below with Phase column.

ListItems.Phase record below

IndexedPhases Table to compare with below

Any help would be appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @simondpalmer ,

Firstly, the names Value and Color are not good titles for fields as they are Reserved Words in PowerApps and this could cause further ambiguity issues, however as the Items of a gallery the below should be the structure you need to add the column

AddColumns( ListItems "Color", LookUp( IndexedPhases, Value=Phase.Value ).PhaseColor )

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.

Was this reply helpful? Yes No
simondpalmer 131 on at

Like (0)

Report

Thank you @WarrenBelz for the answer and advice but how would I add the column to the existing table (ListItems) instead of adding a column to a Gallery Items? I tried to "Collect" it first but it seems it doesn't recognize the Phase.Value. Do I need to specify the "First" value of Phase.Value as it iterates over the ListItems? There is always only one value in Phase.Value FYI

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
@simondpalmer ,

I used Phase.Value from the screenshot you supplied. You cannot add columns to a SharePoint table in Power Apps, but a Collection would look something like this

Clear(MyCol); ForAll, ListItems, Collect( MyCol, AddColumns( ListItems "Color", LookUp( IndexedPhases, Value=Phase.Value ).PhaseColor ) ) )

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.

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @simondpalmer ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No
simondpalmer 131 on at

Like (0)

Report

Thank you @WarrenBelz that worked

Was this reply helpful? Yes No