Unanswered

Some app users can't upload data to an Excel table hosted on my OneDrive

(0) Share

Report

Posted on by charlesL Microsoft Employee

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

Thanks !!!

Categories:

Building Power Apps

All responses (10)

Answers (0)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
charlesL Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

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..
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
charlesL Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Jeff,

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

Many thanks
charlesL Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

up
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.
charlesL Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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 :

2
HTML1300: Navigation occurred.
8fde51ff-232b-41dd-bc1c-d703d52cadac (1,1)

2
Renewing token

exchangeAllPluginVersions succeeded
4
HTTP404: NOT FOUND - The server has not found anything matching the requested URI (Uniform Resource Identifier). (XHR)POST - https://firstrelease-001.azure-apim.net/invoke

Renewing token
HTTP404: NOT FOUND - The server has not found anything matching the requested URI (Uniform Resource Identifier). (Fetch)GET - https://graph.windows.net/me/thumbnailPhoto?api-version=1.6
HTTP404: NOT FOUND - The server has not found anything matching the requested URI (Uniform Resource Identifier). (XHR)POST - https://firstrelease-001.azure-apim.net/invoke

Don't have any clue of what it says though..
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.
charlesL Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey,

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 !
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I never worked with a model app but it sounds like this all should work fine in a canvas app. My advice was geared towards a canvas app but hopefully applies to your model app.

Keep the post updated as you get past this.