Answered

Help me cascading dropdown No muestra todos los datos

(0) Share

Report

Posted on by yuriarciniegas

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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Best regards,
Sik

Was this reply helpful? Yes No
Verified answer

yuriarciniegas 46 on at

Like (0)

Report
Copy link

Link copied!

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

Gracias por su ayuda

Was this reply helpful? Yes No