How do I filter data in Flow?

[willy30870]

Hello,

When a new file is created in my onedrive folder, I send the data in an excel table :

The name of the file - The folder where is located the file - The date of the day (this step works )

But in other flow, I would like to get this table and filter the folder 'nom du fichier' but I don't know the value of the folder...

How to filter the data without knowing the term to classify

Any help is appreciated.

[RezaDorrani]

Hi @willy30870 

If using filer you need to define what value for that column you need to filter on 

example

nom du dossier equals to client2

[willy30870]

If it's not possible with filter. Would you have another approach to propose ?

I want to get all the raw with the same name in the "nom du dossier" folder...

[RezaDorrani]

Hi @willy30870 

You mean you want all the rows with unique values in nom du dossier column

example : you want event1, event2 since these 2 are unqiue?

[willy30870]

Yes, I'm not sure but this is that I want (but I don't know the value in folder column, it's my variable): 

[RezaDorrani]

Hi @willy30870 

So first you will need the unique names of all your folders

then for each unique folder, you will have to filter the excel rows to get the data specific to that folder

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[willy30870]

Ok, but I have 1000 folder...it’s not possible to get this differently?

[willy30870]

I can test to build a column with all my folder in excel but can you show me how I can test each folder with my other table ?

[v-alzhan-msft · Accepted solution]

Hi @willy30870 ,

Please refer to link below and let me know if you could achieve your requirements according the link:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Send-automated-email-using-a-spreadsheet...

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.