CSV Data Parsing and SharePoint Integration
Budget: $30 – $250 AUD
I have an updated csv of shipping schedules emailed to me several times a day. The csv is always in the same format, just with different data or updated data. I want to take this csv when it arrives (by sender/subject) have it altered so it only displays relevant data, then saved into a Share Point folder.
The csv has 21 columns, of which we require only 7 of them. The csv will need to be filtered by one column, where there is one of two possible matches. Once this is done it will leave another column with possible duplicates, all of the duplicates will need to be removed (this could be done before or after filtering).
From there, if possible, some columns will need to be shifted around and some date columns will need to be reformatted from YYYYMMDD HHMM to DD/MM/YYYY HHMM.
Ideally the csv will be saved into Share Point as an excel sheet.
I can setup a power automate script to take a file from an email and drop it into a Share Point folder, but need assistance with the parsing of the csv.
The csv has 21 columns, of which we require only 7 of them. The csv will need to be filtered by one column, where there is one of two possible matches. Once this is done it will leave another column with possible duplicates, all of the duplicates will need to be removed (this could be done before or after filtering).
From there, if possible, some columns will need to be shifted around and some date columns will need to be reformatted from YYYYMMDD HHMM to DD/MM/YYYY HHMM.
Ideally the csv will be saved into Share Point as an excel sheet.
I can setup a power automate script to take a file from an email and drop it into a Share Point folder, but need assistance with the parsing of the csv.
Related categories:
PHP
JavaScript
Data Processing
Excel
Sharepoint
Data Analysis
Data Integration
Power Automate