K2 SmartForms[Using Sharepoint] - Dropdown list with unique values only

  • 30 October 2017
  • 1 reply
  • 66 views

Badge +6

I have a dropdown list in my form that is populated from a Smart Object (SP list) and filtered on a parent control. I only want to show unique values as it is currently returning duplicates.

Is there an easy way to do this in SmartForms?


1 reply

Userlevel 3
Badge +8

Dear,

 

As far as i know, there is no no-code way to achieve this.

but i might think of 2 options.

 

first is to restrict users somehow from entering duplicate values into the list itself... i am not really sure if users entering their data from the sharepoint list itself or a custom web part... either way you might wanna find a way to restrict them from entering duplicates.... to have no duplicate when you retrieve the data.

 

second way is to create a custom service broker and use it as data source... and inside that custom service broker your code will retrieve only distinct values.

 

Hope it helps..

Regards..

Reply