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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Migrate 50K SharePoint...
Power Apps - Microsoft Dataverse
Suggested Answer

Migrate 50K SharePoint files to dataverse

(0) ShareShare
ReportReport
Posted on by ctedesco3307 688
Hello - looking for input on the best approach to copy about 50,000 files from a SharePoint library to a Dataverse table File column.
 
I am aware of the integration options with Dataverse and SharePoint libraries - client is looking to move out of SharePoint. Load too big for Power Automate - what would be the best way to handle this? 
 
Thanks in advance 
Categories:
Entities
Tables
Microsoft Dataverse
I have the same question (0)
  • Power Platform 1919 Profile Picture
    Power Platform 1919 1,773 on at
    Migrate 50K SharePoint files to dataverse
    Just wanted to know few things like 
    What is average file size? Is it less than 100mb or more?
     
    What is the frequency of moving? Is it one time job or scheduled job?
     
    Is there any time constraints? Like need to move all the files within certain time or not?
     
     
    Sample article link to look:
  • ctedesco3307 Profile Picture
    ctedesco3307 688 on at
    Migrate 50K SharePoint files to dataverse
    @Power Apps 1919 it's over 50k files  - too much for power automate to process. Yes I already saw the post you referenced 
  • Suggested answer
    SebS Profile Picture
    SebS 4,569 Moderator on at
    Migrate 50K SharePoint files to dataverse

    I believe the simplest approach is bulk data transfer in batches. However, this requires access to premium connectors, and the HTTP connector must not be restricted. You’ll need to use the Invoke HTTP action. It’s more complex and requires some additional work, but I can direct you to a clear walkthrough video.

    This method is similar to the SharePoint Batch Create using the Batch API, but involves more code and configuration.

    Sean making great job in explaining this 
    https://www.youtube.com/watch?v=e2zuEBdas0g

     

  • Ram Prakash Profile Picture
    Ram Prakash 5,576 Super User 2025 Season 2 on at
    Migrate 50K SharePoint files to dataverse
     
    It is advisable to use DOCUMENT storage in SharePoint or Blob, if you are using in DV then the cost of Licensing will be more compared to other two
     
    Please mark as answer if my suggestion helps.
    Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans