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)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@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

Awesome Randy,

Thank very much!

Was this reply helpful? Yes No