Update multiple entities with one Excel file?

(0) Share

Report

Posted on by trincon

Hey guys,

I am new to Dataverse and just figuring out the best way to patch data with an Excel file to Dataverse.

What's working is to export the data of an entity as an Excel file, so I can update the entity within this file thanks to the Microsoft PowerApps Office Add In-Connector.

What I want now is to update multiple entities with just one Excel file. So I added a new sheet and then get the next entity with the connector. I can select the fields of the entity, but when I'm done I only have an empty table to this entity. I am not able to get the existing data of this entity from Dataverse.

So I wonder is this even possible or do I need to have an Excel file for every entity? Or am I missing something to get the data?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report

Re: Update multiple entities with one Excel file?

Hi @trincon ,

At my knowledge, you need to have an Excel file for every entity.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Re: Update multiple entities with one Excel file?

Hi @trincon,

Confirming @v-xiaochen-msft, unfortunately all Excel type of imports, like Power Apps add-in, Excel online or CSV import is one file per table/entity. Suggest to submit that idea for the Office Add-in at: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

Another option is to use Dataflows with Excel where you can have more than one file: https://docs.microsoft.com/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365

Hope this helps!

Was this reply helpful? Yes No