
Announcements
Hello all. I have a PowerApps in which I need to feed data into my app from an excel file which is located on a Network Drive we have here at work. I am not sure this is an option for a PowerApps... so that leads me to Power Automate. I would like to copy this file from the Network Drive to OneDrive so that I can then have access to the data in my PowerApps (PowerApps has a connector for OneDrive). This excel file is updated once a day and as such a one-time manual copy isn't a good solution. How can I go about building this flow? Is it possible through Power Automate?
Thanks for taking the time to read this and help in finding a solution.
You need to have a gateway installed to connect your network to the cloud, then you can use the file system action to connect via the gateway to local file system. It works via a "gate keeper", you "authenticate" as you to the gateway then the gate keeper goes and fetches the file you asked for. So anything you want to access via file system the gateway account needs to have access.