You’re offline. This is a read only version of the page.
When a file is created (properties only), I want to design a flow that says, "Add a row into the table." I've copied the flow I made in the image below. This process only works when a file is generated in one of the subfolders provided. However, I want to design a same flow for various subfolders. For instance, the ID folder has 5 folders, and each of those 5 folders has 12 subfolders with the names of the months. Additionally, I have an excel file with many sheets labeled with the month names, each of which contains the same kind of table named with same sheet names.
For ex, I want to automatically update my Excel "Jan" Sheet and the table whenever a file is created in any folders (/1/Jan), as shown below. If the file is created in the folder (/2/Apr), I need a update in Apr sheet in excel and update name 2 in input received column.
As of now I only know to create a single flow for each folder and subfolders. But I want to create a single flow for folders “1-{12 month subfolders}", “2-{12 month subfolders}" and so on . So, I can design only five flows for 5 folders containing all 12 subfolders.
Please help me with this.
Hey,
What should I specify in the "Row" in my flow. As I'm giving "folder path" in the Table, it is not showing me the table headers to add an input. The folder path is identifying in which sub folder the file is created, but how do I specify the table headers to enter the input?
@Anonymous yes you will need to modify the flow in such a way that it only updates the worksheet for that folder in which file was uploaded, you can get folder path in the flow using which you can check which worksheet needs to be updated.
@annajhaveri But inside the library there are 12 sub folders, and whenever the file is uploaded in this sub folders (lets say one of the subfolder name as Jun), I need an update in another excel where worksheet names Jun is present. If I select library, then I get updates in all 12 worksheets not just in 1 worksheet (Jun).
@Anonymous you could also create a single flow just for the library, which will trigger of file creation within any folder under that library.
Share
Report
All responses (
Answers (
8,531
