question

MustaphaAitBencheikh-9124 avatar image
0 Votes"
MustaphaAitBencheikh-9124 asked ChelseaWu-MSFT commented

PowerApps auto fill fields from SharePoint list with

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





office-sharepoint-online
4.png (22.5 KiB)
222.png (19.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Please confirm:

  1. Do you have lookup values larger than 1000 from the source list but it does not show in the dropdown menu? If so, how many choices do you have in the lookup field?

  2. Or do you want to autofill the additional fields even when the lookup field is filled with an invalid selection (for example, when you do not have lookup values larger than 1000)?

Please give detailed information on your issue or request so we can investigate for you.

0 Votes 0 ·

1 Answer

ChelseaWu-MSFT avatar image
0 Votes"
ChelseaWu-MSFT answered ChelseaWu-MSFT commented

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MustaphaAitBencheikh-9124 , do you have any progress on this thread? Please feel free to let us know if you need further assistance.

0 Votes 0 ·

Hi @MustaphaAitBencheikh-9124 , I’m checking on how things are going on with this thread. Please remember to update this thread if you have any progress.

0 Votes 0 ·