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 / dataverse tables after...
Power Apps
Answered

dataverse tables after user leaves the business

(0) ShareShare
ReportReport
Posted on by 1,257 Super User 2024 Season 1

We have a number of dataverse tables that were created by a user who is now leaving the organisation and their account will be deleted.  Will this affect the dataverse tables? and the powerapps that depend on them? and if so what can we do in advance to sort this.     I don't believe there is a way to change the owner of a table?

 

TIA

I have the same question (0)
  • Verified answer
    ypatil2 Profile Picture
    on at

    @vffdd 

    Regarding your question, if the individual has left the organization, all tables and apps will persist. However, if any apps or Power Automate flows are dependent on that user's connections, they will cease to function. To address such scenarios, it's advisable to employ a role account. By sharing your all the solutions with this role account, you can ensure continued management of all solutions without disruption. This approach enables seamless management and maintenance, even in the event of personnel changes. Even if you are a tenent admin you can change the ownership of any app/power automate flow.

     

  • vffdd Profile Picture
    1,257 Super User 2024 Season 1 on at

    Thank you for your response. We do have a type of "role" account and the apps that use the dataverse source were created with this as the owner and any power automate connections also use this. Unfortunately the tables were originally created before this account so therefore they were created by an individual user.  So we were just concerned in case there would be an issue with the tables once the user is gone.  But from your response it seems it won't be an issue? Is that correct

  • Fubar Profile Picture
    8,487 Super User 2026 Season 1 on at

    Tables themselves shouldn't be an issue.

    As already mentioned, Flows and Flow Connections you will need to set the Owner/recreate. Similar with the Canvas App ownership.

    Also watch out for if they are the owner of classic Workflows, or if you have Workflows with wait's in them with currently active sessions where that user is the owner of the session as these can stop functioning when the user is no longer licensed.

    For records in the tables where the user owns records including workflow sessions, on the user record in Dataverse you can use the Reassign Records button to change to another user (do this before deactivating the user).

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 762

#2
11manish Profile Picture

11manish 640

#3
Valantis Profile Picture

Valantis 548

Last 30 days Overall leaderboard