Some of my application users can't upload data to an Excel table hosted on my OneDrive
The app is simple : I ask the user to complete a form, validate its inputs and then I collect all data in a table in my Excel file hosted on my OneDrive account
Additional info :
- Everybody has been set up as Co-owner of the app
- Everyone has the permission to modfiy the online excel
- My excel is located at Users/t-chilet/OneDrive - Microsoft/ MBU Data Collection.xlsx
- The excel file was not opened on any computer (I know it is a common issue)
- I asked 3 colleagues I shared the app and the excel file with, to test the app and upload data: 2 of them succefully uploaded data and the last one failed. (I'll put its session id here as the form to create a ticket does not work)
- App id : 8fde51ff-232b-41dd-bc1c-d703d52cadac
- Session id of user who can't upload data : f62a4ef0-1f1d-4393-a370-f365c3e958fd
- I'm posted here because I did not find solution to my pb and I can't open a ticket using the submission form
Please can you try identifying the error using the session id ? It is really urgent, I need my app to work for 9 team members
You can try and have the user access the Excel directly in OneDrive to make sure there isn't any permission issues on the OneDrive side.
FYI: It probaly isn't a good practice to make all your users a co-owner because that means they can all modify the design of the app.
Thanks for your help
Why do mean by giving access to the Excel directly in Onedrive ? My excel is hosted on my OneDrive for Business and I have shared it to all members who are supposed to use the app
My data connector is not Excel but OneDrive
Yes I'll remove this permission to every members but I saw on previous topics that it happened to be a solution for people having a similar issue like me..
Since PowerApps is using the user's permission to access the file you will want to make sure the user has the correct access to the Excel file in OneDrive. You can test this out by having the user manually going to the Excel file in OneDrive. If the user can get to the file and edit the file then you know the access issue isn't related to the OneDrive file permissions. If the user is unable to get to the file then you know the issue is with the OneDrive file permissions.
All of my 3 colleagues can actually open this file on OneDrive and edit it !
The most surprising in my issue is that 2 of them can edit the excel table from the app and the last one can't.
Can anyone of PowerApp technique support team look at the session id I mentionned above ? It would help understand the error that happened for this person
I would try two things:
1) share the app and the sheet by the person's name rather than by a group just to make sure there is no ambiguity in the permsissions. I find in my org, the group names PowerApps finds when sharing do not seem to match the actual accounts.
2) create a new very basic app that submits a change to the excel sheet or a similar via one drive. Maybe something changed in the environment that is cached and causses mixed access.
Also, what type of error are you getting when you submit the changes? If not, it's possible you just need to wait for it show up.
Hi geneZebra, thanks for your help
1) I've shared the app and the excel file by the person's name and I did it through the same manner for all of my 3 colleagues who tried the app
2) I created a new app from the model "Site Inspection" (I got inspired by this model for my app), and I also created a new excel spreahsheet located on my OneDrive for Business account --> it still does not work for the person I mentionned above..
So I've been inspecting the "validate" button (which allow the user to send the data through my excel table) using the account of my colleague who can't upload data, and I catched the following errors in the console :
I'm not too familar with that model. Is that a sample app template or model driven app?)
In any case, I've seen similar wierd things reported like this if my form and a bad data card. Try refeshing the data source and looking at all the "Update" properties in each card in the form. Or simply create a new form from scratch to ensure it's created properly.
Also as a test, make a copy of the app and delete as many as the datacards in the form you think is suspect. Or maybe put in a temp button to simply "Patch" in a value to the table. This should at least ensure the application is able to modify the table for this user.
I suspect there is logic in the app that either not setting a data card properly and a bad value just happens to occur on this user. It sounds your form is referring to fields that are not found but that's jsut a WAG.
Thanks for your advice I'll try these different solutions !
But as I mentionned above, this problem is only for 1 of my 3 colleagues, so I don't think it is a problem regarding the app in itself but a permission/access pb on OneDrive..It is really hard to catch the error
My 2 colleagues who successfully edited the excel table through the app were using Chromium and Microsoft Edge, and the one can't manage to edit the table is using Microsft Edge too. So I don't think it is a web browser issue
The Inspection site model is a model app, I created this app as a test for the user who can't upload data on my initial app,and the same issue showed up..
I built my app from scratch (so I did not start from the Inspection site model) but I got inspired for all variables and functions from this model !
Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.
Let's thank our top community contributors
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200