cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

SharePoint list to text file

Greetings!

 

           i created an @powerapp from @SharePoint_list and would like to save this list to @text file on @

OneDrive. This is Covid19 vaccination survey and i need SharePoint list in text format to move to OneDrive.

           This is a very simple text file format - something like 'EmployeeID', (some constant value=interger), date + 48 hours, date+12 months.

            yes - this is covid survey with vaccine dates - should look like this =   

123456,89,20120201,20131031

           please help me with @flow suggestions - i am using MS Templates but the best working was CSV format, but i need txt.

Thank you so much for your support!

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-yiwenxie-msft
Microsoft
Microsoft

Hi @Anonymous 

 

The CSV format can be saved as text in Onedrive.

 

You can try the flow below:

1.29-4.PNG

 

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yiwenxie-msft
Microsoft
Microsoft

Hi @Anonymous 

 

When the CSV table is saved as text file in OneDrive, it will automatically add comma between those value.

 

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-yiwenxie-msft
Microsoft
Microsoft

Hi @Anonymous 

 

The CSV format can be saved as text in Onedrive.

 

You can try the flow below:

1.29-4.PNG

 

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Fantastic! after wasting time watching a lot of YouTube video - this is The Best Way to get answers!

Thank you so much!

Anonymous
Not applicable

Kira - thank you so much for your Support. Would you happen to know how to put "commas" in between variables?

v-yiwenxie-msft
Microsoft
Microsoft

Hi @Anonymous 

 

When the CSV table is saved as text file in OneDrive, it will automatically add comma between those value.

 

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

When creating a TEXT file from SharePoint list in the Flow can we pass parameters = like date +12 month and some other constants?

 

Thank you for your support, Sally

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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,387)