web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / When a file is created...
Power Automate
Unanswered

When a file is created in subfolders, then update my excel sheet accordingly

(0) ShareShare
ReportReport
Posted on by

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. 

kiran1996_0-1664133263390.pngkiran1996_1-1664133269941.png

 

kiran1996_2-1664133278119.png

 

 

Categories:
I have the same question (0)
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @Anonymous  you could also create a single flow just for the library, which will trigger of file creation within any folder under that library.

  • Community Power Platform Member Profile Picture
    on at

    @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).  

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @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. 

  • Community Power Platform Member Profile Picture
    on at

    @annajhaveri 

    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?

     

    kiran1996_0-1666773546666.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard