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

Save data from a text input in excel table

I´m new in powerapps and i try to develop an app for my compary but i have a doubt and sorry for my writting

 

i made a gallery from table in excel and i have all one column in blank just for recolect data from a text input, i insert that text input in the gallery, i used a lookup to bring a specific row in the table i want uptdate from the text input but i dont know how update/save that data in my excel table..

 

i left a image for my case, and i hope a good soul would be help me, i would be really grateful.

 

Best wishes, Vicente 

1 ACCEPTED SOLUTION

Accepted Solutions

Same problem.  Doesn't matter where the Excel table is.  Now, having said that, there are tools within Flow that can write information to Excel.  In that scenario it is better to have the file in OneDrive.  

The thing about PowerApps is that it runs AS THE USER that is using the app.  So if the user doing the update doesn't have rights to the source (e.g. Excel) then it won't work.  HOWEVER, if you put your logic within Flow, then that is done under the Developer's account, vs. the Users.  So I can create a Flow that updates Excel and even though the users in PowerApps don't have the rights to Excel, I do, so it works even when other users submit data via PowerApps.

Do keep in mind that if you do something like this, the data that the PowerApp has IS STILL NOT CURRENT unless you're getting that data from Flow or from a shared SharePoint list (or similar) that Excel is referencing.

View solution in original post

3 REPLIES 3
jhall
Skilled Sharer
Skilled Sharer

Generally, Excel data is STATIC per PowerApps.  Meaning, that you did an import of the table as it existed at the moment of development (not run time).  I'm assuming you did this: View | Data Sources | Add data Source | Excel.

In this scenario, you have created a table of information that exists completely distinct from Excel.  You imported it, but you aren't linked to it.  This means that changes to it are not written to Excel.

The way that PowerApps can write information to Excel can be accomplished a number of ways, but it is most commonly done where the Excel Tables in question are actually linked to a SharePoint list.  When the Excel Table is updated from SharePoint, it pulls the data that PowerApps wrote there.

Writing directly to Excel is unlikely to be supported directly via PowerApps.

Anonymous
Not applicable

Jhall thank you for your help, i just have one more question.

 

the source of my excel i took it from One drive and i assume is similar than share point, i want save that data in my excel in one drive.

Same problem.  Doesn't matter where the Excel table is.  Now, having said that, there are tools within Flow that can write information to Excel.  In that scenario it is better to have the file in OneDrive.  

The thing about PowerApps is that it runs AS THE USER that is using the app.  So if the user doing the update doesn't have rights to the source (e.g. Excel) then it won't work.  HOWEVER, if you put your logic within Flow, then that is done under the Developer's account, vs. the Users.  So I can create a Flow that updates Excel and even though the users in PowerApps don't have the rights to Excel, I do, so it works even when other users submit data via PowerApps.

Do keep in mind that if you do something like this, the data that the PowerApp has IS STILL NOT CURRENT unless you're getting that data from Flow or from a shared SharePoint list (or similar) that Excel is referencing.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,057)