How to Convert Base64 Code to Text in Power Automate Desktop

(0) Share

Report

Posted on by CodyChrunos

This is an example of based64 code that I want to convert: Um9hciAtIEthdHkgUGVycnk

Categories:

Power Automate Desktop

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Verified answer

Deenuji_Loganathan_ 6,255 Moderator on at

Like (1)

Report
Copy link

Link copied!
@CodyChrunos

Method 1: Powershell
You can leverage powershell code for the conversion
Flow screenshot:

Powershell code:

$base64String = "%base64String%" $bytes = [System.Convert]::FromBase64String($base64String) $text = [System.Text.Encoding]::UTF8.GetString($bytes) Write-Output $text

Output:

Method 2:
You can leverage .Net code for the same:

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
CodyChrunos on at

Like (0)

Report
Copy link

Link copied!

Thank you. Just tried method one with error:
Exception calling "FromBase64String" with "1" argument(s): "Invalid length for a Base-64 char array or string."
At C:\Users\cody\AppData\Local\Temp\Robin\nvvlzsyla5x.tmp.ps1:2 char:1
+ $bytes = [System.Convert]::FromBase64String($base64String)
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : FormatException

Exception calling "GetString" with "1" argument(s): "Array cannot be null.
Parameter name: bytes"
At C:\Users\cody\AppData\Local\Temp\Robin\nvvlzsyla5x.tmp.ps1:3 char:1
+ $text = [System.Text.Encoding]::UTF8.GetString($bytes)
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : ArgumentNullException

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@CodyChrunos

Have you created set variable like below for base64string?

Please share screenshot of your flow pls?

Was this reply helpful? Yes No
CodyChrunos on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
CodyChrunos on at

Like (1)

Report
Copy link

Link copied!

I see. You added a "=". Thank you. It worked for me when I added a =

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (1)

Report
Copy link

Link copied!
@CodyChrunos _ glad to hear that 🙂

For future seekers - Please copy and paste the below code into your power automate desktop(keep anyone one method)

SET base64String TO $'''Um9hciAtIEthdHkgUGVycnk=''' @@copilotGeneratedAction: 'False' Scripting.RunPowershellScript.RunPowershellScript Script: $'''$base64String = \"%base64String%\" $bytes = [System.Convert]::FromBase64String($base64String) $text = [System.Text.Encoding]::UTF8.GetString($bytes) Write-Output $text''' ScriptOutput=> PowershellOutput Scripting.RunDotNetScript Imports: $'''System.Text''' Language: System.DotNetActionLanguageType.CSharp Script: $'''byte[] data = Convert.FromBase64String(base64String); base64String = Encoding.UTF8.GetString(data);''' @'name:base64String': base64String @'type:base64String': $'''String''' @'direction:base64String': $'''InOut''' @base64String=> base64String

How to copy/paste above code into power automate desktop?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
CodyChrunos on at

Like (0)

Report
Copy link

Link copied!

Sorry to bother you again. When the code is UGxheSBQcmV0ZW5kIC0gQWxleCBTYW1wc29u, it won't work. If somehow I remove the "=", it will work in this case.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!
@CodyChrunos

Please note: You don't require to add "=" in your base64string.

Please copy and paste the below code into your power automate desktop? - Please refer the below gif how to do that.

SET base64String TO $'''UGxheSBQcmV0ZW5kIC0gQWxleCBTYW1wc29u''' @@copilotGeneratedAction: 'False' Scripting.RunPowershellScript.RunPowershellScript Script: $'''$base64String = \"%base64String%\" $bytes = [System.Convert]::FromBase64String($base64String) $text = [System.Text.Encoding]::UTF8.GetString($bytes) Write-Output $text''' ScriptOutput=> PowershellOutput

How to copy/paste the above code into your power automate desktop?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@CodyChrunos

The first example which you shared earlier "Um9hciAtIEthdHkgUGVycnk" seems don't have any meaningful text, that's why its not returning anything or throwing error.

Then next one "UGxheSBQcmV0ZW5kIC0gQWxleCBTYW1wc29u" seems have some meaningful text so it returns "Play Pretend - Alex Sampson" as output.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
CodyChrunos on at

Like (1)

Report
Copy link

Link copied!
I use a loop to work this around:
SET base64String TO $'''U2hlJ3MgQ3JhenkgYnV0IFNoZSdzIE1pbmUgLSBBbGV4IFNwYXJyb3c=''' LOOP LoopIndex FROM 1 TO 4 STEP 1 @@copilotGeneratedAction: 'False' Scripting.RunPowershellScript.RunPowershellScript Script: $'''$base64String = \"%base64String%\" $bytes = [System.Convert]::FromBase64String($base64String) $text = [System.Text.Encoding]::UTF8.GetString($bytes) Write-Output $text''' ScriptOutput=> PowershellOutput IF IsEmpty(PowershellOutput) THEN SET base64String TO $'''%base64String%=''' ELSE EXIT LOOP END END Text.Trim Text: PowershellOutput TrimOption: Text.TrimOption.Both TrimmedText=> TrimmedText

Was this reply helpful? Yes No