Answered

base64ToString function has unexpected character in the output

(0) Share

Report

Posted on by rbn_nue

Hi Folks,

I'm trying to get the contents of an html file attachment using the function base64ToString. It provides me the output but has a special character "�" between all characters as below:

When I tried decoding the same input content bytes from https://www.base64decode.org/ it provided me the accurate output. Could anyone help to get the right output from power automate?

Thank you.

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hello @rbn_nue ,
please use the following expression in a "Compose" action:

replace(outputs('Compose'),'�','')

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco
Verified answer

rbn_nue on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

I used below workaround to solve the issue:

Save this html document as new file in OneDrive.
Use get file content (OneDrive) to get the html content inside - this provided accurate output.
Delete the file afterwards.
Thank you.
rbn_nue on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MarconettiMarco ,

Thank you for the response. I had already tried this, it will only replace first occurrence of the character. Using apply to each did not make much difference as well. I used get file content (OneDrive) to solve the issue.

Thank you.