Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Adding row dynamically to the excel online

How to add a row dynamically in excel online when i click the button. Addrow(drive,file,table , source). please expalin what to add to drive. it prompts like select from document library from drop-down ?. Can anyone explain this?

Dual Super User III
Dual Super User III

Re: Adding row dynamically to the excel online

HI @Manimozhi0890 


If you are trying to add a row in the Excel, add it as a datasource and then you can use the Patch formula on the "OnSelect" property of your button control:
Patch(DataSourceName,Defaults(DataSourceName),{Field1: "Value1",Field2:"Value2"})
For more information about Patch, please refer:
If this differs from what you are looking for, please share more details about the scenario, maybe through some snippets/screenshots.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Super User III
Super User III

Re: Adding row dynamically to the excel online

Hi @Manimozhi0890 

PowerApps doesn't fully support the 'Excel Business Online' connector.

For Excel documents that are stored in OneDrive for Business/SharePoint, the workaround is to use Microsoft Flow.

If it isn't possible for you to use Flow and it's a requirement for you to use Excel, the only other option is to save your Excel file to a personal OneDrive account/Google drive/Dropbox account, connect to the data source in PowerApps, and to use the Patch function as @yashag2255 describes.

You can find a bit more detail in the thread here...


Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (8,452)