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

Collect-Lookup-Invalid argument type

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

Re: Collect-Lookup-Invalid argument type

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
Highlighted
Community Support
Community Support

Re: Collect-Lookup-Invalid argument type

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

Highlighted
Helper I
Helper I

Re: Collect-Lookup-Invalid argument type

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

Highlighted
Super User
Super User

Re: Collect-Lookup-Invalid argument type

@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.
Highlighted
Helper I
Helper I

Re: Collect-Lookup-Invalid argument type

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
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,538)