Excel master sheet

[Raffolution]

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.

[ChristianAbata]

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

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

[v-alzhan-msft]

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.

[Raffolution]

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. 

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.

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

Hope this makes sense?

[ChristianAbata]

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

[Raffolution]

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

[ChristianAbata]

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.

[v-alzhan-msft]

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.

[Raffolution]

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

We can manually input the results into the keys cells

[ChristianAbata · Accepted solution]

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

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