PowerApps Exchange

Please login or click SIGN UP FOR FREE to create your PowerAppsUG account to join this user group.
Expand all | Collapse all

Capturing Signatures to Sharepoint

  • 1.  Capturing Signatures to Sharepoint

    Posted Apr 17, 2019 10:48 AM
    Hello all...

    I apologize up front if this has been discussed before, but I did some searching within the forum here and could not find anything specific about it.  I have a Powerapps application that captures drug box changeover responsibility.  It's a lot like a "chain of evidence" log, but only for our medics transferring drug boxes.

    First off, I capture all of the "numbers" that are associated with this transfer and then I want to capture both the "receiving person's" signature and the "giving person's" signature.  I've got the application written and have seen that some people can use Flow to capture this, but I want to keep this as simple as possible and would like to be able to write this directly to the Sharepoint list I created to capture the information.

    Originally I was writing directly to the Sharepoint list all of the other information besides signatures, but I've changed that to capture all of the info in a Collection and then capturing the signatures in their own Collection thinking that I could then combine them and write it all to the Sharepoint list.

    Has anybody captured signatures in Powerapps and written to Sharepoint list WITHOUT using FLOW or some other outside means?

    ------------------------------
    James Hale, Senior I/T Technician
    brad.hale@kcmo.org
    Kansas City MO
    816-300-8811

    ------------------------------


  • 2.  RE: Capturing Signatures to Sharepoint

    Posted Apr 19, 2019 01:14 AM
    Edited by Aadil Ganie Apr 19, 2019 01:15 AM
    Hi @James Hale,
    The only way I've found is sort of a hacked solution.

    1. You have capture the signature into an image in PowerApps (just set image property on image to PenInput)
    2. Then from PowerApps send an email with an attachment to a shared mailbox (e.g signatures@company.com with subject being the ID of record)
    3. Then have a flow monitor the shared mailbox, take the attached and upload to list item where subject matches ID.

    Cons:
    Flow only checks mailbox every 5 mins or so.
    It's a hacked solution but works, and also doesn't require any complicated funtions apart from sending the email.

    Let me know if you would like more info.

    ------------------------------
    Aadil Ganie
    Business Analyst: Office 365
    Dubai
    000000000
    ------------------------------



  • 3.  RE: Capturing Signatures to Sharepoint

    Posted Apr 19, 2019 10:28 AM
    Thank you Aadil for the response.

    However, I have seen the FLOW solution and do not want to add FLOW to my process.  If it can be saved as an attachment, then it should be able to saved to a SharePoint list directly as an image, or at least I would think so.  However, I need a solution that does NOT use FLOW to get the result.

    ------------------------------
    James Hale, Senior I/T Technician
    brad.hale@kcmo.org
    Kansas City MO
    816-300-8811
    816-674-2232
    ------------------------------



  • 4.  RE: Capturing Signatures to Sharepoint

    Posted Apr 19, 2019 12:56 PM
    Try adding a separate screen, not reachable by users, and on it inserting an editable form for the SharePoint list.  If you then click on the entire form (make sure no individual data cards appear to be selected, but the entire form instead), on the right, if the Properties tab is selected, you will see a link called Edit fields.  Click on this and a list of fields already selected for the form will appear.  If you don't see attachments, click at the top on + Add Fields.  All of the list fields, including SP generated ones, will appear.  Simply click the box next to Attachments, e.g., and then close the add fields.  Now Attachments will appear in the data cards.

    Set the default value of the data card you just added to be the captured signature image.  If you are adding records, change the displaymofe property of the form to New from Edit.

    I have not played with signatures: they may be like an image captured by a device camera, in which case they needed to be saved in a rich text SP column.  But I think an attachment should work for signatures.

    ------------------------------
    Larry Heimendinger
    larry@techevents.com
    Redmond WA
    ------------------------------



  • 5.  RE: Capturing Signatures to Sharepoint

    Silver Contributor
    Posted Apr 19, 2019 01:34 PM
    Having some SharePoint issues today, but will surely give this a try, nice workaround!

    ------------------------------
    Eric Sauve
    aka PowerDiver
    XRM Vision
    Montreal QC
    ------------------------------



  • 6.  RE: Capturing Signatures to Sharepoint

    Posted Apr 22, 2019 09:20 AM
    I have not found a way to make capturing an image in an pen input field and add the output as an attachment in an Attachments field to a SharePoint list item without the need to employ the flow described above. If there is a way to do so, please provide more details as I have not found a way to achieve that within a PowerApps form yet. What @Larry Heimendinger describes would be the ideal and most obvious way, but, to my knowledge, is not possible with current technology within PowerApps.


    ------------------------------
    Paul Van Beek
    Sr. Web Technical Analyst
    Pella IA
    641-621-3866
    ------------------------------



  • 7.  RE: Capturing Signatures to Sharepoint

    Posted Apr 22, 2019 11:39 AM
      |   view attached
    I did a very short test.  See if my results work for you.

    1. I inserted a text control for pen input.  In my previous response, I referred to a media camera control.
    2.  I added a button (for test purposes, there are other ways to accomplish this) and set its OnSelect to  Set(var,PenInput1.Image).
    3. I connected a SharePoint list which already had a rich text column and then added a form.
    4. On the default property for the datacard for that rich text field, I set the default value to var.

    When 
    I ran the app, squiggled something in the pen input control, a string of text appeared in the form.  It appears to be a blob file - see attachment.

    You can skip the variable altogether by setting the default value of the datacard to PenInput1.Image and get the same result.  I used the variable in order to view it, and it was indeed an image.

    I did not submit the form to see if it saved the pen input correctly, but (and I know it is dangerous to make assumptions) I am guessing it will save properly and be an image.  If not, then SharePoint may want its column to be a picture one set to picture type, not hyperlink.  Just didn't go that far.

    Otherwise, this appears to work as I had originally suggested.  If you find out that it doesn't please let me know.

    ------------------------------
    Larry Heimendinger
    larry@techevents.com
    Redmond WA
    ------------------------------



  • 8.  RE: Capturing Signatures to Sharepoint

    Posted Jul 30, 2019 12:17 PM
    Edited by Vitor Pereira Jul 30, 2019 12:19 PM
    Larry, it doesn't work. Fails with: "There was a problem saving your changes. The data source may be invalid.". Did anyone ever find a way to make this work without flow?






  • 9.  RE: Capturing Signatures to Sharepoint

    Posted Jul 31, 2019 10:14 AM
    Shane Young has a video that might be helpful: "Build a consent form with PowerApps using the Pen Input and send it as an email attachment"
    https://www.youtube.com/watch?v=ycPO7Y3Cyu0

    ------------------------------
    Lisa White
    Senior IT Specialist
    Herndon VA
    703-709-7172
    ------------------------------



  • 10.  RE: Capturing Signatures to Sharepoint

    Bronze Contributor
    Posted Jul 31, 2019 02:07 PM
    There is an even better video done by Paul and Ashlee Culmsee YouTube It even shows you how to add an attachment without needing a Form

    I successfully attach signatures to my SP list that are viewable when opened.  I took his process a put the signature into a document library first then get the file contents and attach to my list

    ------------------------------
    Mark Pearson
    National Operations Manager
    61409321547
    ------------------------------



  • 11.  RE: Capturing Signatures to Sharepoint

    Posted Jul 31, 2019 03:27 PM
    Edited by J.D. Montgomery Jul 31, 2019 04:11 PM

    Hello James,

    Try this,

    1. Add an image control.
    2. Set its Visible property to false to hide it from your users.
    3. Set its Image property to PenInput1.Image
    4. Set the value of your SP item equal to the Image controls Image property instead of PenInput.Image.


    ------------------------------
    J.D. Montgomery
    ------------------------------