Unanswered

List Threshold Error when Adding a new item in a Large SharePoint List

(0) Share

Report

Posted on by Gottijay2000

169

i Have 2 large SharePoint Lists that are 6000 items and 7000 items respectively. WHen i try to add a new item on Powerapps i get this threshold limit error even though the item is added. This error message is distracting for the users

Does anyone have an idea how i can get rid of this error message?

i have tried indexing some fields in SharePoint, but currently have no clue if thats doing anything

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Are you adding the new item using Patch or Submitting a bound Form?
Gottijay2000 169 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 i'm using a Patch
RezaDorrani 12,145 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Gottijay2000

adding items to lists should not be a problem unless you have some logic to check/filter the data source in there

You will need to ensure each query to the list columns needs to be indexed

So if you are filtering on a column - that col has to be indexed
If you are sorting on a column - that col has to be indexed

Moreover, you can use IfError function in PA to gracefully handle the error https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-iferror

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.