cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
yuriarciniegas
Level: Powered On

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
yuriarciniegas
Level: Powered On

Re: Help me cascading dropdown No muestra todos los datos

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
Level 10

Re: Help me cascading dropdown No muestra todos los datos

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

yuriarciniegas
Level: Powered On

Re: Help me cascading dropdown No muestra todos los datos

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,697)