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 / Power App not updating...
Power Apps
Answered

Power App not updating my underlying datasource

(0) ShareShare
ReportReport
Posted on by 26

I have been using a particular Power App for months now.  The underlying datasource is a shared excel file that exists on One Drive.  I recently installed on a new computer and now when users go into the app and make changes the changes are saved within the Power App but I do not see their changes in the underlying excel table.  Would appreciate any assistance.  Thank you.

Categories:
I have the same question (0)
  • TheRobRush Profile Picture
    11,128 Moderator on at

    If multiple people have the PowerApp open simultaneously and are trying to make edits to excel as a datasource it will generally do nothing and throw up an error, as Excel can only be edited by one user at a time via powerapps. If your app is branching out to be used by multiple users then I would recommend moving your datasource to SharePoint or the dataverse

  • kfaler Profile Picture
    26 on at

    Thank you.  We do recognize that but I don't think that is what is going on here.  We tested an users are only editing records unique to them.  The only difference between editing now and editing last month when it worked is that I installed a new computer.  It is as if sharing not recognized.  I just reshared with all possible users.  What is really weird is that some users are successfully saving changes in the Power App but none of those changes are being written to the underlying excel file.  But, thank you.

  • TheRobRush Profile Picture
    11,128 Moderator on at

    Does not necessarily have to be a user editing the same record, two people submitting unique records to same excel sheet open at same time will also lose all data being sent to excel. This happened to me years ago on an app that only submitted records to excel, had no editing or viewing of those records only new submissions. So, theres a chance it is something else sure, but just in case you thought it was safe as long as they do not access the same record simultaneously, unless it's changed in last couple years, even accessing separate records while another person or machine is accessing them will throw out the edits.

     

    If you want to check another possibility, open your excel spreadsheet in o365 on a machine that is not the new one, see if maybe it says it is locked for use by someone, might get you moving in right direction

  • kfaler Profile Picture
    26 on at

    Thank you.  I do appreciate but using Sharepoint is just not an option for us now.  This has been working and hopefully will continue.  What I cannot understand is that even when I edit the App and I know that no one else has the spreadsheet open, my changes are still not updated to the Excel file.  It is as if the spreadsheet source is not even recognized.

  • Verified answer
    TheRobRush Profile Picture
    11,128 Moderator on at

    Well if you think source has somehow broken, just remove the source within powerapps, wait for all your controls to break and get red x's, then re-add your excel sheet as a source, save, publish, reload

  • TheRobRush Profile Picture
    11,128 Moderator on at

    If you don't mind my asking, what is it about SharePoint that makes it impossible for your team?

  • kfaler Profile Picture
    26 on at

    Ahhh, that is a great suggestion.  I am so new to Power Apps - this is the only one and I have very little knowledge.  But I will do as you say and see if that works!

  • kfaler Profile Picture
    26 on at

    There is a lot that goes into managing a Sharepoint site and our manager of this site is new and she was concerned about managing access to the site properly.  I only use this particular Sharepoint sight myself for certain projects.  Utilizing it for this was more than our manager wanted to take on.  There is just so much to learn with all these applications!

  • kfaler Profile Picture
    26 on at

    I will say that I did try to "refresh" the source earlier.  That did not work.  But I will remove etc.  Thank you

     

  • TheRobRush Profile Picture
    11,128 Moderator on at

    I'd say its about as much work as managing a shared Excel file, if they ever want to go over their concerns I'd be happy to answer any questions. Hope you get the issue resolved in the meantime.

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 379 Most Valuable Professional

#2
11manish Profile Picture

11manish 203 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard