I cannot remove selected items from many of my dropdown fields. I'm using SharePoint list as my data source.
1. Edit form
2. Click field with a previously saved value
3. Remove field item by using the "x" so no items are displayed
4. Save form
Expected: the record in SharePoint list no longer contains a value
Actual: the record in SharePoint list still contains a value. 😞
Dropdown fields that I'm using where this is not working: 1) Choice 2) Lookup 3) Person/Group (single item)
Dropdown fields that I'm using that do work: 1) Person/Group (multiple items)
I've seen others with similar issues, some had workarounds, however none are ideal. Is this really a bug? Seems like foundational functionality. If it is a bug, is there a way to view if this has been reported and see the status of a fix?
Solved! Go to Solution.
Just got a chance to read through your conversation. I'm going to poke my nose in, see if we can't spoil this sauce.
@LRVinNC, the first thing that jumps to my mind is "Formula-level error management". I apologize if something in what you wrote was already meaning to clarify that no such features are enabled. Otherwise, could you see if your working app is using this feature?
In my travels, that was what I found to be enhancing PowerApps null-setting capabilities for the most stubborn field types:
Hope this helps! If this isn't at play, I'm quite keen to learn what else you may have uncovered.
Check that the data card in your form is properly connected to the Sharepoint list and, most importantly that your Update attibute is set correctly. It will need to contain the name of the data card value field on your form which will contain the modified result. In this example, I am updating a Sharepoint field called StatusBudget. That field is connected to the data card dcPEBudget. Within that data card is the dropdown which is called dcvPEBudget. It is this field, dcvPEBudget, that must be listed in the Update attribute for the data card, dcPEBudget.
In addition to @LRVinNC's suggestion. I was reading your posting as though you might be wanting to set these columns to nothing. What clued me on to that was you said "Person/Group (Single Item)". The single item part made me think that perhaps you're trying to set a column back to nothing/blank by removing the item from the ComboBox selection.
If that is the case, that's not currently supported out of the box. In fact, it's quite difficult to do even without PowerApps. BUT, @joshnystrom did some great investigation work on this and there was a conversation in this recent posting.
So, if your need was to "clear out" one of these complex columns, then you might have a read over that article and see if that provides some additional thoughts for you.
I hope that is helpful.
Thanks for the quick responses.
@RandyHayes - You are correct that I am trying to remove values. I have no problem removing the value in SharePoint. I only have the issue in PowerApps and I need a solution that works in PowerApps. I will look into the link you shared, but ideally I am not looking for a workaround. It seems like this is a defect in PowerApps, but I don't know if it's been reported or how I can report it.
@LRVinNC - My Update property is set correctly. As stated above, this only occurs when I am trying to remove values. I am able to set a new value as long as there is an item selected. When the item is removed and no item is selected, it simply retains the last saved value.
I just tested and I AM able to remove values from my dropdowns and have them saved correctly in my SP list, so it is clearly not a bug. Can you post a screen shot of the relevant fields and attributes so we have a little more detail to work with?
How have you found to clear a value in SharePoint? The only way I've found is with QuickEdit. The default edit form on a list does not allow you to clear a value. As for the "bug" aspect of this. I believe if you take a search through the forum, you'll find a few postings on this issue with an acknowledgement from Microsoft on it. There are a slew of Ideas on this on the Ideas board. You're certainly welcome to go there and search for one you like and vote on it.
In the meantime, there are the workarounds.
@LRVinNC Are you able to clear out a person from a single person column? Or a lookup item? These are all assuming a column that does not allow multi selections. Ironically enough, you CAN clear all the values from a complex column that allows multi selections. I just ran my test on it again and it seems to still be an issue. Curious what you're seeing.
@RandyHayes I tested both with a single person column and a single-select choice field. Both allowed me to clear the value and updated SP to empty fields. I haven't tested with a lookup column as I will have to manufacture that scenario. The other two occur naturally in the app I'm currently working on so they were very easy to test.
@LRVinNC hmmm, I'm intrigued. I just did a little test on a list. Single select person column. Also a choice column. I was able to clear the choice column. But, the single select person, I was able to clear, but after the submit form, the value was back. All setup was out of the box. No alterations. Strange.
I created a new app & SharePoint list and did the same test, however after clearing the values in the form and submitting changes, both the Choice and Person fields went back. No changes to the data cards or field properties.
@RandyHayes Here's a bit of illustration, just FYI.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!