Unanswered

2 Signature Panels using varJSON

(0) Share

Report

Posted on by TrishH

Hi Guys,

My app has the requirement for multiple pen input sections for sign off of various forms.
I have one JSON set up that is connected with flow to send the image to a sharepoint library.

I've used the below, how can I capture a second one and save off to the sharepoint library in the same way?

Set(varJSON, JSON(PENINPUT.Image, JSONFormat.IncludeBinaryData));
Set(varJSON, Mid(varJSON, 24, Len(varJSON) - 24))

As in, can I use this same code with a different PENINPUT.Image name?

Categories:

Building Power Apps

varJSON question.JPG

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @TrishH ,
I do exactly what you describe with the customer and staff signatures on a permission form. I send them off in two separate Flows with parameters as to what they are are individually signed. Happy to elaborate further - form (from test site) below. The signatures displayed are from a SharePoint Library saved as you described. Happy to elaborate further.

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.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @TrishH ,
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.

Was this reply helpful? Yes No
a-ovbord on at

Like (0)

Report

Hi @TrishH,

If you found the info sent so far useful and you managed to solve your request, please update here and press on Accept as solution.

This will help future customers in finding the solution to the same issue.

Thank you,

Ovidiu Bordea

Was this reply helpful? Yes No
MilesB__RP 12 on at

Like (0)

Report

HI @WarrenBelz ,

Could you elaborate please? Powerapps code part of things more than anything else please.
I am setting varJson formula for peninput1, how to repeat that for peninput2?

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @MilesB__RP ,
I send the two signatures to separate files in a SharePoint document Library and store the path and file name in the SharePoint list and the list ID in the Library item metadata. The images you see on the screen are simply a Thumbnail fro,m the Library item. I use the Word connector to merge them into a document.

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.

Was this reply helpful? Yes No
MilesB__RP 12 on at

Like (0)

Report

When I begun writing this app I have used Word connector, but the cost of premium connector on per user basis is just not justifiable in a small business. It's way cheaper to cut down trees and stick to the paper as my boss would say.
I actually had an epiphany and resolved the issue using varJson and another variable called PenVar and succeeded in implementing 2 signatures in 1 form.
My last problem is, I can only display 1 image attachment no matter how i loop it. Any chance you're good with these too?

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@MilesB__RP ,
If you are talking about the Flow, I write them to a SharePoint Library and send the Path to the Flow, then have two actions of Get file content using path (one for each) and have the both contents to insert wherever needed.

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.

Was this reply helpful? Yes No
MilesB__RP 12 on at

Like (0)

Report

@WarrenBelz thanks Warren.
Is there any chance you could elaborate a bit more?
I have another thread on this specific issue on the forum here: https://powerusers.microsoft.com/t5/Building-Power-Apps/Get-attachments-returning-1-attachment-only/m-p/559168#M173124
perhaps you could shed a bit of light over there?

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @MilesB__RP ,
You are already getting one image - you just need a second action for the other one- see the flow below. This one goes to a HTML file (also below), but is is easier with the Word Template as you do not need to do the dataUri conversion.

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.

Was this reply helpful? Yes No