Answered

Incompatible Type Error

(0) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

I am having issue with the following code.

The Collection (List) ManagerEmailAddress column is a single line text.

The Main_Screen_User_Email_Fld.Text context is Office365UserProfile(User().Email).Mail

If(RequestCollection.ManagerEmailAddress=Main_Screen_User_Email_Fld.Text,...

The equal in the above formula is kicking back and error - 'Incompatible types for comparison.
These types can't be compared: Table, Text'.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

SpongYe 5,614 Super User 2025 Season 2 on at

Like (0)

Report
@Phineas

Try this:
If(RequestCollection.ManagerEmailAddress.Value=Main_Screen_User_Email_Fld.Text

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Hi @Phineas,

Should you want to check whether the email appears in the email column of that collection, you will need the in operator. 'Equals' will expect a single text value.

If( Main_Screen_User_Email_Fld.Text in RequestCollection.ManagerEmailAddress, ...

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