cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
truex
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

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.

vjefferni_0-1647335177947.png

 

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.

 

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

4 REPLIES 4
ChristianAbata
Super User
Super User

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
v-jefferni
Community Support
Community Support

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.

vjefferni_0-1647335177947.png

 

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.

 

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
Solution Sage
Solution Sage

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
Super User
Super User

Hi @truex ,

 

Hope you are feeling good.

As per the requirement you can follow up  these steps.

Ahammad_Riyaz_0-1647335934807.png

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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,885)