Unanswered

Import excel or csv data to dataverse table from power pages

(1) Share

Report

Posted on by Viktor Kralevski

Hi,

I am trying to import excel data to dataverse table from power pages portal. Currently, there is an option for the logged in users to submit offers one by one, and in some cases it is very time consuming. The idea is to have the users pre-prepare his offers in an excel file, and to give an option to them to import it instead of typing it manually.

Is this even an option in power pages? Any idea or link to a documentation would be very helpful :)

Thanks,

Viktor

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Fubar 8,338 Super User 2025 Season 2 on at

Like (1)

Report

There is not an existing function to do this, but it can be done. However, there are also some things to consider such as validation of the data in the file (and what to do if it fails any validations), what to do if the file being uploaded contains a virus/malware., and what file size and types you will accept,

The general process would be to create a Form that either has a File field on it or that is enabled for attachments (in which case the file will end up in the Notes table). Then run a process when the form is submitted to retrieve the file and process it - you may be able to use Flow for this.

Was this reply helpful? Yes No
Viktor Kralevski 12 on at

Like (0)

Report

Thanks Fubar, meanwhile I've managed to this, and indeed the file ends up in the Notes table.

But, I am wandering what is happening with the file because it looks to me that the file is saved in Notes in other type of file - I am importing Excel file, but not able to do anything with it later.

For example, I have saved it on one drive, but any of the one drive power automate components do not work with it while the list file option finds the file (it exist on the location with expected name)

Thanks,

Viktor

Was this reply helpful? Yes No
Suggested answer

Fubar 8,338 Super User 2025 Season 2 on at

Like (1)

Report

If you can see the File, but when you try to open if in Flow or something else and the contents are not correct other than when in a Model Driven App interface (e.g. if you can click on it in a Model Driven app and it is ok, but not in Flow etc), you need to encode/decode it as the file probably Base64 encoded

https://community.dynamics.com/blogs/post/?postid=7d132f60-08ce-4433-be65-7241314c62a2#:~:text=To%20create%20a%20Note%20attachment,which%20returns%20the%20Base64%20value.

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report
Custom File Upload and Processing: Set up a custom form on Power Pages for Excel uploads, then use Power Automate or a custom API to parse and insert data into Dataverse, tailored to your needs.

Dataverse Excel Import Feature: Direct users to utilize Dataverse's built-in Excel import functionality, allowing them to upload pre-filled templates directly into the Dataverse table.

Use Power Apps Component Framework (PCF): Develop a PCF control for the portal, enabling users to drag and drop Excel files, which are then processed and imported into Dataverse for bulk data handling.

Was this reply helpful? Yes No
Viktor Kralevski 12 on at

Like (0)

Report

Thanks Fubar, SaiRT14,

Managed to do this with Fubars approach.

Best regards,

Viktor

Was this reply helpful? Yes No