Answered

Error ID is not delegable

(0) Share

Report

Posted on by Danilo-ES-BR

Hello, I have a delegation problem on my Sharepoint list, as I see both the source and the operators are delegable, but I can't sort and filter by ID.
For me it would already resolve to pull the last 500 or 1000 dice! It was already great! I don't need to access the full bank.

What can be happening that I can't filter?

índice.jpg

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

What about creating a collection Onvisible of the screen and replacing the Datasource in the formula with the collection. Also is your Delegation limit set to 1000 or more.
Another clue may be placing value around: Value(TextSearchBox.Text)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

RezaDorrani 12,145 on at

Like (1)

Report
Copy link

Link copied!

Hi @Danilo-ES-BR

The SharePoint ID field for a table is a number field in Power Apps. However, SharePoint only supports the equal ('=') operation for delegation on an ID field.

Reference: https://docs.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint

Your best bet would be to store ID in a seperate field and query on that field to avoid delegation.

--------------------------------------------------------------------------------
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.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Was this reply helpful? Yes No