web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Editing excel data loc...
Power Apps
Answered

Editing excel data locks it for my App

(0) ShareShare
ReportReport
Posted on by 10
When I am editing my spreadsheet which backs my data source (from one drive) if a user opens the app for the first time they get a message that the data source has been locked. No data is available in the app. How can I manage making changes to the backend spreadsheet when my app goes live (without incurring these errors for users)?
Categories:
  • Verified answer
    TheRobRush Profile Picture
    11,128 Moderator on at

    you cannot have an excel spreadsheet open and being used at the same time a powerapps app is editing it. also if you happen to have multiple devices running powerapps simultaneously and two or three of them (this is rare odds wise but happens) try to edit a spreadsheet at the exact same moment you will also get an error.

     

    for data sources being edited in multiple places simultaneously it is far better to use sharepoint lists.

     

    if you also need a copy in excel later, just set up a flow that runs nightly to copy any new records into excel.

  • sommerlund Profile Picture
    10 on at

    @TheRobRush wrote:

    if you also need a copy in excel later, just set up a flow that runs nightly to copy any new records into excel.


    Thanks @TheRobRush .
    I prefer using excel over the sharepoint lists for for various reasons.  But I understand this a little better now thank you for that feedback.  I haven't used flows yet.  Something else I'll have to learn.  Can you help me out a little getting started where to look to create a flow that "runs nightly to copy new records into excel".

  • TheRobRush Profile Picture
    11,128 Moderator on at
    Yah man. Above your sharepoint list there will be a flow button. Click it and then select create flow. You will select to create a scheduled flow. Set its repetition to 1 and daily then set a convenient time. After that step it will be get sharepoint items (and choose your sp list). After that create row in excel table. Then delete sp list. These will be foralls based on your original get items. Its very easy once you are therw in flow its very intuitive and will help you itself. (Be sure to set your table up in excel before hand and load it to your sharepoint site so that flow can access it

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 232 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 202 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 122

Last 30 days Overall leaderboard