Forum Discussion
lookup column filter
Hi, I want to 'Distinct' a lookup column from 'list2' in a list ('list1') form to avoid the repetitive data showing. I did this: made a dropdown/combobox/datacardvalue and use the code below: Dist...
Soheilsd , try a combobox and set the items to Distinct('list1',ColumnNameHere). This will create a single column table and the only column will be "Result"
If that isn't clear, try adding a button and set the OnSelect property to ClearCollect(col_Test,Distinct('list1',ColumnNameHere)) . This will allow you to preview your col_Test under View-> Collections and will show you the first five rows of the collection.
Please post a screenshot if you're able and need further assistance. It will help immensely in understanding what you're seeing.
