cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Collect-Lookup-Invalid argument type

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

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

View solution in original post

4 REPLIES 4
Community Support
Community Support

Hi @iskhj000 ,

 

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)

20190222invalidargumenttype1.jpg

Result:

20190222invalidargument2.jpg

20190222invalidargument3.jpg

 

Hope this can be helpful.

Best Regards.

Yumia

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

@iskhj000 

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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

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

 

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

View solution in original post

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (234)