cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Power App Error Message - The Requested Resource is Locked

Hello,

I built a Power App that edits an Excel spreadsheet stored on OneDrive.  The spreadsheet gets its data from a MS Form.  However, when ever someone submits a new form submission, the Power App stops working and gives this error message:  The requested resource is locked. Server Response: Table1 failed: Cannot write file to filesource. File is being locked. clientRequestId: 0cddb2f4-09eb-46b1-85fc-6d664cb03b43 serviceRequestId: 0cddb2f4-09eb-46b1-85fc-6d664cb03b43;0cddb2f4-09eb-46b1-85fc-6d664cb03b43;0cddb2f4-09eb-46b1-85fc-6d664cb03b43;0cddb2f4-09eb-46b1-85fc-6d664cb03b43;0cddb2f4-09eb-46b1-85fc-6d664cb03b43

Can you help me with this issue?  If I could get the App to be able to function while the MS Form is in use, it would save my company a fortune. 

 

Thank you!

 

5 REPLIES 5
mdevaney
Super User III
Super User III

@Anonymous 
If someone is using your app connected with the EXCEL file via MS Forms or some other way it will be locked.  There's not any workaround.  You must switch your datasource to something else like SharePoint.

 

Older post for your reference:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Workaround-The-requested-ressource-is-locked-Cannot-write/td-p/377928

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Anonymous
Not applicable

Thanks for responding...But now I'm confused.  Because when I connect to data in Power Apps and select SharePoint, it only lets me choose a list.  Selecting a spreadsheet in SharePoint is not even an option.  What am I doing wrong?

Hi @Anonymous 

 

SharePoint as a data source for PowerApps lets you select lists and libraries, not specifically files, for this you can store the file in OneDrive.

 

Best Regards

 

If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution

@Anonymous 
You can't store a spreadsheet in SharePoint and then access it.  It can only be done in OneDrive which is where I assume you are having the problem.

Just use a SharePoint list.  It's similar to an Excel table but its on a webpage.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up." 

vinaprt
Microsoft
Microsoft

Just check if your excel file is not opened while you are trying to update from app. Actually it is not recommended to use both (excel file and app) at same time. Hope this helps.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,406)