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
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (1,934)