Hello Community,
On my custom PowerApps portal, I have a web page with an entity form on it, where users can basically fill in data and submit the form. When the form is submitted, behind the scene it will create a Lead entity record in the Dynamics 365 instance that's connected to the portal.
I am experiencing a very odd error message on the submission page. When clicking on the Submit button to submit the entity form on the web page, the following error message pops up. This is very puzzling because I am only getting this error when login to the portal as certain users, but the same submission process works fine if I login to the portal as some other different users.
I already checked entity permissions and all that, and everything seems fine. I am really lost as to what might be causing this error message.
Does anyone have any clues? Thank you!
hi @MartinVargas please go to the verified answer as this is thread has a solution. If that still doesn't work for you, can you please create a new thread as this is an old one
.
Hi @Anonymous
Were you able to solve this error? It happens that I have the same scenario.
Greetings.
Hi @OOlashyn ,
Thanks for your inputs. Yes, the view I am using in the lookup is already a filtered view, and we are expecting more than 5000 records in the filtered view.
I understand this is a limitation with the portal, which is unfortunate. Hopefully improvements will be made in future releases.
Thanks again!
Hi @Anonymous ,
Do you need to show all available options or you can prefilter them? Usually, I create views that I use on a Portal only with prefiltered data. You can setup which view will be used to show the data on the lookup. Open your form, select lookup field and then change what view will be used by changing Default View.
Hi @Anonymous ,
Actually, it is an known limit with the LookUp field in PowerApps Portal, I afraid that there is no direct solution to achieve your needs in PowerApps Portal.
If you would like to get further help in this issue, please consider submit an assisted support ticket through the following link:
https://powerapps.microsoft.com/en-us/support/pro
If the solution I provided above is helpful in your scenario, please also consider go ahead to click "Accept as Solution" to identify my reply as helpful.
Regards,
Hi @v-xida-msft ,
Yes, the issue I am having is related to limitation of lookup fields rendered as dropdowns in the portal, as we have more than 5000 records in the lookup.
We are looking into other workaround options.
Thanks again for the insights and information, much appreciated!
Hi @Anonymous ,
Have you tried the @OliverRodrigues 's video resource? I think it would be helpful in your scenario.
Currently, I could not reproduce your issue on my side. Have you referred to the response from the Schjoermann in the thread I provided above? I guess this issue may be related to limitation of lookup fields rendered as dropdowns in the portal.
I came to the conclusion that this is a limitation of lookup fields rendered as dropdowns in the portal.
The dropdown list will only show the first 5000 records.
So if you have 7500 records in the entity you are looking up, and you filter the list to only show 7. If the one you then select from the 7, is not part of the first 5000 in the original list you will get the above error.
I created a case for Microsoft on this issue, and they say that this is by design.
"On your side, please check if you have configured a LookUp field rendered as Dropdown within a Entity form on your current Web page, and the LookUp field have more than 5000 records.
If the issue still exists, please consider submit an assisted support ticket for further help through the following link:
https://powerapps.microsoft.com/en-us/support/pro
Regards,
Hi @v-xida-msft ,
I followed exactly what you suggested to disable the page validation. Unfortunately, the same problem persists...
take a look at this video: https://www.youtube.com/watch?v=F8QxoyOIzAc
it might help you indicating where the error is
------------
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.
Lucas001
60
Super User 2025 Season 1
Fubar
55
Super User 2025 Season 1
surya narayanan
35