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 / error-The property on ...
Power Apps
Unanswered

error-The property on this control expects Record values. The rule produces Table values which are incompatible.

(0) ShareShare
ReportReport
Posted on by

hello I'm getting this error "The property on this control expects Record values. The rule produces Table values which are incompatible." I have a data card called "Project Lead_DataCard1" that is having this issue under the Default property. 

 

the drop down field inside it updates a person or group sharepoint list column based on a power automate flow for some background. the issue seems to be that it is a table data source. 

let me know if i can provide more info.  here is a screen shot of the field selected error on far right.

 

Screen Shot 2020-08-28 at 4.32.03 PM.png

 

Categories:
I have the same question (0)
  • RezaDorrani Profile Picture
    12,145 on at

    Hi @somebodycool 

     

    If the column in SharePoint is of type person or group and if you have customized the data card to add your own custom controls then you need to ensure that the person column has the following record format

    {
    Claims: Concatenate(
    "i:0#.f|membership|",
    User().Email // Person email
    ),
    Department: "",
    DisplayName: "",
    Email: User().Email, // Person email
    JobTitle: "",
    Picture: ""
    }

    https://youtu.be/g9ChYuTdNd4

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

  • somebodycool Profile Picture
    on at

    hello Reza, thank you for your input on this issue. i did also watch your video which had some good examples. For this power app I created it using my sharepoint list. which generated a power app for me

    to work from. this is what the form looks like in sharepoint.

    Screen Shot 2020-09-01 at 12.09.49 PM.png

    That being said should i paste your supplied formula into the two properties Default & Update that are causing the record error? the Expected Record Value error is occurring in both the Default property and Update property for the "Project Lead_DataCard1" control. see screen shot for both properties for what i have in the function field now. this is pretty frustrating as i did a test version and didn't have the Record value error issue but maybe something is now deprecated.

    Screen Shot 2020-08-31 at 4.06.35 PM.png

    Screen Shot 2020-08-31 at 4.08.37 PM.png

     

     

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 366 Most Valuable Professional

#2
11manish Profile Picture

11manish 184

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 99 Super User 2026 Season 1

Last 30 days Overall leaderboard