Filter data from Excel file and export filter results in new file

[Tobias_S]

Hello community,

I have a flow to build but I am stuck with the filter.

Current situation:

- I receive data collected in Excel (data list is not converted as table but data is listed with titles over multiple columns).

- The overall list will be saved on my OneDrive.

This file lists the data like the following:

Name	Surname	Department	Function
Name A	Surname A	Development	Python Developer
Name B	Surname B	Project Management	Project Lead
Name C	Surname C	Development	Database Developer
Name D	Surname D	Controlling	Project Controller

Now I need to extract data out of this Excel file. For each department I need a list of rows matching this filter. These filter results needs to be saved as "department overview list" as separate files. Filtering with "ODATA"?

These (in example case three) lists might look like:

Development file

Name	Surname	Department	Function
Name A	Surname A	Development	Python Developer
Name C	Surname C	Development	Database Developer

Project Management file

Name	Surname	Department	Function
Name B	Surname B	Project Management	Project Lead

Controlling file

Name	Surname	Department	Function
Name B	Surname B	Project Management	Project Lead

Does someone have the needed hint how to get these files out of the overall list? Can this be done with Power Automate resp. Power Automate Desktop? I tried both but without success so far.

Thank you in advance for any help.

[tom_riha · Accepted solution]

Hello @Tobias_S ,

the data must be in a table if you want to filter it, you can follow @DamoBird365 solution on how to create the table in the Excel file.

Once it's in the table, you can use the 'List rows present in a table' with a Filter Query using the Department column, e.g.

Department eq 'Controlling'

[Tobias_S]

Hello Tom,

thank you for the link and your help.

Is it also possible to rename a column title of a defined table then? The problem is that the current title has a text wrap.

Greetings

[tom_riha · Accepted solution]

Hello @Tobias_S ,

you can name the table as you like, but the filtering column should be only a single word, otherwise the solution would be much more complicated.