
Announcements
I have an sftp site site.com that has a folder 'LoadFiles' with the following files that appear daily:
TEST2023_06_06.csv
TEST2023__06_05.csv
TEST2023__06_04.csv.
The files have identical columns: A, B, C, D.
I have SharePoint list 'Testing' in a site.sharepoint.com with columns: A, B, C, D.
Can someone please help guide me to create a flow that copies the content of the csv files in 'LoadFiles' into my 'Testing' SharePoint list, mapping the columns and ensuring that after all the csv files have been loaded, only the file that comes in tomorrow get added to the list?
If they’re all attachments to the email, then I suggest how to get the file content data & load the data to a dataset like a SharePoint list in this post in my “CSV to Dataset” template thread