cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Manimozhi0890
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?

2 REPLIES 2
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...

https://powerusers.microsoft.com/t5/General-Discussion/Excel-Online-business-Connector-how-to-use-in...

 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

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