Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

The "formula-level error management" expiremental feature to delete distinct() values



I've got a form that is populated with entry cards, dropdown lists, dates. I've got a dropdown list that is populated with a distinct() formula*.


I wanted to be able to delete previously saved values from dropdowns or dates and leave them empty. For that i enabled the "Formula-level error management" feature in the app parameters. That works great, BUT, now when i save the form, the item of the distinct() dropdown list shown and saved in the SP list gets blanked out and the record deleted from the SP list.


Are you aware of something that would allow me to empty records of a dropdown or date AND retain the record of the distinct() dropdown ?

It's a list from a collection, made of ~6000 items, very convenient since you can search in it 🙂

Community Support
Community Support

Hi @dunnno,

Do you mean that you populate a dropdown with a collection using the Distinct() function?

Could you please tell me that how you set the Update property of the dropdown data card?


The Distinct() function could not delete the records from the SP list.

If you want to save the dropdown selected to a Text field, you should ensure the Update property as below:

Best Regards,



I populate my dropdown (combobox) list from a collection using a distinct() function (>6000 items, searchable)


The update property of the datacard is :



And in the EditForm, there still is that combobox with a datacard, the DefaultSelectedItems being :



My concern here is that i'm not able to delete a date from a date datacard if i don't enable the experimental feature described above. If i do that, i can delete that date BUT it'll delete the entry recorded in my SP list (which is from the combobox dropdown list populated from the distinct () function.

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,309)