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:

Using Apps Using Formulas

AI Builder

Employee Ideas app on Teams

I have the same question (0)

All responses (2)

Answers (0)

VishalJhaveri 1,167 Moderator on at

Like (0)

Report
Re: Power Apps Add Lookup column to the collection

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

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

Re: Power Apps Add Lookup column to the collection

Hi @Hemashree ,

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

Best regards,

Rimmon

Was this reply helpful? Yes No