AddColumns function display error

(0) Share

Report

Posted on by JB0007

308

Hi PowerApps community,

I am trying to add a lookup column in my galley list. However, I have tried insert the code in my gallery and in a button but I keep getting the same error:

First attempt:

AddColumns(Filter(
 colOrders,
 IsBlank(cbVendors.Selected.ID) || IsEmpty(cbVendors.SelectedItems) || Supplier_ID = cbVendors.Selected.ID,
 IsBlank(txtOrderQuote) || Quote_Num = txtOrderQuote.Text
),"Client_ID",LookUp(colParentOrders,Merge_ID=Merge_ID,Client_ID))

Second attempt:

Filter(
 AddColumns(colOrders,"Client_ID",LookUp(colParentOrders,Merge_ID=Merge_ID,Client_ID)),
 IsBlank(cbVendors.Selected.ID) || IsEmpty(cbVendors.SelectedItems) || Supplier_ID = cbVendors.Selected.ID)

Merge_ID is in the colOrders and the colParentOrders.

Any help will be much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@JB0007

Please consider changing your Formula to the following:

Filter( AddColumns(colOrders As _item, "Client_ID", LookUp(colParentOrders, Merge_ID = _item.Merge_ID, Client_ID) ), IsBlank(cbVendors.Selected.ID) || Supplier_ID = cbVendors.Selected.ID )

The IsEmpty in your formula is not relevant.

Your LookUp needs to have which Merge_ID you want to match. In the above, the colOrder is given a reference name of _item and used in the lookup formula.

I hope this is helpful for you.

Was this reply helpful? Yes No
JB0007 308 on at

Like (1)

Report
Copy link

Link copied!

Awesome Randy,

Thank very much!

Was this reply helpful? Yes No