Unanswered

Parsing CSV to readable

(0) Share

Report

Posted on by Donzera

Hi folks,

I have a flow where is triggered when I receive an email with a specific file attached, this file is a CSV file, then it creates a file in SharePoint with all the data, so far at this point, when you open the file, all the data is readable.

The problem begins when I used the Get file content, which is getting my content, but the output is encoded and unreadable. Check below:

I tried to use a Compose with the following code

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

but it didn't work.

Not sure what I am missing. I am new to Power Automate and not sure if this is the correct way to do that.

Anyone can assist/help me?

Thanks! 🙂

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

aido 26 on at

Like (0)

Report
Hi, @Donzera could you try using the updated compose string below:

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

Looking forward to hearing how you go.

Was this reply helpful? Yes No
Donzera 50 on at

Like (0)

Report

Hi @aido

Just tried this one, and I got the same result.
Adding your suggestion:
After Run the flow.

Was this reply helpful? Yes No
aido 26 on at

Like (0)

Report
Hey @Donzera

Is it possible that the file is not plain text and cannot be directly converted to a string?

If that's the case, could you try converting the base64 encoded content to binary format using the `base64ToBinary` function, and then converting the binary data to a string using the `binaryToString` function:
binaryToString(base64ToBinary(body('Get_file_content')?['$content']))

If this does not work, we may need to inspect the file's content before converting it. I can provide you with a suggested script to accomplish this.

Was this reply helpful? Yes No