How to insert Base64 data to SQL Server.

[DBTS7]

Hi,

I'm inserting the ID in simple string format from Power Automate but now I want to insert base64 ID value in SQL server.

I tried to write like this: 

but it is giving like: base64(abc.gmail.com) and not giving the expected base64 value.

What I'm doing wrong in this?

Thanks

[wskinnermctc · Accepted solution]

For expressions to work, you have to fill them in the expressions fx box where you get dynamic content. You can't just write the equation in the field like Excel.

My screenshot is just to show the expression box, none of the other things are relevant to SQL or base64().

Let me know if this helps,

[DBTS7]

Hi @wskinnermctc ,

Thanks for the reply,

When I'm not writing expression base64 then it is giving an option of mailid as shown below

But when I'm writing expression base64 then it is not giving an option of mailid as shown:

I only want to insert the mail id in base 64 value, how I'll achieve this?

Thanks

[wskinnermctc]

Yes, it is annoying when that happens. I think that is power automate trying to be helpful, but it is not. The value still exists, power automate is just not showing it to you. 

You will need to type it into the expression. 

The easiest way to do this for me is to put the value in a box like normal how you have it. Highlight everything in the box and copy and paste it into notepad or a word document.

In notepad you will have the value and it will have curly brackets {} around it and maybe even an @ symbol.

Either way, you need to hover over the value in Power Automate and it will display the value how it should be written in the expression. It won't have any curly brackets or @ symbols when you hover over it.

In the copied text of notepad, remove any curly brackets or anything to make it look exactly like how it displays when you hover over it in Power Automate. Make your text look the same as what is displayed when you hover over the value.

Then you paste that value into the expression and click OK.

You may need to delete the old value out of the box so that all is showing is the pink expression value.

That is a lot of explanation to say copy and paste it into the expression.

[DBTS7]

Hi @wskinnermctc , Thanks for thr reply,

But I did it like this:

First I'm taking the Mail ID in Compose 2 and then converting it to base64 in Compose 4 (expression:

base64(outputs('Compose_2'))

) and then calling that output when inserting in SQL.

It's working as expected now.

Thanks