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
Solved! Go to 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 ,
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 @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
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
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
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 ?
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
User | Count |
---|---|
261 | |
110 | |
98 | |
56 | |
40 |