SharePoint list to text file

[sallyDBA]

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!

[v-yiwenxie-msft · Accepted solution]

Hi @sallyDBA 

The CSV format can be saved as text in Onedrive.

You can try the flow below:

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.

[sallyDBA]

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

Thank you so much!

[sallyDBA]

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

[v-yiwenxie-msft · Accepted solution]

Hi @sallyDBA 

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.

[sallyDBA]

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