How to Get CSV File Content Stored in SharePoint Online Using Power Automate

Issue

Recently, I was working with a CSV file for an automation process. The files were stored in a SharePoint Online document library. I thought that with the “Get File Content” action, I would be able to get the CSV file content directly. But the issue was it was giving me an outcome in some other format.

Analysis

When you use the “Get File Content” action with SharePoint online, this actually passes you the connection in a Base64 string. To see the actual content, we need to convert the content from a Base64 string to a string.

Solution

To convert the content, I used a compose and in value, I passed the below expression.

base64ToString(outputs('Get_file_content')?['body']['$content'])

Using this, I was able to see the actual content of the file.