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

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
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (5,048)