Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

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
Dual Super User

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
Super User

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


Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,455)