Hi @rogerlopez21
Yes its possible
see below flow for getting the idea on how to consider the/keep the required columns from csv file
Assume i have an input csv file like this:
And i need to keep only first 3 columns - A,B,C
see below flow (Flow can be manually triggered/scheduled flow depending upon your usecase)
Step 1: get file content of csv file
Step 2: use compose action to use function base64ToString over content property of output of Get File Content action.
Expression used: base64ToString(outputs('Get_file_content')?['body']?['$content'])
Step 3: use create csv table to create csv table with only required columns
expression used: skip(split(outputs('Compose'),decodeUriComponent('%0A')),1)
The above expression will split the content of csv by new line and then skip the first line as it contains headers.
in the below part, we will assign the required columns like below
Here the expression item() represents the item which is currently iterating through and split() function split it using , as delimiter and after splitting the first indexed element is the A column element.
Simmilary for other header i have written the expression like below:
Based on above logic you can write according to your requirement.
Now use create file to create a new csv file with updated data from Create CSV Table
Now see the result below after running the flow
Hope it helps !
