Answered

Automatically Export CSV/ Excel from Sharepoint List When New Records are added

(0) Share

Report

Posted on by Community Power Pla...

Automatically Export CSV/ Excel from Sharepoint List When New Records are added

Hello I am looking for the way to automatically export the document as CSV when new record are added to the sharepoint list.

I have managed to create the flow that picks the FORMS responses and insert it into excel file (combined results from multiple submissions) as well as it creates a LIST entries at same time.

I am trying to figure out the way that when new submission is entered into FORMS, and once it is recorded in LIST, it automatically exports the submission as CSV to specific folder. I can manually do this so I assume it can be done anyhow.

I am looking to have this working this way: new record is added, new document is created (individual per entry, e.g. new employee is added, an employee dedicated document is created)

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Community Power Pla... on at

Like (0)

Report

I have added the action: SELECT so it picks the data from objects from LIST, followed by CREATE CSV TABLE and then, CREATE FILE.

What happens is that when I test it I get an error: The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft on at

Like (1)

Report

Hi @Anonymous

Do you want to create a csv file when a new item is created in sharepoint list?

I set up a flow, you can take a try with the following steps.

When a new item is created like below:

A new csv file will be created.

Hope the content above may help you.

Best Regards

If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you, it worked like a charm!

Was this reply helpful? Yes No