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 / Data Source update sta...
Power Apps
Unanswered

Data Source update static excel file

(0) ShareShare
ReportReport
Posted on by 14

Hello Dear,

 

I have a very complicated galleries, tables on my app. But many people is using this and some informations are coming from excel file which is in Teams.

 

I am updating excel files and all data are ok in app. But ı want this, some people ( ı will select user ) could update data source. 

In order to solve it I tried this;

 

1. I put the excel file on onedrive, but 2nd user didnt save. Because file is opening "only read" mode. 

2. I tried to automate but ı dont know too much, thats why ı could not success. 

3. I put the static excel file on app and I tried to change on app, but ı have read some documents on internet and there is not any way to change data source using application. 

 

I need to solve that, how can I change data source on app ? or how some people could change excel file and save on onedrive ? how can I solve "only read mode"

 

note: From another pc, I tried that; ı logged in with my account and ı opened excel file but again system opened it "read only"

 

 

Regards,

 

Categories:
  • WiZey Profile Picture
    3,023 Moderator on at

    Hello @hmtstc ,

     

    PowerApps support two connectors for Excel.

     

    WiZey_0-1658827887515.png

    (sorry it's in french)

     

    The first import an Excel table inside the Power apps as "static data". I understand this is the one you're using.

    Importing Excel as static data means the data cannot be altered as it is inscribed inside the code of the app and is constant.

     

    The second connects the app to an Excel file located in a SharePoint Online library. This one allow you to interact with the tables the same way you can interact with SharePoint lists and Dataverse.

     

    If you want your users to update an Excel table, I suggest using this second connector.

  • hmtstc Profile Picture
    14 on at

    Dear Wizey,

     

    I know that solution but please think as I explained below;

     

    There are 10 user. I am user1. 

    I have an excel file on sharepoint. If I open it and update, system is working.

    But for example; if user5 open this excel, system is opening "only read" mode. And even if user5 change value, can not save. User5 must to save as another file. 

     

    Thats why static excel change model was option for me. But I didnt find to change during using app.

  • hmtstc Profile Picture
    14 on at

    kindly reminder, how can I update data source from different computers ? 

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 405 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 368

#3
WarrenBelz Profile Picture

WarrenBelz 244 Most Valuable Professional

Last 30 days Overall leaderboard