cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
komesuke
Frequent Visitor

DB selection for Power Apps

Hello.

Please tell me about DB selection when creating an app in Power Apps.

 

When creating apps with Office365 for Power Apps license, I think most of them will use SharePoint list.

If you use a function that can be delegated, you can use more than 2000 items, and if you create an index column, you can use more than 5000 items.

 

If the application needs to register more than that (say, tens of thousands), should I still purchase the Power Apps per user plan and use Dataverse, SQL Server, etc.?

 

Love and Peace.

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @komesuke :

I created 10,000 ordered items using PowerShell

For($i=1;$i -le 10000;$i++)
{
Add-PNPListItem -List "BofNewTest" -Values @{"Title" = "Item TItle" + $i} -ContentType "Item"

vbofengmsft_1-1629274680858.png

 

From my test results, PowerApps supports SharePoint Lists with more than 5000 items without delegation problems.

vbofengmsft_0-1629274641354.png

Best Regards,

Bof

 

 

View solution in original post

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @komesuke :

I created 10,000 ordered items using PowerShell

For($i=1;$i -le 10000;$i++)
{
Add-PNPListItem -List "BofNewTest" -Values @{"Title" = "Item TItle" + $i} -ContentType "Item"

vbofengmsft_1-1629274680858.png

 

From my test results, PowerApps supports SharePoint Lists with more than 5000 items without delegation problems.

vbofengmsft_0-1629274641354.png

Best Regards,

Bof

 

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,909)