Dropdown not show all values from Sharepoint list

[Anonymous]

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 issung

the new data no show in issuing form :

new data in list but not show in issung form

thanks & Regards

M.Fhadil

[WarrenBelz]

@Anonymous ,

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

[Anonymous]

 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

[v-siky-msft]

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]

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.

[v-siky-msft]

Hi @Anonymous,

Why are there two Waste Input Balance lists?

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

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]

Hi,  v-siky-msft

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

[v-siky-msft · Accepted solution]

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.

Sik

[Anonymous]

thanks v-siky-msft,

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 ?

[v-siky-msft]

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