Export Filtered Gallery data to CSV using Filter Array without Using Json Method

[Aldous345]

Hi All,

        Please help me with this situation. I want to export my filtered gallery data to csv using PowerAutomate flow. I have watched Certain Youtube tutorials. They have used json function for this flow. But my Requirement I want to only Use Intialize Variable and Filter Array Concept.

     My sharepoint list name is excel data test  I have these columns:

      Id - Number

      Employee Name- Single line of text

      Email- Person or group

      JobTitle- Person or group

      Reporting manager- person or group

And I have added two dropdown named as JobTitlefilter and EmployeeNameFilter   Based on selection of values in Dropdown I want to display filtered data in gallery. If no value is selected in Dropdown it will show all items in gallery.

so I have used this code in EmployeeNamefilter dropdown in items property

I have used this code in JobTitlefilter dropdown in items property

In gallery items Property I have used this code:

If(
IsBlank(EmployeeNameFilter.Selected.Value) && IsBlank('JobTitle Filter'.Selected.Value),
'Excel data test',
Filter(
'Excel data test',
(IsBlank(EmployeeNameFilter.Selected.Value) || 'Employee Name' = EmployeeNameFilter.Selected.Value) &&
(IsBlank('JobTitle Filter'.Selected.Value) || JobTitle.DisplayName = 'JobTitle Filter'.Selected.Value)
)
)

In Export to Csv Button in Onselect Property I used this code

This is my Gallery Sample Output Page

This is my PowerAutomate Flow Steps:

Please Help me to Solve this Problem . In Powerapps If I select value in dropdown it shows only filtered values in gallery page. But After running the flow in Output Excel file   it shows All Items

Thanks and Regards

Aldous