Retrieve data from single line of text from Sharepoint list and save it as CSV file

[truex]

Hello

I have a flow that registeres the responses from FORMS and saves it to Sharepoint LIST. When new items are automatically added, it also creates a CSV file in different location. I am trying to work it a little different so it only saved latest item added to the LIST as single CSV file. I do not want to have a full list exported as CSV file but new input as new file, and so on. 

Is this feasible in any way?

[ChristianAbata]

hi @truex  you can try using last expression over your array. Like This last('Your sharepoint list values')

[v-jefferni · Accepted solution]

Hi @truex ,

You can modify the very first flow which saves the responses to the list. But the premise is you need to save the current CSV table to a cloud service such as OneDrive for business or SharePoint library as the xlsx file. With the table in this file, you can delete the create CSV table in the flow and add another action "Add a row into a table" to save new responses.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[KvB1]

Would it be possible to create the CSV table based on the forms trigger rather than the sharepoint item?

That way you get the CSV holding the same info as the sharepoint item that is created with said trigger

[Ahammad_Riyaz]

Hi @truex ,

Hope you are feeling good.

As per the requirement you can follow up  these steps.

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.