cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iskhj000
Level: Powered On

Collect-Lookup-Invalid argument type

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
iskhj000
Level: Powered On

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

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

iskhj000
Level: Powered On

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

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.
iskhj000
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (7,063)