Bulk Upload Excel data to Dataverse

(0) Share

Report

Posted on by KishoreJ

Hi,

I'm looking for a solution approach / best design for the below requirement.

Using Model driven app , need to upload bulk excel data's and store it in data verse.

e.g 100 excel files with size ranging between 10 to15 mb per day.

I think for extracting the data from excel first we need to convert the excel format to table(probably we can achieve with office script recording in Excel online) . Please guide for any better approach

Appreciate if you could guide me some best options for designing this architecture.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @KishoreJ,

DataVerse will Support Excel import with 32 MB

For importing you need to first Generate an Excel For that

1. Navigate to https://make.powerapps.com
2. Click On Gear Icon at the Top
3. Select Advance Settings
4. Once the Advance Settings Opened
5. Click Filter Symbol at the Top

Select the Entity in Look For and Click Edit Columns

Once Edit Column opens click Add Column then add the Columns --> then Field added click Ok and Click Result and Download the Excel

Clear the Data and Map with New Data based on your excel. Once done Save the File as CSV format.

then Import the File thats it 🙂

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
KishoreJ 13 on at

Like (0)

Report

Hi @rampprakash

Steps which you have mentioned is kind of one time process especially for dataflows into data verse from excel.
But here the requirement is end user will upload the excel in their own standard format in the Model driven app screen, behind the scene it should extract the data from the excel and load it into the data verse.
Thanks

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @KishoreJ,

As per OOB Behavior there is no Standard way to achieve the same. While importing we can make Data Map for the same. My Suggestion provide the standard format to the User so that we can upload easily.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
KishoreJ 13 on at

Like (0)

Report

Hi @rampprakash

Thanks for the direction, Appreciate your suggestion.

One more solution we can think for this scenario i.e. Using PowerAutomate convert the excel(user format) to csv , then import the csv to dataverse with ease.

Any suggestions please feel free..
Thanks

Was this reply helpful? Yes No
Verified answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

Hello @KishoreJ,

Yes we can use but there also we need some standard excel so that we can create flow accordingly and we need to keep Excel in Onedrive or SharePoint too.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No