Answered

Excel master sheet

Like (0) Share

Report

Posted on 4 Apr 2020 20:24:03 by 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.

All responses (9)

Answers (1)

Verified answer

ChristianAbata 8,947 Most Valuable Professional on 07 Apr 2020 at 12:10:43

Like (0)

Report

Re: Excel master sheet

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
Raffolution 12 on 07 Apr 2020 at 07:21:24

Like (0)

Report

Re: Excel master sheet

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

We can manually input the results into the keys cells
v-alzhan-msft on 07 Apr 2020 at 05:19:00

Like (0)

Report

Re: Excel master sheet

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.
ChristianAbata 8,947 Most Valuable Professional on 07 Apr 2020 at 00:09:18

Like (0)

Report

Re: Excel 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.
Raffolution 12 on 07 Apr 2020 at 00:05:31

Like (0)

Report

Re: Excel master sheet

Can i get the data to populate a excel table within the file and then PA extract the data to the master sheet?
ChristianAbata 8,947 Most Valuable Professional on 06 Apr 2020 at 23:59:16

Like (0)

Report

Re: Excel master sheet

@Raffolution unfurtunally you are using formulas to do that, and PA don't allow formules. Sorry you can't.
Raffolution 12 on 06 Apr 2020 at 21:57:41

Like (0)

Report

Re: Excel master sheet

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?
v-alzhan-msft on 06 Apr 2020 at 03:21:41

Like (0)

Report

Re: Excel master sheet

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.
ChristianAbata 8,947 Most Valuable Professional on 05 Apr 2020 at 13:52:09

Like (0)

Report

Re: Excel master sheet

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