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 / Add a column to the co...
Power Apps
Unanswered

Add a column to the collection for person field.

(0) ShareShare
ReportReport
Posted on by 148

Team,

I am trying to add a column to the collection for the person field. However, it shows the error as it's a table type, not a Record.

Please help me.

 

allyb123_0-1664290002177.png

 

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @allyb123 

    The error you are seeing is misleading.  What it is really saying is "your columns do not match your datasource!"

     

    Not sure what your colnoms1 is or why there is a collection for it, but consider the following formula instead.

     

    Patch('Voting List1', 
     ForAll(colnoms1,
     {Title: VotedbyLbl.Text,
     Nominee: nomLbl.Text
     }
     )
    )
     

     

    In your existing formula, you were trying to convert a label to a user record (incorrectly I might add) and then you were trying to get the display name from that in your colemail collection (again, not needed) - which essentially is just the nomLbl.Text!

     

    The above will create new records in your 'Voting List1' datasource - which is what you were trying to accomplish.

     

    I hope this is helpful for you.

  • allyb123 Profile Picture
    148 on at

    Hi @RandyHayes , Thanks for checking my query. I tried as you said but still getting the same error.

    Nominee in SP list is person field. is that the reason?

     

    allyb123_0-1664297558364.png

     

     

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @allyb123 

    What kind of column is Title (assuming Text) and Nominee in your list?

    Also, are there ANY other columns in your list that are marked as required?

     

  • allyb123 Profile Picture
    148 on at

    This is my list. None of the columns except Title is required. Nominee is Person field.  I am trying to fix first two columns instead of all.

    allyb123_0-1664298159812.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 342 Most Valuable Professional

#2
11manish Profile Picture

11manish 234

#3
Valantis Profile Picture

Valantis 187

Last 30 days Overall leaderboard