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?
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!
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...