PowerApps auto fill fields from SharePoint list with

Mustapha Ait Bencheikh 41 Reputation points
2021-03-16T13:16:15.477+00:00

field lookup "NumerAffiliation" give me the capability to auto fill fields in my formulaire "powerapps" by choosing number. when this number >1000 they don't fill fields (NumerAffiliation >= 1000 don't exist). please if some body can help in my issue!

78247-4.png
78295-222.png

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,411 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ChelseaWu-MSFT 6,311 Reputation points
    2021-03-17T08:20:03.337+00:00

    Please note that PowerApps has a data row limit for non-delegable queries set to 500 by default, which means only the first 500 records are retrieved if we cannot delegate a query to a back-end data source (filter, sort, etc.).

    This value can be changed via PowerApps form > File > Settings > Advanced settings> Data row limit for non-delegable queries, up to 2000.

    If the lookup column values do not show up completely, try changing this value to a larger number (2000, for example), then republish the PowerApps form and see the result.

    Reference: PowerApps data row limit for non-delegable queries.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    **Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. **