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 / Two tables were to hav...
Power Apps
Unanswered

Two tables were to have all their records deleted, now they won't relate with new values.

(0) ShareShare
ReportReport
Posted on by 146

I have two data verse tables that had a 1 to many relationship.

I cleared both tables, deleted all records.

I am rebuilding the tables from scratch with the same data.

I can populate the first table and it counts from scratch no problems, however when I go to populate the second table using the lookup to the first table it doesn't let me make any entries.

Power apps will say 'An entry is required or has an invalid value. Please correct and try again.'

A manual entry in dataverse will just say 'There was an error saving this record' no explanation, nothing has changed other than clearing all records.

I've heard about stuff that goes on behind the scenes with dataverse that you can't get to.

I have tried deleting the lookup column from the second table that refers to the first and then redoing it, no fix.


Do I really have to delete both tables and start again?

If I use the same table and column names, is that also going to assume some lingering preset that hasn't gone away, because then I'd have to re go over everything inside the app aswell.

Quite frustrating at the moment.


I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @silaman ,

     

    Deleting the data in the tables should not affect how the tables function / relate data.  Not sure what is going on here... We could probably walk through the setup / configuration in a Teams call and I can see if I can determine what is happening.  If this works, private message me with your email and we can set something up to walk through.

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard