web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Incompatible type of c...

Power Apps

Answered

Incompatible type of comparison: Table, Text

(0) Share

Report

Report

Posted on by Muhammad07

33

Hi Everyone,

I am trying a simple formula but getting this error:

Incompatible type of comparison: Table, Text

If(User_MuhammadTesting.Role = "Manager", Location_Test)

I also tried this:

If(Text(User_MuhammadTesting.Role) = "Manager", Location_Test)

&

If(User_MuhammadTesting.Role.Value = "Manager", Location_Test)

Kindly let me know where i am making the mistake. And what will be the correct formula.

My share point list is: User_MuhammadTesting and column name is: Role

Categories:

Building Power Apps

All responses Img

All responses (6)

Answers Img

Answers (1)

Sort by

Sunil-Narnaware 681 on at

Like
a
(0)

Report
Copy link

Link copied!

@Muhammad07 what is column type for 'Role'?
Muhammad07 33 on at

Like
a
(0)

Report
Copy link

Link copied!

@Sunil-Narnaware its "Single line of Text" type
Verified answer

Sunil-Narnaware 681 on at

Like
a
(1)

Report
Copy link

Link copied!
@Muhammad07

You are looking a record whose role is manager.. and if you get the record you want to use Location_Test..

In order to find the record you have to do searching by following way..

If( IsEmpty( LookUp( User_MuhammadTesting, Role = "Manager" ) ), Location_Test )

===============

If this helps in solving your problem, 'Accept is as Solution'. If you like, hit 👍
Muhammad07 33 on at

Like
a
(0)

Report
Copy link

Link copied!

@Sunil-Narnaware I have one more question, what if i want to check role with current user email:
My List(User_MuhammadTesting) has following columns : Email, Role, location
I want to verify current user email with email into User_MuhammadTesting.Email and then role with "manager".
Sunil-Narnaware 681 on at

Like
a
(1)

Report
Copy link

Link copied!

just add && Email = User().Email against role comparison in above code.. so it will compare both email & role
Muhammad07 33 on at

Like
a
(0)

Report
Copy link

Link copied!

@Sunil-Narnaware Thank you for your help. But the problem rn is I want to showup Location_Test in my combo box but in this formula its getting the USERTesting list data. Should not it be Location data?

Join the conversation