cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
charlesL
Level: Powered On

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

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 !!!

10 REPLIES 10
Super User
Super User

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

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. 



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
charlesL
Level: Powered On

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

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..

 

Super User
Super User

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

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.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
charlesL
Level: Powered On

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

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
Level: Powered On

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

up

geneZebra
Level 8

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

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
Level: Powered On

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

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  : 

 

 

geneZebra
Level 8

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

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
Level: Powered On

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

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 !

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 328 members 5,936 guests
Please welcome our newest community members: