hi,
I have a database created by my developer in MS Access. I would like to connect it with Dataverse and automate API calls to update the dataset.
Currently I have to open the file, click on two separate buttons to update the records names and then I'm making another call to update number values. I would love to upload it to Dataverse and automate the whole process. Is it doable?
Thanks in advance!
Yes i think in your case you would basically replicate what that API call is doing in Power Automate and have it run on a schedule.
You can then import your MS Access database directly into Dataverse so that Power Automate can run the API call, and update your dataverse tables automatically.
That way you can still run your MS Access interface when needed with a Dataverse backend, no need to call API button and work towards creating a new UI in Power Apps 😀
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2