Skip to main content

Notifications

Community site session details

Community site session details

Session Id : g0BAPoVn0PPDRqJZJriwCZ
Power Apps - Building Power Apps
Unanswered

Power App Error Message - The Requested Resource is Locked

Like (3) ShareShare
ReportReport
Posted on 23 Jul 2020 21:04:59 by

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!

 

Categories:
  • armando_pereira Profile Picture
    4 on 24 Oct 2022 at 19:46:11
    Re: Power App Error Message - The Requested Resource is Locked

    Olá.
    Mas as listas nĂŁo tem limites de linhas. Preciso de uma base que possa suportar mais de 10000 registros

     

  • Ugochukwu Profile Picture
    3 on 06 Jun 2022 at 18:19:24
    Re: Power App Error Message - The Requested Resource is Locked

    This worked for me. Thank you.

  • Andauquer Profile Picture
    5 on 22 Nov 2021 at 15:10:01
    Re: Power App Error Message - The Requested Resource is Locked

    This solved the issue for me, thanks!

  • Andauquer Profile Picture
    5 on 22 Nov 2021 at 15:09:36
    Re: Power App Error Message - The Requested Resource is Locked

    This solved this issue for me, thanks!

  • Vinay Prt Profile Picture
    Microsoft Employee on 30 Oct 2020 at 11:11:36
    Re: Power App Error Message - The Requested Resource is Locked

    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.

  • mdevaney Profile Picture
    29,987 Super User 2025 Season 1 on 24 Jul 2020 at 01:56:38
    Re: Power App Error Message - The Requested Resource is Locked

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

  • Christopher S Profile Picture
    on 24 Jul 2020 at 00:56:15
    Re: Power App Error Message - The Requested Resource is Locked

    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

     

  • Community Power Platform Member Profile Picture
    on 23 Jul 2020 at 22:11:22
    Re: Power App Error Message - The Requested Resource is Locked

    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?

  • mdevaney Profile Picture
    29,987 Super User 2025 Season 1 on 23 Jul 2020 at 21:15:56
    Re: Power App Error Message - The Requested Resource is Locked

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
mmbr1606 Profile Picture

mmbr1606 39 Super User 2025 Season 1

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 32

#3
DBO_DV Profile Picture

DBO_DV 31 Super User 2025 Season 1

Overall leaderboard
Loading started