Answered

Storing Image from Sharpoint List as Base64 code in SQL

(0) Share

Report

Posted on by Khaston

I have a flow where I get Base64 code of a stored attachement in Sharepoint List. I store this Base 64 value in variable (as seen in the screenshot), and its the correct Base64 code of the image that works. I want to save the Base64 code in SQL Image type column so I can then work with it. But when I insert the variable with the base64 code into the "SQL insert row" the value of the variable changes. Does not matter if its png, jpg or PDF - it always change the code into something else, that does not work.

Dont anyone know why ?

Output of variable is different from output of "Inser row SQL", even tho its the same variable.

Thanks for help.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Khaston 55 on at

Like (0)

Report

Found the problem, The action "SQL insert row" automatically adds "Base64()" function to Image type columns (see screenshot below). So I had to open the action as a code and delete the automatcally added function so it not convert twice.

Was this reply helpful? Yes No
GuilhermeDoel 2 on at

Like (0)

Report

Hello, Khaston! How are you?

Can you please share your flow showing how do you get the base64 code from a image column from a sharepoint list?
I'm trying to do that for days and i can't do.

Thank you!

Was this reply helpful? Yes No