cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Raffolution
Frequent Visitor

Excel master sheet

Hi Guys,

We have a excel template for specifying work needed to be done.

When compmlete/edit the template and then save a copy to a folder.

When this excel workbook is saved I would like flow to automatically extract a row of key data and insert a new row in our master spreadsheet.

Each excel file should be represented by a row in the master sheet.

If any data is changed in the excel files, the row should change accordingly.

Thank you.
1 ACCEPTED SOLUTION

Accepted Solutions

shure @Raffolution  see this is what you need to get values from one excel to other.

tabla.PNG

 

See my first excel has 2 columns Estado and Usuario and I'm copy all the valus in that tables to my other excel envios.xlsx with the columns Nombre and Detalle



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

9 REPLIES 9
ChristianAbata
Community Champion
Community Champion

hi @Raffolution the first part of what you need you can solved like this.

triger.PNG

 

For the last part if data changes, I suppose that you want to update the existing row. So you can use then Update a row action



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
v-alzhan-msft
Community Support
Community Support

Hi @Raffolution ,

 

Could you please share more details about the master table and the excel workbook table?

How would the new row created in the master table when the new excel workbook table created?

And how would the special updated in the master table when the excel workbook table is updated?

Please share the example about it so we could better understand you and provide the workaround.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

we have a excel template file called "specification template"

 

We populate cells G2 to G11 with site specific data and complete some tables below which automatically does some calculations and populates G12 to G15. 

 

Capture10.PNG

 

We then rename the file to the site name and save it as a excel workbook in a folder with a lot more files created from the same template.

We need the below sheet to automatically populate key data (G2 to G15) from these files.

 

Any changes to the source files needs to keep the mastersheet updated.

 

Capture11.PNG

 

 This sheet acts as a overview of all key data in the files saved in the folder.

 

Hope this makes sense?

@Raffolution  unfurtunally you are using formulas to do that, and PA don't allow formules. Sorry you can't.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Can i get the data to populate a excel table within the file and then PA extract the data to the master sheet?

shure @Raffolution  but if your mastersheet has formules is the same. Note that you need to use Power Automate a Table to add data inside, and if your table has formules you are going to receibe a error message with the words that I wrote, just PA don't support Formules.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Hi @Raffolution ,

 

I agree with @ChristianAbata 's idea that Microsoft flow could work with excel table contain Formulas.

And if you want to copy the table to the master table, the master table shouldn't have Formulas.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Can you show me the flow assumimg there are no formulas.

We can manually input the results into the keys cells

shure @Raffolution  see this is what you need to get values from one excel to other.

tabla.PNG

 

See my first excel has 2 columns Estado and Usuario and I'm copy all the valus in that tables to my other excel envios.xlsx with the columns Nombre and Detalle



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (1,577)