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

Invalid Argument Type when using Lookup

I am trying to  return a TagName using the LookUp function.  TagID in my collection (ProjTagCollection) and TagID in a database (Tags) are my comparisons.  TagID in both sources are INT variables.  

 

For what it's worth, I may have multiple items in my collection that would need to be looked up, but I would settle for just returning the first TagName to move along the troubleshooting path.

 

LookUp('[dbo].[Tags]', TagID  = ProjTagCollection.TagID). TagName  (squiggle line under the "=" sign)

 

P.S. Thanks in advance and many thanks to the people who answer questions for newbies.  

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ToddM1
Level: Powered On

Re: Invalid Argument Type when using Lookup

SOLVED!!!!

 

DefaultSelectedItems = Filter('[dbo].[Tags]',TagID in ProjTagCollection.TagID)

View solution in original post

1 REPLY 1
Highlighted
ToddM1
Level: Powered On

Re: Invalid Argument Type when using Lookup

SOLVED!!!!

 

DefaultSelectedItems = Filter('[dbo].[Tags]',TagID in ProjTagCollection.TagID)

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 (4,742)