web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps DB selection for Power...

Power Apps

Answered

DB selection for Power Apps

(0) Share

Report

Report

Posted on by komesuke

38

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.

Categories:

Governance & administering

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No

Join the conversation