create an excel table from a sharepoint create file

(0) Share

Report

Posted on by pasquale_p

Hi everyone,

I'm building a flow where,

1. create a sharepoint file (Crea File)

2. get content of file from adress (Ottieni contenuto file in base al percorso 2)

3. I need to create a table from this new file...how I can do?

thanks for your support

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

v-duann-msft on at

Like (0)

Report

Hi @pasquale_p

Thank you for posting.

According to your description, you would like to create table for created excel file. If anu misunderstanding, please kindly let me know.

The major action should be ‘create table’, you can configure it after delay action.

In 'table range', we should input the whole data boundary. If I input ‘A1:C3’, it means I have 3x3 sheet inside of excel. It depends.

In ‘column names’, we don’t need to input anything if you want to use the first row as header.

We can use create table as long as we already generate a excel file. Here is a video helping us learn about create table in excel using flow.
https://www.youtube.com/watch?v=WbJHq2cTq4U

Hope the content above may help you.

Best regards,
Anna

Was this reply helpful? Yes No
pasquale_p 87 on at

Like (0)

Report

Ho @v-duann-msft,
Thanks for your support,

Yes right, in the same flow I've to copy an excel file than create on copied file a table
Should I put a delay of 5 minutes?
I hope it's clear

Thanks for your support

Was this reply helpful? Yes No
v-duann-msft on at

Like (1)

Report

Hi @pasquale_p

Thank you for your quick update.

Yes, we'd better add delay action because it takes time to copy/create a file. Otherwise, the data can't be copied entirely.

Thanks
Anna

Was this reply helpful? Yes No
pasquale_p 87 on at

Like (0)

Report

Hi @v-duann-msft unfortunately the delay not solve the issue

Was this reply helpful? Yes No
pasquale_p 87 on at

Like (0)

Report

anyone could help me?

Was this reply helpful? Yes No