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

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

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,972)