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
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,740)