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.
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...
Join us for the first ever Power Platform Online Conference!
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!