PowerApps Signature to Sharepoint List - Solved

[rockonron]

Hi Everyone,

I think I have come across a solution for the dreaded saving a signature to a SharePoint list.

Previously I had used two flows for this. the first one got the image data from PowerApps and sent an email to a shared mailbox, the second flow looked at that mailbox for new emails, sucked out the attachment and added it to SharePoint.

I always found this solution cumbersome and you had to mess around with mailbox permission etc.

However, this morning i decided to give this another go, and the solution I have now is 1 flow with only 2 steps to save a signature to a SharePoint list.

Ok here goes.

1. Add a button to your PowerApp and create a flow that is triggered by this.

2. In the flow Add an action to send an email and fill in the details as you normally 

The important part here is that you click on the attachment content field and select Ask from PowerApps.

3. Add another action to your flow underneath this one, this is the Add an attachment action for Sharepoint.

In this action select the necessary Sharepoint list and click on the ID field, again select "Ask in PowerApps"

In the File Content Field Select the "Sendanemail(V2)_AttachmentsContent" option from your dynamic content.

The To address can be to any real address you like.

4. Go back to PowerApps and complete your Flow parameters.

In this case, we want to pass the ID of the SharePoint item we are working with and the peninput1.image.

I use Text(Last('PPE Log').ID) after a submit form for the ID, this will get the last item added to my Sharepoint List, this is the item I want the signature to be attached to.

So my Button should now read something like this

Set(varsig,PenInput1.Image);

'PowerAppsH&S-SaveSignature'.Run(Text(Last('PPE Log').ID) ,varsig)

setting the variable varsig may not be necessary, just a habit of mine.

This is passing the ID of the Sharepoint item I want to attach my signature to and the image content of that signature.

Run through your app once and press the button, this will attach the signature correctly to the sharepoint list, but you will however receive an email, now here comes the clever bit 🙂 

Go back to your flow and delete the email step, this will leave you with two steps as below

Do not change anything else.

Test your app again and you will see that the signature attachment gets attached to the SharePoint item straight away, without any need for emails or permission on mailboxes or multiple flows etc.

I was so excited about this i wrote this post as soon as i came across the solution however it should be noted I have not stress tested this in any way, my concern is that some sort of permissions issue will come active when another user tries to use it. But so far for me it is working perfectly.

Hope this helps, i may try expanding this to camera control images as well.

[Anonymous]

What did the new code look like after you sent peninput to a variable? I'm having this exact issue right now.

[mobilismexico]

This still seems a little more complicated than I'd wish.

There should be a simpler way as a continuation of the following example:

Pen input control in Power Apps - Power Apps | Microsoft Docs

[sudosaurus]

@mobilismexico 

I have a similar solution - send me a message so I remember to dig it out for you.

Mine is working correctly - we are using it for staff to sign forms for getting replacement IT equipment.

Thanks,

Chris

[mobilismexico]

hi @sudosaurus ,

Here's the reminder. I would much appreciate you digging out your blocks and formulas to save images in Sharepoint Lists. I noticed that the column type is either Thumbnail or Hyperlink. I'm testing with both of them in the meantime.

Alejandro