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

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Powerapps and Excel doubts

SharePoint list is better than excel. Read more information on:
https://baizini-it.com/blog/index.php/2017/08/29/powerapps-101-data-storage/

 

On creating Tabs, watch;
https://youtu.be/GugRoM2v494

------------

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.

Highlighted
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:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearc...

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-remove-removeif

 

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

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

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.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,624)