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

PowerApps failing to work with Excel stored in Business Onedrive.

Hello,

 

I have a excel sheet and the purpose for it is a quality/performance of call operators on calls we have listened to and provide feedback with a score. Each operator has their own sheet with their own table. Master page calculates totals etc, not important.

 

I am basically using this powerapp to create a entry form for each sheet. However I have been receiving issues with connecting to the data, and submitting entries.

 

Issues that have arised:

The Excel worksheet that is the source becomes corrupted after a connection is made.

This error message also appears:

Failed to load AmandaT. The specified record was not found. Server response: Failed to read metadata from file source. Response from the end service is : Not Found clientRequestId: 57bd01aa-5f3a-4178-9146-78b515259148 serviceRequestId: 57bd01aa-5f3a-4178-9146-78b515259148;57bd01aa-5f3a-4178-9146-78b515259148

 

Am I doing something wrong, does excel sheets within a onedrive not function fully and needs work? Should I look for an alternative method?

3 REPLIES 3
Super User
Super User

Re: PowerApps failing to work with Excel stored in Business Onedrive.

@Powerman1you might just need to look at the separation of data.  Meaning - you should (in my experience with Excell as a data source) only be using Excel as a datasource for your PowerApps app.  It should just be tables on sheets.  No one else should be using it.  I know they can, but I would avoid it like the plague.  I can easily see where someone mucking around using the "core" Excel file of data can throw PowerApps off and give such errors.

So, instead, you might want to look at it (the Excel file) as a datasource for not only your PowerApps, but also a datasource for ANOTHER linked Excel file.

You can easily, in Excel, connect to another Excel file (your core datasource) and pull information into a "nicely" formatted and formula rich Excel sheet.  It will update from the "core" file, just like PowerApps will get and update info from the core file.

 

Hope this give some fuel for thought.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Powerman1
Level: Powered On

Re: PowerApps failing to work with Excel stored in Business Onedrive.

Thanks for your reply, that makes sense, I will try that and see if I have an easier time.

jmill130
Level: Power Up

Re: PowerApps failing to work with Excel stored in Business Onedrive.

Randy,


Here is my use case and issue:

 

1. I have data I am sending to OneDrive to XLS formatted table via sFTP Flow 

2. I use the OneDrive Excel file as my datasource for PowerApps, but as you note users need read/write access to this file, and its risky.

 

Are you suggesting, send my file to OneDrive, make it view only, then create another file pointing to my view only file that is read/write for apps to use?

 

USers would need access to both and if they find the read/write file, wont it still be a risk?


THanks,
Jason

 

 

Helpful resources

Announcements
thirdimage

Power Apps 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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,863)