Unanswered

Updating individual cells based on several sheets in SharePoint

(0) Share

Report

Posted on by Higgs

Hi All,

I wish to build a flow that will pull data from multiple sources (spreadsheets or sheets in a single excel file) and populate them in specific cells in a second spreadsheet.

I have been playing around with power automate for a while trying to get this to work and can't work it out.

Any help would be appreciated - I'm not sure if this is even possible.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Higgs

If you want to populate the value in specific cells in a second spreadsheet. You may try to use the Office script in Power Automate , you can refer to this:
javascript - Officescript how to set value in table cell (row/column) by row index - Stack Overflow

Run Office Scripts with Power Automate - Office Scripts | Microsoft Learn

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Higgs 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks Yueyun, @v-yueyun-msft

Would everything have to be in one spreadsheet or could I pull from multiple spreadsheets?

Cheers,

Connor

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Higgs

If you want to get the data from multiple spreadsheets in flow , you may need to use more than one "list rows present in a table" actions.

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No