Upload Excel and import in Dataverse

(1) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
CA1105 545 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
timl 36,774 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Ammar Zaied 97 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No