DB selection for Power Apps

(0) Share

Report

Posted on by komesuke

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.

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (1)

Report
Re: DB selection for Power Apps

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"

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

Best Regards,

Bof