Answered

Need to import data from latest excel to dataverse

(1) Share

Report

Posted on by CU07050602-0

Hello,

I have a Dataverse table that I want to keep updated with data from the most recent Excel file uploaded to a SharePoint folder. Here's what I need: someone will upload an Excel file twice a week. I want to create something that checks, every morning, the latest Excel file uploaded to SharePoint and verifies whether the data is correctly loaded into Dataverse. If everything is fine and there are no changes, it should do nothing. But if there are changes, I need it to apply those updates or even insert new data from the file.

How can i do it?

Thank you!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Suggested answer

mmbr1606 14,615 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hey

please repost here as its more a power automate question:

Microsoft Power Platform Community Forum Thread

If my answer was helpful and it solved your issue please mark it as verified answer. If it helped but did not solve please consider giving me a like :)

Was this reply helpful? Yes No
Verified answer

ankit_singhal 618 Moderator on at

Like (1)

Report
Copy link

Link copied!

You need to create power automate which will be trigger daily. You can get the file from SharePoint and insert data in dataverse from that file and then you can validate your data accordingly in power automate as well.

Note: Please mark verified, if it is useful for you

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,615 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

hey

maybe this helps:

How To Import Excel to Dataverse using Dataflow - YouTube

If my answer was helpful and it solved your issue please mark it as verified answer. If it helped but did not solve please consider giving me a like :)

Was this reply helpful? Yes No