Sync local Excel table data to Dataverse for Teams tables

(0) Share

Report

Posted on by td1979

157

Hello,

I currently do alot of PowerApp dev using SP lists as data sources.

I want to use Dataverse (Teams) but dont know how to sync local Excel table data to Dataverse. It seems that scheduled dataflows are not available in the Teams environment.

Does anyone have any suggestions for how to get multiple (same structure) tables from local workbooks into Dataverse teams, and the most important bit - to keep local changes sync'd to Dataverse?

I realise this is very vague, but at the moment I'm just trying to work out if this is even possible.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report
Hi @td1979

You can use Microsoft Flow) to create flows that trigger when changes are made to your local Excel tables. These flows can then push those changes to Dataverse tables using the "Create a new record" action.

With in Flows you can create a flow that triggers on a schedule or when changes are made to your Excel file in a cloud storage service like OneDrive or SharePoint. This flow can read the data from your Excel file and create or update records in the corresponding Dataverse tables.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
td1979 157 on at

Like (0)

Report

@rampprakash Hello, do you mean by way of the Excel Power automate add in?

This morning has been nothing but disappointing, with solutions for what seems a pretty standard idea (so I thought) being very hard to find! I thought I had the solution using the powerapps add in to excel, until I found out that you can not have connections to more than one dataverse table in the same excel file O_o -

Was this reply helpful? Yes No