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

Invalid Argument type for = sign in a lookup

Dear Experts, 

 

@PowerAddict 

 

I have done a lookup for a label as below, 

 

LookUp('Item Master','Model Number' = ComboBox2_3.SelectedItems.Value,'Brand Name')

 

But it says for the = as invalid argument type, I would like to understand why is that? I can use "in" but it is having the delegation issue

 

How can I overcome this ?

 

Osmand

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
PowerAddict
Level 10

Re: Invalid Argument type for = sign in a lookup

How many values are you selecting from the combo box? If only one, try this:

LookUp('Item Master','Model Number' = ComboBox2_3.Selected.Value,'Brand Name')

Let me know if this works.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://www.thepoweraddict.com

View solution in original post

7 REPLIES 7
Highlighted
PowerAddict
Level 10

Re: Invalid Argument type for = sign in a lookup

How many values are you selecting from the combo box? If only one, try this:

LookUp('Item Master','Model Number' = ComboBox2_3.Selected.Value,'Brand Name')

Let me know if this works.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://www.thepoweraddict.com

View solution in original post

Re: Invalid Argument type for = sign in a lookup

amazing brother, 

 

@PowerAddict it worked. I understand difference between Selected and Selected Items now

 

I am so grateful to you

 

Osmand 

Super User
Super User

Re: Invalid Argument type for = sign in a lookup

@OsmandFernando 

Does your current formula return any values?  I am unclear about this because 'Model Number' could be either column type: text, number or LookUp.  Which one is it?

 

If your model number field is a LookUp type then I would suggest trying this code.

LookUp('Item Master','Model Number' in ComboBox2_3.SelectedItems,'Brand Name')

 

My proposed solution assumes the Items property of ComboBox2_3 is this code

'Item Master'

 

The equals operator cannot be used here because SelectedItems contains one or more records.  The equals sign can only match a single value.  Therefore we use the IN operator instead. 

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Super User
Super User

Re: Invalid Argument type for = sign in a lookup

@PowerAddict 

You beat me to it.  As a reward you can be the first to receive some Super Kudos from me! 😛

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

PowerAddict
Level 10

Re: Invalid Argument type for = sign in a lookup

Glad I could help! Good luck with the rest of the app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
https://thepoweraddict.com
PowerAddict
Level 10

Re: Invalid Argument type for = sign in a lookup

Hey @mdevaney, glad to see you are a Super User now!

Re: Invalid Argument type for = sign in a lookup

@mdevaney  thank you for your reply

 

really appreciated it 

 

Osmand

Helpful resources

Announcements
thirdimage

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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (4,178)