I have a powerapps form from sharepoint that is not showing the choices. I have other dropdowns in the form that doing look at the choices column that are working. The dropdown that I am having issues with suddenly work when I'm previewing the form in make.powerapps.com. I'm not sure how else to convey this issue or how to troubleshoot it. Has anyone else seen an issue like this?
Solved! Go to Solution.
Thank you for your response, but unfortunately I have repeatedly been doing this and to no avail.
The columns will just not reconnect.
Beyond frustrating !
I've been having the same issue too. I created a post about this, which appears to have dissapeared. Microsoft needs to look at this as it's a re-occuring issue.
Have got the same issue, have an App that has not had any changes and the Dropdown stopped working for no reason.
Have tried all of the above mentioned actions to try and none of them have resolved the problem.
When are Microsoft going to have a look at this issue.
We experiencing this frequently. Forms that have been working will just suddenly stop displaying drop down options or the person fields liked to our AD will not populate once the user types in 3 or more letters. The only way we have been able to get the form to work again is to open it in PowerApps, delete all affected data cards, then refresh the data source and then save and publish, then reopen the form in PowerApps, add back the data cards, and save/publish.
While this fixes the form, it doesn't prevent this from happening again and therefore is not an acceptable solution. The most frustrating part is that the data cards often have formulas that we need to re-add once the cards are added back to the form. Sometimes these are quite complex and take some time to recreate.
There's no warning/alert when this happens so we have to wait until a colleague tells us the form isn't working. If they need to use the form urgently, they can't, and so we have to resort to paper forms until we have a chance to fix and test the form.
@Henryed07 @JohannaM @Axford_Clare We have recently committed a fix for a timing issue where ComboBox controls that are searchable can be unhooked from their data when the dependent data source is refreshed (or removed and added again).
I'll re-post a mitigation that is currently recommended from this post: https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Sudden-appearance-of-red-x-s/m-p/371...
As we understand it, the issue may occur sometimes when the data source that a ComboBox control is bound to is either (a) refreshed, or (b) removed and then added again. The current advised mitigation that has seen success with customers is to perform the following actions after refreshing or removing/adding a data source:
This should allow the ComboBox controls to be correctly reconfigured to the correct values.
Also, if your ComboBox control contains only a small number of values, it is advised to disable IsSearchable since (a) this incurs a slight overhead when enabled, and (b) the issue of empty values only occurs when IsSearchable=true.
FYI--the fix is expected to be deployed to all production regions the week of October 21.
@DAVIDPOWELL A few questions:
@_Corey_Thanks for the reply.
The application worked fine and shared fine while on SharepointLists.
I switched the dropdowns to sql server source as shown below. Still worked fine on my machine.
Once I share and publish to others. Does not work on their machine. drodown or comboboxes….
If I just place a dropdown on the form with no FILTERING the published version can see the dropdown selections.
Once I add this to the Dropdown
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks