Upload Excel and import in Dataverse

Like (1) Share

Report

Posted on 19 Sep 2024 07:35:22 by Steve.Desmedt

Dear all,
I have received a request from a cutomer to have the ability to upload an Excel in a model driven app and read it into a dataverse table. The Excel should be edited automatically.

So in real life the solution should be looking something like

An additional difficulty is that the Excel should be transformed (format in screenshot), so empty lines van be removed automatically.

At this moment, i don't find a appropriate solution to achieve this.

Could someone help me out ?

Kind regards

Steve

Categories:

General Questions

All responses (5)

Answers (0)

Michael E. Gernaey 42,027 Super User 2025 Season 1 on 21 Sep 2024 at 01:04:05

Like (0)

Report

Upload Excel and import in Dataverse

why do people keep posting the same answer or suggestion way after its already there?
Suggested answer

Ammar Zaied 97 on 20 Sep 2024 at 16:18:05

Like (0)

Report

Upload Excel and import in Dataverse

You can load into Dataverse to trigger a Power Automate flow if you need to process the Excel file, then recreate the file in OneDrive, for example, and return the result to Dataverse.
timl 35,018 Super User 2025 Season 1 on 20 Sep 2024 at 15:14:21

Like (0)

Report

Upload Excel and import in Dataverse

Hi Steve,

The approach I would start off with is to build a Power Automate Flow. You can trigger it when a row is updated/added to your Dataverse table.

In the flow, you can retrieve the attachment/Excel file and use the Excel connector to list the rows. You can filter out the empty ones and add the resulting rows to the target Dataverse table.
CA1105 356 on 20 Sep 2024 at 10:21:00

Like (1)

Report

Upload Excel and import in Dataverse

How you are reading the data from excel? Or is it like you downloaded the excel template for DV table and import from there?
Suggested answer

Michael E. Gernaey 42,027 Super User 2025 Season 1 on 20 Sep 2024 at 05:29:21

Like (1)

Report

Upload Excel and import in Dataverse

Hi

There are different ways, but would you could do is either create a Collection based on XYZ column !IsBlank() and then it wont have the blank ones

Or you can use a power automate flow, that will process the file and make it importable, and then point at THAT.

So essentially either parse it in memory, or write it to SharePoint/OneDrive, remove the empty lines then import the output of that flow.