Update Dataverse table at once

(0) Share

Report

Posted on by Sajarac

3,271

Hello Community.

I am looking for some advice:

I have an Excel file that a coworker updates on a weekly basis. I would like to have a Blob Storage or SharePoint library where this person can upload the file. Then, a flow would clear the Dataverse table and copy the data from the new Excel file into the Dataverse table.

The Excel file contains several items, and I have tried this process, but it takes forever to complete.

Does anyone have a suggestion for a faster and more efficient solution?

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

vipuljain03 657 Super User 2025 Season 2 on at

Like (1)

Report

Use Dataflows - https://learn.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365

Was this reply helpful? Yes No
Sajarac 3,271 on at

Like (0)

Report

Hey @vipuljain03, thank you very much for your prompt response. That looks like is the way. But I am having troubles mapping the columns.

A value must be mapped to the selected primary key column "tm_AF_TblRecordsId" or it should be un-selected as a primary key.

Any Idea ? I don't have any primary columns in my excel file. And I just did a Autonumber in Dataverse but is not cooperating at all.

Was this reply helpful? Yes No