Collect-Lookup-Invalid argument type

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-yuxima-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Do you want to get the table which has the Address’s TCG# is match your second table?

I think you can change your formula expression as next:

Initial Collection: ClearCollect(CollIncompletesv6, Deactivation Incompletes)

Add Address Collection:ClearCollect(collUpdated6,AddColumns(CollIncompletesv6,”AddressLot”,LookUP(‘Master List’, TCG#= CollIncompletesv6.TCG#,Address)))

I test as this:

Button.Onselect: ClearCollect(test2,'[dbo].[Table_20190222DI]');ClearCollect(test3,AddColumns(test2,"Addresslot",LookUp('[dbo].[Table_20190222MasterTable]','TCG#' in test2.'TCG#',Address))) (on your side you can change to your tale’s and column’s name)

Result:

Hope this can be helpful.

Best Regards.

Yumia

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Yumia
I think this is close but I am getting the same results as you... but... the addresses end up being the same for all of the records in the updated collection
I was needing the final collection to look like
123 101 no where street
789 103 hereweare dr

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
Try the following (going back to your original collect statement rather than creating another one).

ClearCollect(collUpdated6, AddColumns(CollIncompletesv6, "AddressLot", LookUp('Master List', 'TCG#'=CollIncompletesv6[@'TCG#']).Address))

This should give you the original collection you wanted - the difference here is the use of a disambiguation operator that will observe your Record Scope properly.

See if that helps.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

YES!!!!!!!!!!!! THANK YOU!!!! It works

Yumia and Randy - I appreciate what you have taught me..... I am off running again.

Was this reply helpful? Yes No