Save signature to Sharepoint List Column then use in Flow

[ciprianpopovici]

Hello 

I have a powerapp form, and  need to save the signature (from pen input control) to sharepoint List , than later use this column from sharepoint in flow to populate a word document.

I manage to save Base64 image from powerapps to MultipleLine text field column in sharepoint , but i'm stuck at building the flow to populate image in word document.

Can anyone help me here, or should i put a post on powerautomate forum?

Thank you

[WarrenBelz]

Hi @ciprianpopovici ,

Create a jpg file in OneDrive using base64ToBinary from the text field content, get that file content and use it for the content of the Word merge field. One important issue - if you have only stripped the leading and trailing quotes (so you can see the image in Power Apps), this will not work - you need to strip the header as well with code like this (forget the flow at the end).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[WarrenBelz · Accepted solution]

Hi @ciprianpopovici ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[ciprianpopovici]

Hello, sorry for my late response , i made multiple  tests using your guide,(with different formats of base64 ) and i find that using the base64 in this format bellow , the flow it's working and it's creating my word template , that later it's converted to pdf.

I use this code in PowerApps on submit button to save signature:

Set(varBase64Pen1,
JSON(PenInput3.Image,JSONFormat.IncludeBinaryData)
);

and give the multiple line text column in Sharepoint (named base64), the value of this variable(varBasePen1).

Later i use this multiple line text field in my flow like in the picture.

Thank again for your help.

the format it's like this, with all the characters. 

"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAjcAAAELCAYAAAAleKflAAAAAXNSR0IArs4c6QAADJJJREFUeF7t1sENADAMArF2/6Gp1DFOzgYxPLjbdhwBAgQIECBAICJwjZtIkt4gQIAAAQIEvoBxowgECBAgQIBASsC4ScXpGQIECBAgQMC40QECBAgQIEAgJWDcpOL0DAECBAgQIGDc6AABAgQIECCQEjBuUnF6hgABAgQIEDBudIAAAQIECBBICRg3qTg9Q4AAAQIECBg3OkCAAAECBAikBIybVJyeIUCAAAECBIwbHSBAgAABAgRSAsZNKk7PECBAgAABAsaNDhAgQIAAAQIpAeMmFadnCBAgQIAAAeNGBwgQIECAAIGUgHGTitMzBAgQIECAgHGjAwQIECBAgEBKwLhJxekZAgQIECBAwLjRAQIECBAgQCAlYNyk4vQMAQIECBAgYNzoAAECBAgQIJASMG5ScXqGAAECBAgQMG50gAABAgQIEEgJGDepOD1DgAABAgQIGDc6QIAAAQIECKQEjJtUnJ4hQIAAAQIEjBsdIECAAAECBFICxk0qTs8QIECAAAECxo0OECBAgAABAikB4yYVp2cIECBAgAAB40YHCBAgQIAAgZSAcZOK0zMECBAgQICAcaMDBAgQIECAQErAuEnF6RkCBAgQIEDAuNEBAgQIECBAICVg3KTi9AwBAgQIECBg3OgAAQIECBAgkBIwblJxeoYAAQIECBAwbnSAAAECBAgQSAkYN6k4PUOAAAECBAgYNzpAgAABAgQIpASMm1ScniFAgAABAgSMGx0gQIAAAQIEUgLGTSpOzxAgQIAAAQLGjQ4QIECAAAECKQHjJhWnZwgQIECAAAHjRgcIECBAgACBlIBxk4rTMwQIECBAgIBxowMECBAgQIBASsC4ScXpGQIECBAgQMC40QECBAgQIEAgJWDcpOL0DAECBAgQIGDc6AABAgQIECCQEjBuUnF6hgABAgQIEDBudIAAAQIECBBICRg3qTg9Q4AAAQIECBg3OkCAAAECBAikBIybVJyeIUCAAAECBIwbHSBAgAABAgRSAsZNKk7PECBAgAABAsaNDhAgQIAAAQIpAeMmFadnCBAgQIAAAeNGBwgQIECAAIGUgHGTitMzBAgQIECAgHGjAwQIECBAgEBKwLhJxekZAgQIECBAwLjRAQIECBAgQCAlYNyk4vQMAQIECBAgYNzoAAECBAgQIJASMG5ScXqGAAECBAgQMG50gAABAgQIEEgJGDepOD1DgAABAgQIGDc6QIAAAQIECKQEjJtUnJ4hQIAAAQIEjBsdIECAAAECBFICxk0qTs8QIECAAAECxo0OECBAgAABAikB4yYVp2cIECBAgAAB40YHCBAgQIAAgZSAcZOK0zMECBAgQICAcaMDBAgQIECAQErAuEnF6RkCBAgQIEDAuNEBAgQIECBAICVg3KTi9AwBAgQIECBg3OgAAQIECBAgkBIwblJxeoYAAQIECBAwbnSAAAECBAgQSAkYN6k4PUOAAAECBAgYNzpAgAABAgQIpASMm1ScniFAgAABAgSMGx0gQIAAAQIEUgLGTSpOzxAgQIAAAQLGjQ4QIECAAAECKQHjJhWnZwgQIECAAAHjRgcIECBAgACBlIBxk4rTMwQIECBAgIBxowMECBAgQIBASsC4ScXpGQIECBAgQMC40QECBAgQIEAgJWDcpOL0DAECBAgQIGDc6AABAgQIECCQEjBuUnF6hgABAgQIEDBudIAAAQIECBBICRg3qTg9Q4AAAQIECBg3OkCAAAECBAikBIybVJyeIUCAAAECBIwbHSBAgAABAgRSAsZNKk7PECBAgAABAsaNDhAgQIAAAQIpAeMmFadnCBAgQIAAAeNGBwgQIECAAIGUgHGTitMzBAgQIECAgHGjAwQIECBAgEBKwLhJxekZAgQIECBAwLjRAQIECBAgQCAlYNyk4vQMAQIECBAgYNzoAAECBAgQIJASMG5ScXqGAAECBAgQMG50gAABAgQIEEgJGDepOD1DgAABAgQIGDc6QIAAAQIECKQEjJtUnJ4hQIAAAQIEjBsdIECAAAECBFICxk0qTs8QIECAAAECxo0OECBAgAABAikB4yYVp2cIECBAgAAB40YHCBAgQIAAgZSAcZOK0zMECBAgQICAcaMDBAgQIECAQErAuEnF6RkCBAgQIEDAuNEBAgQIECBAICVg3KTi9AwBAgQIECBg3OgAAQIECBAgkBIwblJxeoYAAQIECBAwbnSAAAECBAgQSAkYN6k4PUOAAAECBAgYNzpAgAABAgQIpASMm1ScniFAgAABAgSMGx0gQIAAAQIEUgLGTSpOzxAgQIAAAQLGjQ4QIECAAAECKQHjJhWnZwgQIECAAAHjRgcIECBAgACBlIBxk4rTMwQIECBAgIBxowMECBAgQIBASsC4ScXpGQIECBAgQMC40QECBAgQIEAgJWDcpOL0DAECBAgQIGDc6AABAgQIECCQEjBuUnF6hgABAgQIEDBudIAAAQIECBBICRg3qTg9Q4AAAQIECBg3OkCAAAECBAikBIybVJyeIUCAAAECBIwbHSBAgAABAgRSAsZNKk7PECBAgAABAsaNDhAgQIAAAQIpAeMmFadnCBAgQIAAAeNGBwgQIECAAIGUgHGTitMzBAgQIECAgHGjAwQIECBAgEBKwLhJxekZAgQIECBAwLjRAQIECBAgQCAlYNyk4vQMAQIECBAgYNzoAAECBAgQIJASMG5ScXqGAAECBAgQMG50gAABAgQIEEgJGDepOD1DgAABAgQIGDc6QIAAAQIECKQEjJtUnJ4hQIAAAQIEjBsdIECAAAECBFICxk0qTs8QIECAAAECxo0OECBAgAABAikB4yYVp2cIECBAgAAB40YHCBAgQIAAgZSAcZOK0zMECBAgQICAcaMDBAgQIECAQErAuEnF6RkCBAgQIEDAuNEBAgQIECBAICVg3KTi9AwBAgQIECBg3OgAAQIECBAgkBIwblJxeoYAAQIECBAwbnSAAAECBAgQSAkYN6k4PUOAAAECBAgYNzpAgAABAgQIpASMm1ScniFAgAABAgSMGx0gQIAAAQIEUgLGTSpOzxAgQIAAAQLGjQ4QIECAAAECKQHjJhWnZwgQIECAAAHjRgcIECBAgACBlIBxk4rTMwQIECBAgIBxowMECBAgQIBASsC4ScXpGQIECBAgQMC40QECBAgQIEAgJWDcpOL0DAECBAgQIGDc6AABAgQIECCQEjBuUnF6hgABAgQIEDBudIAAAQIECBBICRg3qTg9Q4AAAQIECBg3OkCAAAECBAikBIybVJyeIUCAAAECBIwbHSBAgAABAgRSAsZNKk7PECBAgAABAsaNDhAgQIAAAQIpAeMmFadnCBAgQIAAAeNGBwgQIECAAIGUgHGTitMzBAgQIECAgHGjAwQIECBAgEBKwLhJxekZAgQIECBAwLjRAQIECBAgQCAlYNyk4vQMAQIECBAgYNzoAAECBAgQIJASMG5ScXqGAAECBAgQMG50gAABAgQIEEgJGDepOD1DgAABAgQIGDc6QIAAAQIECKQEjJtUnJ4hQIAAAQIEjBsdIECAAAECBFICxk0qTs8QIECAAAECxo0OECBAgAABAikB4yYVp2cIECBAgAAB40YHCBAgQIAAgZSAcZOK0zMECBAgQICAcaMDBAgQIECAQErAuEnF6RkCBAgQIEDAuNEBAgQIECBAICVg3KTi9AwBAgQIECBg3OgAAQIECBAgkBIwblJxeoYAAQIECBAwbnSAAAECBAgQSAkYN6k4PUOAAAECBAgYNzpAgAABAgQIpASMm1ScniFAgAABAgSMGx0gQIAAAQIEUgLGTSpOzxAgQIAAAQLGjQ4QIECAAAECKQHjJhWnZwgQIECAAAHjRgcIECBAgACBlIBxk4rTMwQIECBAgIBxowMECBAgQIBASsC4ScXpGQIECBAgQMC40QECBAgQIEAgJWDcpOL0DAECBAgQIGDc6AABAgQIECCQEjBuUnF6hgABAgQIEDBudIAAAQIECBBICRg3qTg9Q4AAAQIECBg3OkCAAAECBAikBIybVJyeIUCAAAECBIwbHSBAgAABAgRSAsZNKk7PECBAgAABAsaNDhAgQIAAAQIpAeMmFadnCBAgQIAAAeNGBwgQIECAAIGUgHGTitMzBAgQIECAgHGjAwQIECBAgEBKwLhJxekZAgQIECBAwLjRAQIECBAgQCAlYNyk4vQMAQIECBAgYNzoAAECBAgQIJASMG5ScXqGAAECBAgQMG50gAABAgQIEEgJGDepOD1DgAABAgQIGDc6QIAAAQIECKQEHilpKRym80ReAAAAAElFTkSuQmCC"