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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to create a single...
Power Automate
Unanswered

How to create a single flow when a file is created in sub folders and return the data accordingly in the another excel tracker

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

In my flow, When the file is created in sub folder "September", the table named "September" is being updated in my excel sheet (all worksheet names have same table name). I have attached a flow for this as a reference. In this scenario, I need to create 12 flows for each sub folders.  How to modify a this flow into single flow, if the file is created in folder "2" which contains sub folders of 12 months folder, to identify exactly in which sub folder the file has been created and update the things in my excel sheet in that particular sub folder name table. 

 

For ex, I would just give details until folder 2 (/DSR joint forecast inpu/DSR inputs/2) and if the file is created in sub folder called "September" inside folder "2", I want to update the details in the excel sheet called "September" which has a table called "September".

 

In the present flow, I'm giving the table name where it needs to be updated. In this case I need to create 12 flows for 12 months. So how to create a single flow. 

 

Date operation select is been added to red the excel columns, and whenever a file is uploaded and it has Jan, Feb, March columns, then in my excel tacker file it returns the message as "Yes" in Jan, Feb, Mar columns. 

kiran1996_1-1667392616050.pngkiran1996_2-1667392625621.pngkiran1996_3-1667392636191.png

kiran1996_4-1667392667018.png

kiran1996_5-1667392681219.png

 

Categories:
I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 283

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard