This is my first time posting here so apologies if i am in the wrong place. I am extremely new to Power Automate as a Process Specialist and so is my company. I have a process that I am looking to completely overhaul with the use of Power Automate. I want to make sure the process is even viable before going down this path and if there are better options that perhaps I haven't considered.
We have a Project Capital forecasting file which 20+ Project managers are updating manually causing errors/duplicates and overwrites. We use teams and overall 0365 and i would like to propose the below process using PowAut.
Portfolio manager preps master file with each project, associated PMs have their projects filtered to their own worksheet within the workbooks including the templates to be filled out
Port. Man. drops master file into folder
Flow takes each worksheet & creates a separate excel file for each PM & is loaded into a new folder
PMs update their files & drop into a completed folder
Flow picks up the completed folder and merges all data into one master file to be used for various purposes.
I would love to get some feedback on feasibility, risks, issues, changes, considerations, etc?