Skip to main content
Community site session details
Power Apps - Microsoft Dataverse
Answered

Automating API calls in Dataverse?

Like (0) ShareShare
ReportReport
Posted on 17 Oct 2023 11:42:47 by 11

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!

Categories:
  • Verified answer
    ivan_apps Profile Picture
    2,187 Moderator on 20 Oct 2023 at 15:16:47
    Re: Automating API calls in Dataverse?

    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 😀

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete