Unanswered

Dividing data into two sheets

(0) Share

Report

Posted on by sabeoleonunes

Hi All,
I want to create a flow wherein , i have created a flow wherein i import the excel data from localhost to SharePoint documents , but now what my agenda is the localhost excel file contains 6 columns , and when i import it to SharePoint documents the columns should be divided i.e 3 columns in Sheet 1 and 3 columns in sheet 2 but same excel file.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Yutao Huang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hello @sabeoleonunes ,

Wondering if you can give the new "Run script" action of the Excel Online (Business) connector a try. I think you should be able to write some script (in Excel Online) and run it against the workbook to:
Add a new sheet to that workbook
Move the three columns from Sheet 1 to Sheet 2

Here are a few links that might be helpful to learn more about this new "Run script" action of the Excel Online (Business) connector:
Announcing support for Office Scripts in the Excel Online (Business) connector
Run Office Scripts with Power Automate
Call scripts from a manual Power Automate flow
Pass data to scripts in an automatically-run Power Automate flow

And to learn more about Office Scripts in general:
https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel

Hope this helps!

Was this reply helpful? Yes No
sabeoleonunes 79 on at

Like (0)

Report
Copy link

Link copied!

Hi @Yutao
It's not possible to directly create a flow for that?

Was this reply helpful? Yes No
Yutao Huang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I think I'm just not sure if there is an easy way to move columns using the other actions in the Excel Online (Business) connector. Moving rows seems to be possible but that's not what we want here...

Although we can probably work around it by first reading rows from the source table and selectively writing data into another table (which has only three columns) on the second sheet. But not sure how we can remove the last three columns from the source table once we've copied out the data.

Anyone else have any suggestions?

Was this reply helpful? Yes No