Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Powerapps and Excel doubts

Hi All,

I have few doubts-

1. I have data in house- What DB will be the easier- excel or sharepoint?

2. How can I insert data into pre-defined excel templates?

3. How to create new tabs in excel based on the form in powerapps?

Any help is appreciated 

Super User III
Super User III

Re: Powerapps and Excel doubts

SharePoint list is better than excel. Read more information on:


On creating Tabs, watch;


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Community Support
Community Support

Re: Powerapps and Excel doubts

Hi @Tejasvi_munge ,

1)If your data is very large, I more suggest you use sharepoint list as your data source.

Since powerapps has delegation limit, only you use delegate functions, you could get right result.

Sharepoint is one of the delegate data source. Excel is not.


2)Firstly, you need to format your excel data to a table.

Then upload this excel file to one drive.

Connect your app with this excel table in one drive.

Then use formula to update excel table in your app.

The formula that you could use to update data:
Patch, Collect, Remove,....

Here're docs about these functions for your reference:


3)I'm afraid it's not supported in powerapps.

You could only use powerapps to update data in excel.

You could not create table, create tab, create filed, change field name in excel by using powerapps. (change the structure of the excel.)

Same as in sharepoint.


Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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 (6,245)