Pen Input to Word Template as Image PNG or JPG format

(0) Share

Report

Posted on by NurSabrina24

165

Power Apps:

A form with pen input.

PenInput.Update: PenVar

OnSelect button:

Set( PenVar, JSON( PenInput1.Image,JSONFormat.IncludeBinaryData ) );
F12AcknowledgementLetterTriggerFlow.Run();

Power Automate:

Signature Expression: base64ToBinary(triggerBody()['PopulateaMicrosoftWordtemplate_Signature'])

Error: Action 'Populate_a_Microsoft_Word_template' failed

Error Details: Unable to process template language expressions in action 'Populate_a_Microsoft_Word_template' inputs at line '0' and column '0': 'The template language expression 'base64ToBinary(triggerBody()['PopulateaMicrosoftWordtemplate_Signature'])' cannot be evaluated because property 'PopulateaMicrosoftWordtemplate_Signature' cannot be selected. Please see https://aka.ms/logicexpressions for usage details.'.

I need to include image in a Word template. But, I keep on having the same error also for another expression in Signature:

dataUriToBinary(triggerBody()['PopulateaMicrosoftWordtemplate_Signature'])

replace(triggerBody()['PopulateaMicrosoftWordtemplate_Signature'], '""', '')

Or, if I add a substitute formula in flow run functions, like this:

F12AcknowledgementLetterTriggerFlow.Run(Substitute(JSON(PenInput1.Image, JSONFormat.IncludeBinaryData), """", ""));

got an error: Invalid number of arguments: Received 1, Expected 0.

Please help me on this, thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 155,320 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @NurSabrina24 ,

This blog of of mine shows the start of the process with the image.

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
NurSabrina24 165 on at

Like (0)

Report
Copy link

Link copied!

For the pen input column in sp list, what data type did you use? Is it multiple lines of text?

And for Power Automate, which I'll need to add a 'Create File' function, is it to create one sp list for the pen input image, or I can use the same sp list i used for form in Power Apps? because Power Apps form has another column other than pen input column.

Is it ok for me to exclude the galleryname.selected? because my button is after clicking submit button to run the power automate flow.

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

Like (0)

Report
Copy link

Link copied!

@NurSabrina24 ,

The JSON code in the blog simply converts the pen image to Base64 Text (the main point is that your JSON will not do the job), which is then converted back to Binary (Image) format in the Flow (which is also shown in the Blog). The rest of the blog is not relevant to what you are doing and the Flow parameters are whatever yours are now.

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
NurSabrina24 165 on at

Like (0)

Report
Copy link

Link copied!

where to get the yourfilenamebox.text, yeah?
and just to confirm, yourgalleryname.selected.id is not necessary unless I'm using data from a gallery, right?

and this too, column for pen input in sp list, you set the data type as what ya? I'll need to check on that one too.

Thank you.

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

Like (0)

Report
Copy link

Link copied!

@NurSabrina24 ,

I was simply pointing you at a process for the JSON format in Power Apps and the Flow. That is the only bit you need here.

Was this reply helpful? Yes No