Odata - GroupBy Lookup Fİltering

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
Locked
bc101820
Posts: 5
Joined: Thu Jul 05, 2018

05 Jul 2018

Hello ,

I created a list with the name 'EgitimKatalogu' and in this list I have a Manage plumsail lookup field with name 'Gorev' which gets data from another list's field : pozisyon. But I have some repeating datas and I don't want that repetition. I tried to write odata with groupby but I didn't get the result I wanted. Your help is appreciated.

Thank you.
Attachments
Capture.PNG
Ss of my list and problem
Capture.PNG (23.27 KiB) Viewed 2261 times

User avatar
Nikita Kurguzov
Posts: 889
Joined: Mon Jul 03, 2017

05 Jul 2018

Dear bc101820,
The data will be repeating as every single item you see here is unique - it has a unique ID and from the point of view of SharePoint, it's different, even if many of them share the same Title. In order for these items to not repeat, you should have a list where these values do not repeat.
Cheers

bc101820
Posts: 5
Joined: Thu Jul 05, 2018

05 Jul 2018

Nikita Kurguzov wrote:
05 Jul 2018
Dear bc101820,
The data will be repeating as every single item you see here is unique - it has a unique ID and from the point of view of SharePoint, it's different, even if many of them share the same Title. In order for these items to not repeat, you should have a list where these values do not repeat.
Yes, I understand what you say but probably it is not possible for me to re-create the list because it includes many datas. Can't I just compare the value of the records' name and filter them ? I mean, if the data's name is already included, then don't add it my lookup again ?
Thank you.

User avatar
Nikita Kurguzov
Posts: 889
Joined: Mon Jul 03, 2017

05 Jul 2018

Dear bc101820,
Unfortunately, no, and for good reason - this will slow down the process of filtering immensely. You can filter by pretty much any field, or even number of fields, but imagine taking every single value available in the lookup and comparing it to the requested values, and the requests are made when you type something in or just scroll down the dropdown - that's quite often.

This should be possible with a default SharePoint Lookup field, since it retrieves all values to begin with, which you can then filter for uniqueness, but this is still not a great solution.
Cheers

bc101820
Posts: 5
Joined: Thu Jul 05, 2018

05 Jul 2018

Nikita Kurguzov wrote:
05 Jul 2018
Dear bc101820,
Unfortunately, no, and for good reason - this will slow down the process of filtering immensely. You can filter by pretty much any field, or even number of fields, but imagine taking every single value available in the lookup and comparing it to the requested values, and the requests are made when you type something in or just scroll down the dropdown - that's quite often.

This should be possible with a default SharePoint Lookup field, since it retrieves all values to begin with, which you can then filter for uniqueness, but this is still not a great solution.
Yes, now I exactly understand what you offer. I am going to create a new list without repetition.

Thank you so much for your help and time !

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 7 guests