Power Apps Add Lookup column to the collection

(0) Share

Report

Posted on by HM-22080408-0

Hi Members,

I had a requirement in Power Apps to create a Lookup column for the Power Apps collection.

For example, I have created two different collections:

col_ProductDetails
col_ProductCategory

Now, I need to add a lookup column as "Category" to the collection 1(col_ProductDetails) from the collection 2(col_ProductCategory).

So, I have tried the code below, but I am facing an error as shown below:

ClearCollect(
 colFinal,
 AddColumns(
 col_ProductDetails,
 "Category",
 LookUp(
 col_ProductCategory,
 'Product ID' = col_ProductDetails[@'Product ID'],
 Category
 )
 )
)

Can anyone please suggest how I can achieve this? Thanks in advance!

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

VishalJhaveri 1,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
'Column Name': { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: dropdown.Selected.ID, Value: dropdown.Selected.Name }
Refer this master blog to achieve all the main functionalities in Power Apps. :Master CRUD Operations in Power Apps : Part 4 (inkeysolutions.com)
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Hemashree ,

There are some updates about AddColumns syntax, please try to remove double quotation marks around the column name.

Best regards,

Rimmon