Invalid Argument type for = sign in a lookup

(0) Share

Report

Posted on by OsmandFernando

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

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like (3)

Report

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

Was this reply helpful? Yes No
OsmandFernando on at

Like (0)

Report

amazing brother,

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

I am so grateful to you

Osmand

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report
@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."

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@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."

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
OsmandFernando on at

Like (0)

Report

@mdevaney thank you for your reply

really appreciated it

Osmand

Was this reply helpful? Yes No
Mattishven 2 on at

Like (0)

Report

Hi,
Could you help me Please.
I need to get "Result Exists " when Managerstatus is "pending" and company column is specific value(like Wipro already there in the dropdown). Here company is lookup column it gets value from 'MasterList' and managerstatus is not lookup column and it is just dropdown column. Form is in 'PWList'. "Result Exists " should appear when both condition are statisfied.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Mattishven

This thread is closed. Suggest you start a new thread of your own.

Was this reply helpful? Yes No