cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yuriarciniegas
Frequent Visitor

Help me cascading dropdown No muestra todos los datos

Hi comunidad.

i´m having trouble with powerapps. i have 2 list in sharepoint, the first it´s called Regional, the second it´s called Hallazgos, in the list called Hallazgos i done the powerapps. the 2 list are related by the columns regional and municipio. When performing the powerapps IT does not show me all the records are 752. There are problems for being so bing the BD ?

 

What should i do?

 

Annex images

I appreciate your help

 

 

 

 

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Buenos dias v-siky-msft, modifique el limite de la columna en powerapps y funciona

 

Gracias por su ayuda

View solution in original post

2 REPLIES 2
v-siky-msft
Community Support
Community Support

Hi @yuriarciniegas ,

 

What is the type of Dropdown field? LookUp, Text or Choices?

Could you share the expression of your Dropdown ?

Do you want to show all 752 value in your dropdown list?

Is there the blue dot warning Delegation warning can be found in the formula?

 

Maybe the distinct function has been applied to dropdown, as you can see from screenshot, the same values are removed from the list, so that the value of list is much less than 752.

Just change the formula of item property of drop down to: Choices(listname.lookupfiedname)

 

Another cause maybe the non-delegation, you could increase the default non-delegable row limit from 500 to 2,000 (max size).

Please follow the steps to set it: file – App settings – Advanced settings – Data row limit for non-delegation queries.Annotation 2019-08-21 134648.png

 

Best regards,

Sik

Buenos dias v-siky-msft, modifique el limite de la columna en powerapps y funciona

 

Gracias por su ayuda

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,790)