cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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.

v-yutliu-msft
Community Support
Community Support

Hi @Anonymous ,

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-clearcollect

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,327)