Solved

Data Lookup field in NWC display unique values from SharePoint List

  • 12 May 2022
  • 1 reply
  • 239 views

Badge +4

Any ideas on how to get a Data Lookup field in NWC display unique values? In the drop down below we would like to only see one option for Pershing Demo however we see multiple because the SharePoint list has multiple entries for that company.

 

23044iC4D5D9932D795950.png

 

icon

Best answer by jesse_mchargue 16 May 2022, 06:27

View original

1 reply

Userlevel 6
Badge +12

Hey @Andrew87 


 


As of now, this is not possible within Nintex Workflow Cloud forms. This is because the records that are within the dropdown are all records that match your query when connecting to your data source, which we cannot filter down to unique values of a given column.


 


I would suggest that you think about having a unique list for Companies that you would like your users to select from rather than the current list you are using or perhaps a different data point than the company name. 


 


There is an entry within User Voice that can be up-voted for this feature: https://nintex.uservoice.com/forums/430063-5-nintex-workflow-cloud/suggestions/41457745-there-is-not-currently-a-way-to-get-distinct-value


 


Hope this helps!

Reply