Dataverse regularly import from excel file without overwriting of changed values

(0) Share

Report

Posted on by Ikswoknib

Hello all,

I made an App for editing some Data in an Dataverse Table.

I use an excel file to get new Data to the Dataverse Table, for that purpose i made an Dataflow to import the data.

My Problem is, when i change data in the dataverse table (via an Power App) and afterwards the import starts again, the data in the dataverse table will be overwritten by the original content of the excel sheet.

Is there a way to prevent this?

The Excel File is only for getting data to dataverse. So I would be happy if i could tell the dataflow to delete each dataset in the excel file after importing it to dataverse. The data must not stay in the file!

Another solution would be to tell it not to overwrite existing data.

Is there any solution ?

best regards and thank everybody

Iksi

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @Ikswoknib,

If you only need to import the data once, then don't set any refresh interval on the dataflow?

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Ikswoknib 19 on at

Like (0)

Report

In need to do that on a regularly basis, so this would not be a solution for me.
I made it now with Power Automate. There are a lot mory possibilities.
I check for every dataset if it is already in dataverse, if not i create it.
What i would like to do also, would be too delete each dataset in the excelfile, after importing it.
I tried it with the delete row function, but there i get each time a failure, here is the message:
message "This won't work because it would move cells in a table on your worksheet."

I don't know what to do now, I think it is normale that, if i delete a row it would move cells in a table, so how can i delete one row?

thanks and best regards

Ikswoknib

Was this reply helpful? Yes No
sncueto 19 on at

Like (0)

Report

If you have also a Power Automate license, and Excel have all the data in tables, I think that the easiest ways is to launch dataflow directly from Power Automate cloud flow, and after that clean Excel's rows in the same flow. I don't know any way of doing it natively with dataflow.

Regards

Was this reply helpful? Yes No
Ikswoknib 19 on at

Like (0)

Report

I am using Power Automate now, but i can't delete any rows. I always get the message "This won't work because it would move cells in a table on your worksheet."

Was this reply helpful? Yes No
sncueto 19 on at

Like (0)

Report

I´m afraid that that have something related to the position of the rest of the tables in the sheet, that can only be solved on the Excel.

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report
Hi @sncueto,

Trying to delete one row at a time in an Excel sheet when you have over 500k rows will not work as you will exceed API limits way before that. I would definitely use Power Automate to trigger the Dataflow refresh. To address the rows you have a couple of options :

Create an Office Script. In your flow, you can use the Run Script action to execute it.

In your flow, recreate a new Excel file, Worksheet, and Excel table with all the columns and overwrite the existing file.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No