Answered

Taking the value from SP list and comparing it with the Associate Number in Powerapps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Afternoon! Guys. So, I am trying to show up a check in and out popup by Scanning a badge number in the text box named Associate_Number and then comparing that number with the Associate Column which is a lookup type, for another column in another list (column in that list is Badge Number -> Type is Number). But i am getting an error. Can somebody please describe what the problem could be?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous , What is the error message? Can you share the exact error message?

Thanks,
ANB

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The Non-Compatible types.

Was this reply helpful? Yes No
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous , If Associate is of number type in SP list then try to use below code.
Set(varAssociate, If( LookUp( Appointments, Associate = Value(Associate_Number.Text) ).Associate = Value(Associate_Number.Text), true, false );

If Associate is single line text then use below code:
Set(varAssociate, If( LookUp( Appointments, Associate = Associate_Number.Text ).Associate = Associate_Number.Text, true, false );

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Same error. Incompatible type. So, the Associate column is of type (Lookup)

Was this reply helpful? Yes No
Verified answer

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Can you try this:
Set(varAssociate, LookUp( Appointments, Associate.Value = Associate_Number.Text, true ) );
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No