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 / I can't update my data...
Power Apps
Answered

I can't update my dataverse table with primary/key column

(1) ShareShare
ReportReport
Posted on by 12

Hello! Thanks for taking time to look at my question!

I built a dataflow that populates data from an excel sheet to a dataverse table. I set all columns to text and select which column I want to use as a key. The dataverse table is populated correctly.

I then change the dataflow's load setting from "Load to a new table" to "Load to existing table", select the same table, but the "select key" doesn't display my primary key column. I check the table and that column is a text field and is set as primary.

I don't know if this is helpful but this is being built in a dev/sand box environment.

Categories:
I have the same question (0)
  • Verified answer
    Michael E. Gernaey Profile Picture
    53,963 Moderator on at
    Hi
     
    A dataverse tables primary Key is a GUID.  So you are trying to populate an existing table that whose key is defined as the default value of GUID, not a Text value (well its text, but you aren't giving it a guid) 
    So it fails as expected for what you have above.
     
    If you look at your Table and you look at the columns you will have a Unique id that is a GUID, not the column you chose.
     
    I cannot see anything as you just provided words.
     
    But thats why it is failing.

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 392

#2
WarrenBelz Profile Picture

WarrenBelz 364 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 271 Super User 2026 Season 1

Last 30 days Overall leaderboard