Gallery Filtering

[jed76]

Can anyone shed any light onto this. 

I have a collection which I wish to filter. I am sorting descending and within this I am filtering via a column called "task_type" and when this column is EQUAL to 4. I am also applying a second filter based on a dropdown box. The dropdown box itself is linked to a previous gallery, so its item is gallery.selected. Within this I have another column. 

So the filter is filtering via task_type 4 and dropdown.selectedtext."name of column in previous gallery".

All works absolutely fine, however the filter often duplicates a line or two in the gallery. So rather than showing the 1 unique line coming from the SP list and into the gallery, it then adds two or three duplicates of the same line again. This must be the filter as it happens a few seconds after it retrieves the main record? It's almost as though the filter is too slow?

Many thanks. 

[Gochix]

Hi @jed76 ,

Could we get some sample code how your gallery Items formula looks like?

Without a sample code this can't be properly troubleshot. 

[jed76]

Many thanks. It seems to be the collection which is getting duplicated lines from the source?

My filter code:

Sort(

Filter(
colGridData,
ProjectId=Dropdown8.SelectedText.ProjectId,
TaskType=4

),

ID,Descending)

[jed76]

Just viewed the collection (after a CLEARCOLLECT) and there's the main line and then two duplicates in the collection? Not all of the columns in the duplicates are populated though?

[Gochix]

Hi @jed76 ,

Doesn't look like you have any issues with your gallery Items formula.

Possibly clearcollect issue? 

Could you paste the code?