Unanswered

Create the content of the excel file stored in the document folder of share point in the custom lis

(0) Share

Report

Posted on by mtakeuch115

I have a question about how to create a flow that runs on the share point of Office 365.
Please tell me how to create some functions or sample.
I would like to create a flow to do the following operation on the share point.

· Create the content of the excel file stored in the specified document folder of share point in the custom list

· The file name is "yyyymmdd_ file name.xlsx"
· Excel file consists of multiple tables.
There is one row of data and a multi-row table
The rename of the file is OK.
If you need other office products, others, please tell me that together.

Sorry to trouble you, but please teach.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @mtakeuch115,

Where does your Excel file store? A SharePoint libirary or a SharePoint list?

Do you want to create the content for the specific excel file stored in a SharePoint library? Or create a Excel file within a SharePoint library firstly, then create multiple tables within it and add rows into them?

Further, could you please share more details about your scenario?

If you want to create the content for the specific Excel file (consists of multiple tables) stored in a SharePoint library, I think the "Add a row into a table" action of Excel Online (Business) connector could achieve your needs.

If you want to create a Excel file within a SharePoint library firstly using Microsoft Flow, then create multiple tables within it and add rows into them, I afraid that there is no way to achieve your needs in Microsoft Flow currently. If you want to use these actions of Excel Online (Business) connector to create tables within your Excel file or add rows into them, you must make sure that the Excel file has been existed in your SharePoint library. We could not specify the Excel file of your SharePoint library via File Identifier Dynamic content within Excel Online (Business) connector of Microsoft Flow currently.

More details about Excel Online (Business) connector, please check the following article:

Excel Online (Business) connector

Best regards,

Kris

Was this reply helpful? Yes No
mtakeuch115 2 on at

Like (0)

Report
Copy link

Link copied!

thank you!
Where does your Excel file store? A SharePoint libirary or a SharePoint list?
>SharePoint libirary
FLOW
①create a Excel file in SharePoint libirary
↓
②create SharePoint list from excel data table（①：excel file）

Was this reply helpful? Yes No