Hello! I am new (as of today) to working with Flow. I've managed to stumble through the beginning, but am having difficulities getting my flow to do what I want. These are the steps I want it to follow basically:
1. Manual trigger flow with button
2. List rows present in table
Apply to each
Any help or direction you could provide would be much appreciated!
As of now I'm able to create a new file with all data from the original table (Hours Worked Template). Now I need each seperate file to only show data for a specific supervisor (listed in the column, 'Supervisor'). Each new file name is listed as the supervisor so hopefully there's an easy way to filter.... Here is a screenshot of my flow so far.
Not sure I understood it correctly. Could you please explain? Meantime look into extending the ODATA filter supervisor if that's what you meant by.
Hi @abm ,
Here is a screenshot of the original report:
Supervisor is in column K. Basically I want a flow to create a new file that only shows the rows for that specific supervisor.
Ex: a file titled 'Amber Reseigh.xlsx' would only show rows 2-20, 'Kelly Taber.xlsx' would only show rows 21-24, 'Test Name.xlsx' would should row 25.
Does that help?
Thanks for the quick reply.
In your List rows present in a table step set the Filter Query as follows:
Supervisor eq 'Abmber Reseigh'
This way you can filter the relevant excel rows you want.
I have tried that in the filter query and it doesn't work. After running the flow, only one report was created (titled Amber Reseigh), but it was not an Excel file so it didn't work. The supervisor name is going to be different for each file so it has to be variable somehow...
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.