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

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,372)