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 / Migrate data from acce...
Power Apps
Answered

Migrate data from access to Dataverse GCC

(1) ShareShare
ReportReport
Posted on by 388

Hi,

 

We have access database application and and each record has documents and documents are stored in shared drive and we added just links in access database application.

 

Now we are migrating application from access to dataverse so I would like to know the best way to migrate the access data to dataverse.

 

And I found the following references for migration but I would like to know how to migrate attachments from shared drive to dataverse and how to link the documents to records.

 

Any suggestions would be greatly appreciated.

 

Thank you.

 

Get started: Migrate Access data to Dataverse - Microsoft Support 

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

    Hi @aaedla 

    The article is walking through how to move the data from the Access Database to Dataverse with the ability to continue to leverage he Access Forms on top of Dataverse along with Dataverse forms, views, etc. and creating a model-driven application.

     

    Overall this is a pretty good guide to accomplish moving the data to Dataverse.  Most of the time for me though, I usually am re-architecting the tables during migration and changing some fields to Choice fields where it makes sense, and other application structure changes that are better supported in Dataverse.  Normally I export the data to Excel and utilize that to help me build the data that I import into Dataverse.  This is just what works for me and I have had to do this in a number of projects.  Most flexibility and easy to accomplish...

     

    Now, the documents...  If you are moving to Power Apps you will want to look at moving the files from the nextwork share to SharePoint and utilize the standard integration with SharePoint out of Dataverse.  https://learn.microsoft.com/en-us/power-platform/admin/set-up-sharepoint-integration 


    Int this model you will be able to create the relationship with the table / entity in Dataverse and a specific Document library.  Once you do this you will be able to see documents related to your record in the model-driven power app.  

     

    Note, it will take time and effort to basically upload the file for each record in your tables from your repository into the application but will also provide the benefits of having multiple documents related to the same record.

  • OK29 Profile Picture
    388 on at

    @dpoggemann  Thank you for your comments but I didn't get the option to move documents to sharepoint.

     

    If I move the documents to SharePoint, how should I create the relationship between access data and the documents in SharePoint?

     

    Can you please elaborate?

  • Verified answer
    Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @aaedla ,

    Please see the following details on SharePoint integration within Dataverse:  Benefits of document management with SharePoint integration - Power Platform | Microsoft Learn

    Use SharePoint and Dynamics 365 apps to manage your documents - Power Platform | Microsoft Learn

     

    This is an out-of-the-box integration where you can identify the tables that are enabled for "Documents" and then you are able to add documents to the record by clicking on the "Documents" tab within the record in the model-driven application.

  • OK29 Profile Picture
    388 on at

    @dpoggemann  Thank you for sharing this information.

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
11manish Profile Picture

11manish 505

#2
WarrenBelz Profile Picture

WarrenBelz 502 Most Valuable Professional

#3
Haque Profile Picture

Haque 324

Last 30 days Overall leaderboard