Hi All,
I'm pretty new to Power Apps, but have managed to build a multi screen app to pull data from one excel table, collect further data from the user and post back to a second excel table in a separate file. These excel files are stored in a department specific SharePoint folder.
Anyone within my department with access to those files within SharePoint, seems to be able to use the app fine. My issue comes when users without access to that SharePoint and therefore those tables, attempt to use the app. They get an error; "Error when trying to retrieve data from the network. No table was found with the name.....".
I cannot allow users outside of my department wider access to these tables other than for the use of this app. For example, I wouldn't want to place these files in a SharePoint share that all employees could access, as they would be able to view the entire contents of these files.
1) How can I achieve this?
2) What other ways can I get this app working for my needs?
