Duplication using Filter and Patch function

[Anonymous]

I am trying to use PowerApps to filter and patch a collection which is connected to a SharePoint Listing but I faced the error of duplication when there is null value in the columns of "Single line of text".

The image shows that if there is no null value in the columns which are "Single line of text" there would not be duplication.

However, if there is null value in one of the columns which are "Single line of text', there is duplication as shown in the image below.

There is also duplication of record with the same ID in the collection.

Below are the codes that I used to filter the data

ClearCollect(
    colGridData,
    Filter(
        ProjectListing,
            titleInput.Text
            in 'Initiative Name' 
            && (IsBlank(ValueDropDown.Selected) || IsEmpty(ValueDropDown.Selected) || 'Value Engineering'.Value = ValueDropDown.Selected.Value)
           )
    
);

[Ramole]

@Anonymous 
But stated here you getting an duplicate right?

[Ramole]

@Anonymous 

You're not getting a duplicate now correct ?

the other post we will go to it as it is different issue and post, one at time.  

[Ramole]

@Anonymous 

Just checking, do you need any help on this issue as we eliminated the record duplication?

I more than to assist if you need further assistance on this issue tag me 

[Anonymous]

Yes it still have duplicate if there is null value in the data when using gallery.

[Ramole]

@Anonymous 

Can you show me screenshot of the duplication, i am not talking the old duplication you have, add new record and show me an screenshot of the collection and search also as I have tested that code i have given you and is working perfect.

Also do not connect 2 post as we can only deal with what you have asked for help and each post is different 

[WarrenBelz]

@Anonymous ,

Firstly, the in Filter is not Delegable, so you are limited on the number of records you can search in to your Delegation limit (maximum 2,000). If you use the below

With(
   {
      wData:
      Filter(
         ProjectListing,
         (
            Len(ValueDropDown.Selected.Value = 0 ||  
            'Value Engineering'.Value = ValueDropDown.Selected.Value
         )
      )
   },
   ClearCollect(
      colGridData,
      Filter(
         wData,
         titleInput.Text in 'Initiative Name' && 
      )
   )
);

and set your Delegation limit in Advanced Settings to 2,000, the top filter (which is Delegable) will collect a maximum of 2,000 records for use by the bottom filter. You will not get a Delegation warning.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[WarrenBelz]

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps