Hi Team,
We're currently building a PowerApp that leverages multiple excel files as a data source.
We have to limit user access to the excel files as some of the data shouldn't be seen by other Users.
We hid specific parts of the application from Users via Visible Property however we are getting errors since some users don't have access to all of the files.
For Example,
We have 3 views, having 3 different data sources. User 1 can only see 1 view and have access to one of the 3 Files. Upon Application Load, User 1 gets 2 errors(see below) which is not a user friendly error.
"Failed to load Table XX: The specified record was not found. Server response: Table XXfailed: Failed to read metadata from file source."
Is there a way to suppress/catch/update these errors?
Thanks for the help!
Given you are using Excel data sources, your options will be limited. Basically, at run-time, the app will try to read the Excel file in any tabular object or function that references the source.
What you're experiencing is the fact that the sources are being read (probably by another screen's control), regardless of whether or not the user has access and the error is being thrown at that time.
I would explore the Errors function to see if this may help (can't say I have done this with Excel, however). https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-errors
A few other alternatives:
Thanks for the Alternatives @GarethPrisk!
We looked into the suggested options but unfortunately Using Errors and Collections didn't work for us.
We tried tying up our excel into a collection within a filtered view and initiate it once user loads the view however i think it's PowerApps' behavior to index/load all source files upon start up regardless if the collection was initialized hence we still got the errors.
We'll look into changing our source for now.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
201 | |
176 | |
61 | |
32 | |
30 |
User | Count |
---|---|
307 | |
263 | |
105 | |
79 | |
56 |