Flow That When a Excel File is Created on Sharepoint Reads Through Column, Gets Necessary Rows and Creates New Excel File With These Rows

[augustomb]

Hello there!

I'm sorry if this sounds easy but I have searched for a while now and couldn't find an answer for it so I decided to ask for help in here.

Right now we have two sectors (let's say Sector A and Sector B) and when Sector A creates a new file and there's information that must be analyzed by Sector B, they must filter Sector A's excel file with those information, send it to sector B and then sector B must copy and paste the necessary rows in order to do their job.

So my manager decided it must now work in a specific way that sounds easy but I can't figure out how to do it, which is the following:

All the files will now be Stored in Sharepoint. There will be a Folder for Sector A and one folder for Sector B. When Sector A creates a new excel file, there will now be a new column in which they must point out with a "X" which information must go to Sector B. So when they drop this file in Sector A's folder, Flow must read through it, searching for the "X" in that column, then get those rows and create a new excel file in Sector B's folder, containing only the rows marked with an "X".

To clarify it, there's an simplified visualization bellow:

So when Sector A drops an excel file like this one on Sector A's folder on Sharepoint:

Name	Age	Interest	Must Go To Sector B
John	31	Soccer
Maria	18	Dancing	X
Edward	20	Music	X
Ashley	30	Baseball
Joanna	25	Arts	X

Flow must read through the column "Must Go to Sector B", get those rows with an "X" then create the following excel file on Sector B's folder

Name	Age	Interest	Action Taken	Client's Answer
Maria	18	Dancing
Edward	20	Music
Joanna	25	Arts

Thank you very much in advance!

[MIREK1983]

Hi

You need to make sure that the data will be marked in the sector A file in to a Excel Table.

If you use Excel connector you can filter the table rows with "X" to get the needed data.

The filtered data can then be passed in to a new excel file in to a new Table.

You can dynamically create the table and get the new Id of the table then pass the data into the table with Excel script or the Excel connector actions like add a row etc...

How to create in cloud a new excel file please check my post in the community:

https://powerusers.microsoft.com/t5/Building-Flows/HOW-TO-CREATE-EXCEL-WORKBOOK-IN-A-CLOUD-I-SHARE-M...

Hope this could help 😉

[augustomb]

Can you please give me more details about how can I filter the table rows with "X"? This is mainly where I'm struggling at right now.

Great post by the way (How to Create Excel Woorkbook in a Cloud), really helpful, thanks.

[MIREK1983]

Hi,

Please use the ODATA filter function like in my example 😉

In you case you need to write in the filter Column eq 'X' or Column eq 'x'

Hope this helps 😉