Join the Team Forms community
T
S
A
C
H
Hi,
So, we have already double tripple checked the particular column in our SharePoint Data Source and there is no typo or anything. We even removed it, repasted it, completely certain. And Remove Duplicates is turned on, but in the drop down there is still one duplicate.
How to fix this problem?
Best, Damon
Hi Damon,
The SharePoint data component will compare all columns when detecting duplicates. This means that even columns that are not used in the label property has an effect on a records uniqueness. To resolve you issue you can do the following:
Open the setting to your SharePoint data component and navigate to the data tab.
Expand the "Advanced" section and go to the Fields setting
Select only the columns you want to use. This controls what columns are stored in a response as well as what columns/fields are used when comparing duplicates.
PS: If you want to see a step-by-step guide on this, it is covered in our cascading drop downs video tutorial 🙂
Hi Damon,
The SharePoint data component will compare all columns when detecting duplicates. This means that even columns that are not used in the label property has an effect on a records uniqueness. To resolve you issue you can do the following:
Open the setting to your SharePoint data component and navigate to the data tab.
Expand the "Advanced" section and go to the Fields setting
Select only the columns you want to use. This controls what columns are stored in a response as well as what columns/fields are used when comparing duplicates.
PS: If you want to see a step-by-step guide on this, it is covered in our cascading drop downs video tutorial 🙂
Hi Erin,
thank you for your quick response. I should have mentioned that we are only querying one field only.
That's why we are so sure that there shouldn't be any duplicates when Remove Duplicates is checked.
to clarify even further, maybe this helps:
The list has 21 columns, the column field assigned is Company Name.
In SharePoint the column filter only shows 8 unique values. Which should mean that there aren't any typos or the like, right?
the SharePoint data component shows 9, one being a duplicate.
I just duplicated the list with only two columns, Company Name + Job Titles, I set up the SharePoint data component exactly the same way, with only the Company Name filed selected (in Fields under Advanced) and it works, 8 unique values.
Hi Damon,
Unfortunately, it's very hard for us to determine the exact issue without access to your environment. One thing you might be able provide to help us diagnose the issue is the following:
Create a SharePoint drop-down menu (or configure the existing one) to allow multiple. This is available under the data tab
Open the preview tab on the builder screen and select the duplicate options, this means you will see to items selected.
click the "{}" button on the left of the preview tab to get a code preview of the response.
Share the JSON data here in this thread using a code block
Seeing this information may help us diagnose the issue.
Another thing to check would be manually refreshing the data-source to see if that resolves the issue?
Hi Erin,
We had tried the manual data-source refresh before we contacted you here, so that didn't resolve it.
But looking at the JSON as you said showed us the problem. One of the Company Names has a traling space.
Problem solved, thank you!