Answered

Signature from PenInput into a PDF?

(0) Share

Report

Posted on by Smorley80

Hi everyone,

im stuck on creating a power automate flow that gets a new sharepoint item (name, date, signature etc) and converts it into a PDF.

I’ve got the conversion to PDF working fine using the Populate a word document / Convert a word document steps.

it’s the signature from the PowerApp penInput I can’t get!

I can see it as an image (thumbnail) in my SP list, but I just can’t get it to convert into a file that gets added to the PDF

HELP!

Surely there has to be a simple way.

so my flow is triggered : when a new Sharepoint item is created.

all Dynamic fields are fine.

help would be greatly appreciated

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (1)

Sort by

WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Smorley80 ,

You need to send JSON string of the pen input to the Flow, then (this is the important part), create a temporary jpg file in OneDrive using base64ToBinary from the JSON, get the Content of the temporary file, then use that content in your Word Merge Image control.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Smorley80 22 on at

Like (0)

Report
Copy link

Link copied!

Thanks @WarrenBelz
do you have step by step instructions?

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Smorley80 ,

I will not be on my PC for some time. If you have a go, I can correct any errors.

Was this reply helpful? Yes No
Smorley80 22 on at

Like (0)

Report
Copy link

Link copied!

Thanks @WarrenBelz
I've had a go and am even more confused.
I understand the logic of grabbing the 64 code then converting it to an image and then inserting that image into the flow. But I just cannot get it.
What do i set the SPO Column type to for the PenInput? Multiline text?
Then what do I use in the flow?
Here is my flow which runs successfully but nothing is appearing in the signature field in the PDF.
Please help!

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Smorley80 ,

My suggestion did not involve storing the value (as you had not asked about that and it is a separate topic), but you can store the JSON in a multi-line text column if you want to.

Please have a read of this section of my blog on SharePoint images, but instead of writing the file to SharePoint, send it to a (temporary) jpg file in OneDrive, then use the OneDrive function Get file content using path. You can then use the File Content of this directly in your Word Merge Image field.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Smorley80 22 on at

Like (0)

Report
Copy link

Link copied!

still no go sorry.
what am i missing?
I've followed your instructions
Ive added the expression like this:
base64ToBinary(triggerBody()[‘Createfile_FileContent’])
and also added the dynamic content as the above failed, and am getting this:
Unable to process template language expressions in action 'Create_file_2' inputs at line '0' and column '0': 'The template language expression 'base64ToBinary(triggerBody()['Createfile_SignatureImageLink'])' cannot be evaluated because property 'Createfile_SignatureImageLink' doesn't exist, available properties are '@odata.etag, ItemInternalId, ID, NAME, Surname, Name0, Conditions_x002f_Limitations, Contact_Number, Date, EPOA, SignatureImageLink, Modified, Created, Author, Author#Claims, Editor, Editor#Claims, {Identifier}, {IsFolder}, {Thumbnail}, {Link}, {Name}, {FilenameWithExtension}, {Path}, {FullPath}, {HasAttachments}, {VersionNumber}, {TriggerWindowStartToken}, {TriggerWindowEndToken}'.

What would you suggest be the best solution to this using the setup I have?
Obviously i'm missing something / a step somewhere

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Smorley80 ,

Please fully read step 3 (from the 6) from the blog. It will end up looking exactly like this in the OneDrive options

Was this reply helpful? Yes No
Smorley80 22 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz
Here is the error i am getting (attached).

I am using this as the JSON for the ONSELECT of my submit button:
Set(varPen, JSON(PenInput1.Image,JSONFormat.IncludeBinaryData));

The error in the flow:

'The template language expression 'base64ToBinary(triggerBody()['Createfile_FileContent'])' cannot be evaluated because property 'Createfile_FileContent' doesn't exist,

should i have something else in there besides 'CreateFile_FileContent'?

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Smorley80 ,

Mine is triggered by the Power Apps connector - yours is by SharePoint item creation

where are you getting the JSON from ? If a multi-line text field, you will need to apply the base64ToBinary to that field content.

Was this reply helpful? Yes No
Smorley80 22 on at

Like (0)

Report
Copy link

Link copied!

That's what i'm asking help on.
The peninput is writing to a SharePoint list column named SIGNATUREIMAGELINK and is displaying content in the SPO list like this (see attached).

Was this reply helpful? Yes No