if the Column3 value is 0 then remove all rows for that employee

[rohitkushwaha]

I need help to filter out gallery data where the value is 0 with condition that if the value is 0 for any employee then search if any other rows are present in galleries for that same employee and remove the data ( we can use emp ID to find other related columns of same employee).

For example:

For below table John and Kim have 0 value in Unallocated weeks/Unallocated days. Then remove both the data for John and Kim.
Note: If the Unallocated weeks is 0 then Unallocated days value will be 0, we can consider any one column)

Output:

[rohitkushwaha]

I think I didn't explain clearly, let me give you the detail.

So after using your code gallery is filtered and removed the data which have 0 and the related employees, This is done and working as expected.

Now I  have number of employees data in gallery (See below screenshot)

So now I'm filtering the data by Associate Name and employee ID to check the details about one specific employee but here after filtering we have multiple data for one employee and I have to filter only row which has minimum value in "Total weeks unallocated " column. (This minimum value I have to filter after searching one specific employee from right panel, otherwise I have to show all data in the gallery if the search text-input is empty.

For example, in below screenshot when I'm searching the employee by Name and emp ID, it shows 3 rows but I just have to show one row which has minimum value in "Total weeks unallocated" (which I've marked in green) I don't have to show 1st and 3rd row.

[WarrenBelz]

@rohitkushwaha ,

The code is grouping by 'Emp ID' so you should have only one record per employee which is why I suggested filtering that.

[rohitkushwaha]

When I tried it was showing only 1 data in gallery ( I didn’t even search the employee from right panel)

Also, will grouping show the minimum value (Total weeks unallocated) of all rows available after searching for specific employee? 

[WarrenBelz]

@rohitkushwaha ,

Yes assuming the grouping is inside the filter.

[rohitkushwaha]

@WarrenBelz 

In your modified code I changed to _Data1 (See below screenshot, I think you missed changing that part?)

I changed the column name as per my data in Filter section, but all data disappeared. (See below screenshot)

Filter(
            AddColumns(
                GroupBy(
                    Sort(
                        _Data2,
                        Unallocated
                    ),
                    "Emp_x0020_No",
                    "Grouped"
                ),
                "Weeks",
                First(Grouped).Unallocated,
                "Associate",
                First(Grouped).'Associate Name'
            ),
            Associate in txtAssocName
        )

Application Screenshot:

[rohitkushwaha]

@WarrenBelz 

I observed that the code is working fine without filter, and when I’m adding filter it’s filtering data as value blank in text input box because some rows have blank value as “Associate name”.

Is there anyway that textinput box don’t take blank as value?

[WarrenBelz]

@rohitkushwaha ,

I have fixed the mis-type in the original post. You can try

!IsBlank(Associate) && Associate in txtAssocName

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.

MVP (Business Applications)   Visit my blog Practical Power Apps