Answered

Bulk/Mass upload/import data to a table in Dataverse from PowerApps Portal

(1) Share

Report

Posted on by skolarvs

Hi Team,

I have received a requirement from my customer today to Bulk/Mass upload/import data to a table in Dataverse from PowerApps Portal. Data is in excel spreadsheet and need to update/create records in a table in Dataverse with 5 columns. Does anyone implement similar requirement in your project? If yes, please provide some directions.

Thank you!

Categories:

Power Apps portals

I have the same question (0)

All responses (7)

Answers (1)

oliver.rodrigues 9,449 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Sandeep009 I've had that requirement before, my solution was:

Create custom "Data Import" table, that the user will attach the file

Sync plug-in on Dataverse for basic validations (making sure the excel was formatted correctly / etc)

Async plug-in that will perform the actual data import

If any errors happen, an e-mail would be sent to the user, and details of the error would be available in the "Data Import" list in the Portal

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Sandeep009

Please follow the instructions from @OliverRodrigues using the plugins. There are a few other ways, have a look at the below thread using Dataflows if you are interested.

https://powerusers.microsoft.com/t5/Power-Apps-Portals/Connect-to-Existing-Data-in-Power-Portals/m-p/1407440

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
skolarvs 67 on at

Like (0)

Report
Copy link

Link copied!

Thank you @ragavanrajan for your response. As I mentioned in my question, I was looking for Bulk import of data from Portal from the end user perspective so I can't use dataflow option in my scenario. Thank you!

Was this reply helpful? Yes No
Verified answer

skolarvs 67 on at

Like (0)

Report
Copy link

Link copied!

Thank you @OliverRodrigues for your response.

I have implemented the similar kind of solution but using Power Automate Flow and SharePoint.
1. Created a custom entity - let's say Data Import
2. Enabled SharePoint integration on that entity.
3. Expose the Data Import entity on portal.
3. From portal, user can create a new Data Import entity record and upload excel sheet via SharePoint document area
4. I have built a Power Automate flow to process the document from the document location and upload/import into Dataverse table.

Hope this will help for everyone!

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @Sandeep009

Dataflows allow you to import Bulk data import, you no need to create Power Automate for this. The purpose of dataflow is to create entity and import bulk data (unlimited), transform the data if required.

We have done many bulk imports so far. Everything was successful.

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
skolarvs 67 on at

Like (0)

Report
Copy link

Link copied!

@ragavanrajan I am aware of dataflow. But I am looking bulk data import solution for a portal users (end users) who have limited permission and wont have any access to dataflow area of the power platform.

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Got it @Sandeep009. You can create custom user roles for the environment and allow them to utilise the dataflow area. Having said that enabling SharePoint integration is also a great way of allowing end-users to upload data.

Thanks for sharing.

PS: I have marked your reply as an answer. So it will benefit others.

Was this reply helpful? Yes No