web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Incompatible type erro...
Power Apps
Answered

Incompatible type error: Text, Table

(0) ShareShare
ReportReport
Posted on by 12

I am relatively new to powerapps and would love a bit of help please! 

 

I am building an app for gathering survey inputs and using a SP List as my data source. On the landing page I have a gallery which allows users to view and edit any survey inputs. However, I would only like the creator of the input or a 'nominee' (used from a people column in my SP List) to be able to edit the input, everybody else should be able to view it though. 

 

Problem:

I have a variable varNominee that takes the DisplayName from an Office365User data source that is set on the app start up (and varLoggedInUser takes the display name of the logged in user. If the display name is the same name as the Created By name then the edit button works fine). 

The nominee control, in the form, is a combobox that uses a people or group type column from my SP List. 

When I try to set the DisplayMode of my Form Edit control (pen icon), I keep getting an error code "Incompatible types for comparison. Incompatible type error: Table, Text" - I presume this is because the person or group column in SP List is a record property type instead of a text. 

 

Does anyone know of any sort of work around or how I can ensure that the nominee can edit the entry? 

 

KGee1_2-1675168828519.png

 

 

Categories:
I have the same question (0)
  • Akser Profile Picture
    1,546 Moderator on at

    Hi @KGee1,

     

    The Nominee person field in SharePoint, does it allow a single value? If yes, can you try the following?

    ThisItem.Nominee.DisplayName = varNominee
  • KGee1 Profile Picture
    12 on at

    Hi Akser

     

    The Nominee control is a combobox, as the creator will need to select multiple people who can edit an entry. I tried this and just come up with the same error "These types can't be compared..."

  • Verified answer
    Akser Profile Picture
    1,546 Moderator on at

    Hi @KGee1,

     

    I have a variable varNominee that takes the DisplayName from an Office365User data source that is set on the app start up

    So varNominee is set once (OnStart). And based on that variable, you would like to filter your gallery, correct? Since you mentioned that the Person field in your datasource accepts multiple values (names) then the following formula should do the trick:

    varNominee exactin ThisItem.Nominee.DisplayName

     

    Not sure why you mentioned the combobox? 

  • KGee1 Profile Picture
    12 on at

    Amazing! It worked, thanks! 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 335 Most Valuable Professional

#2
11manish Profile Picture

11manish 165

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 96 Super User 2026 Season 1

Last 30 days Overall leaderboard