web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps Powerapps Lookup - inc...

Power Apps - Building Power Apps

Answered

Powerapps Lookup - incompatible types for comparison

(0) Share

Report

Report

Posted on by janineb

Good day

I have a static Excel datatable in my app and needs to look up the SBU/Department and Division fields.

This is an example of my datatable. The SBU/Department field refers to the LTEXT field. The text field of my SBU/Department has the following formula: LookUp(HCMaster_1,EMAIL=Gallery2.Selected.Mail,LTEXT). I do not get a error message, but the field does not look up and return the info from the datatable. (Gallery 2 refers to the email lookup of the Nominee from Active Directory)

Can you please help me why I cannot get results - it seems it is a "incompatible types for comparison" error

Thank you

Categories:

General Questions

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

LaurensM 12,512 Moderator on at

Like (1)

Report
Re: Powerapps Lookup - incompatible types for comparison

Hi @janineb,

When using the equals operator both emails will have to match exactly. Pay close attention to capitalization or wrongly spelled emails within the static Excel list. Using the in operator instead of equals will make the query case insensitive:

LookUp( HCMaster_1, Gallery2.Selected.Mail in EMAIL, LTEXT )

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

Join the conversation