cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mfrizky
Regular Visitor

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 @mfrizky ,

 

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

@mfrizky ,

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

 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 @mfrizky ,

 

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

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 @mfrizky,

 

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

 

Hi,  

 

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

Hi @mfrizky ,

 

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

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 @mfrizky 

 

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 Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,498)