cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
glourenco
New Member

Automatically update excel file connected with a database

I have a bunch of excel files that are connected to our companies database. Every single day, someone has to enter these files and click "Update" so it updates the connections, queries, etc, i.e, all the info that changed in the database. This is used mainly so managers and etc can quickly check KPIs and other metrics.

 

I was wondering if automate could do this for us? Create a flow that, using recurrence or a manual trigger, would automatically update the file(s) with the new data in the database.

 

Thanks!

0 REPLIES 0

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (4,528)