cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Dropdown not show all values from Sharepoint list

Hello All,

 

I have a trouble with power apps form,

I have 2 list was created Receive balance and issuing

in issuing form on dropdown box not show all value  from receive balance list.

I try re-upload data on receive balance list but the result has been same.

anyone can help me to solved this trouble.

 

the issung form :

the form issungthe form issung

 

the new data no show in issuing form :

 

new data in list but not show in issung formnew data in list but not show in issung form

 

 

thanks & Regards

 

M.Fhadil

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Anonymous ,

 

OK, I just found there is a delegation error on the dropdown, what is the complete code of dropdown.Items property?

Since the number of items is 593, please try to increase the threshold of the Delegation to 2000 to see if the issue is fixed.

Snipaste_2020-06-05_15-24-48.png

Sik

View solution in original post

9 REPLIES 9
WarrenBelz
Super User
Super User

@Anonymous ,

What is the Items property of the gallery and how many records do you have in the list it is querying?

Anonymous
Not applicable

 I have 593 items in receiving balance list

The Query in dropdown items = Filter('Waste Input Balance',AreaTPS = DataCardValue2.Selected.Area_x0020_TPS && Status ="OPEN").uniquemanifest

Hi @Anonymous ,

 

The formula syntax looks perfect, the only confusion is about uniquemanifest, but the column is shown as NoManifest in your screenshot. Could that be the problem?

Except that, have you refreshed the sharepoint list data source in your App after entering a new entry? If you don't refresh the data source, the modification on the data source won't reflect on the app.

Hope this helps.

Sik

Anonymous
Not applicable

i was refresh the data source in Waste Input Balance list but the result has same. the data hasn't show in dropdown values.

i'm so frustating because i am newbie in power apps.

 

this is the screenshoot of the new data with unique manifest.

 
 
 
 

Hi @Anonymous,

 

Why are there two Waste Input Balance lists?

What I mean is to refresh the sharepoint list in PowerApps like this.

Snipaste_2020-06-05_13-58-20.png

Also, you can put Refresh('SP list') to App.OnStart property, then the sharepoint list connection will be refreshed when the app is opened.

Sik

 

Anonymous
Not applicable

Hi,  

 

this is the refresh that you mean
I did but the results remain the same

Hi @Anonymous ,

 

OK, I just found there is a delegation error on the dropdown, what is the complete code of dropdown.Items property?

Since the number of items is 593, please try to increase the threshold of the Delegation to 2000 to see if the issue is fixed.

Snipaste_2020-06-05_15-24-48.png

Sik

Anonymous
Not applicable

thanks 

 

this delegation increased has solve the problem,

but i have one more question how much the max value of the delegation ?

if more than 2000, whether this case will happen like this again ?

 

 

Hi @Anonymous 

 

Yes, the issue will happen again when the list has more than 2000 records.

The Maximum threshold is 2000.

Please share the code with delegation error to see if there is any workaround.

Sik

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,057)