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

Notifications

Announcements

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,414 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard