Recently I was working with CSV file for automation process. The files were stored in SharePoint Online document library. I thought with “Get File Content” action, I will be able to get the CSV file content directly. But the issue was it was giving me outcome in some other format:
Analysis:
When you use “Get File Content” action with SharePoint online, this actually pass you the connect in Base64 string. To see the actual content, we need to convert the content from Base64string to string.
Solution:
To convert the content, I used a compose and in value, I passed below expression:
base64tostring(outputs('Get_file_content')?['body']['$content'])
Using this, I was able to see actual content of the file:
