Assuming your CSV data doesn't contain any commas within the actual values, this is how I would build my flow.
In this example, I'm using the following CSV file.
See full flow below. I'll go into each of the actions.
Get file content using path retrieves the CSV file data.
Compose uses the following expression to extract out the actual data. You already have this expression - except I've wrapped a skip to remove the headers.
skip(split(base64ToString(outputs('Get_file_content_using_path')?['body']['$content']),decodeUriComponent('%0D%0A')), 1)
Filter array takes the output from Compose and uses the following expression to remove any empty rows (the last row will always be empty).
trim(item())
Select takes the output from Filter array and uses the following expressions to extract each of the values. Note that I'm using Text mode (see arrow on screenshot).
//Name
split(item(), ',')[0]
//Color
split(item(), ',')[1]
//Status
split(item(), ',')[2]
The output from the Select after running the flow is:
[
{
"Name": "Grant",
"Color": "Blue",
"Status": "Approved"
},
{
"Name": "Harry",
"Color": "Red",
"Status": "Pending"
},
{
"Name": "Helen",
"Color": "Pink",
"Status": "On Hold"
}
]
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
