Answered

LookUp in set

(0) Share

Report

Posted on by Khaled2

Hello , i am working on an app. When the user logs in I want to register an ID as a local variable. Here is my function :

Set(varID ; LookUp(Employee;Username = nameInput.Text && Password = passInput.Text).ID)

However it always returns an error saying that types are not compatible.

Are there any solutions ?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

michelle4 98 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Khaled,

What column types are your Username and Password, text, number?

Was this reply helpful? Yes No
Khaled2 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, both of them are text

Was this reply helpful? Yes No
michelle4 98 on at

Like
a
(0)

Report
Copy link

Link copied!

the code looks good to me. Can you try with a new variable name?

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Khaled2

Maybe you can try this:
Set( varID ; Text(LookUp(Employee;Username = nameInput.Text && Password = passInput.Text; ID)) )

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Khaled2 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Actually this is my whole code is there an error ? (Everything works fine when i remove the Set)

LookUp(Employee;
Username = nameInput.Text && Password = passInput.Text;
Set(varID ; LookUp(Employee;Username = nameInput.Text && Password = passInput.Text).ID) ;;
Navigate('home screen');;
ResetForm(Form2);;
)

Was this reply helpful? Yes No
Verified answer

Khaled2 17 on at

Like
a
(1)

Report
Copy link

Link copied!

Actually i put the set out of the lookup and everything works now thanks guys!!

Was this reply helpful? Yes No