Announcements
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
@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.
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
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 762
11manish 640
Valantis 548