How to move submitted image from Jotform to SharePoint document library

  • Profile Image
    clwmarshall
    Asked on June 11, 2021 at 04:06 PM

    Looking for method to move document to SharePoint library. I can get the image to copy to SharePoint library but does not load. I'm guessing has something to do with no extension at the end of the file.

    Tried .pdf, nothing.

    Can you please help?

    Thanks,

    Carrie1623442252_60c3c34cf3ba8_2021-06-11_1505

  • Profile Image
    Amin_N
    Answered on June 11, 2021 at 07:57 PM

    Hi there,

    Thanks for reaching out to us!

    Checking the only form under your account, I can see that it's an empty form with no fields nor submissions.

    May we please have the form URL? Also, can you please elaborate on your workflow and the method you're using to integrate with SharePoint?

    We would be so much grateful if you could just further elaborate and provide more information, so that we can better assist you.

  • Profile Image
    clwmarshall
    Answered on June 18, 2021 at 02:11 PM
    Thanks for your patience.
    Form URL: https://www.jotform.com/build/201636028899162
    The tests I attempted were the following items I located on Jotform forum.
    Tested – Shows up, but not accessible. Does not show extension
    * https://www.jotform.com/answers/2358500-how-to-upload-the-files-in-a-submission-to-sharepoint-through-power-automate
    Tested - Did not work:
    * https://www.jotform.com/answers/2357605-Jotform-file-upload-attachments-passed-to-Microsoft-SharePoint
    * https://www.jotform.com/blog/microsoft-flow-integration/
    * https://www.jotform.com/answers/2358500-How-to-Create-Uploaded-Files-from-Form-to-Sharepoint-through-Power-Automate
    Thank you,
    Carrie
    ...
  • Profile Image
    Amin_N
    Answered on June 18, 2021 at 03:37 PM

    Hi again,

    Kindly note that there's no build-in integration for PDF documents generated by Jotform to get transferred to SharePoint.

    What I can recommend is using the link below in the integration.

    https://www.jotform.com/server.php?action=getSubmissionPDF&sid={id}

    The {id} keyword automatically resolves to submissions ID, and the link starts downloading the submission associated PDF document when clicked.

    Please give it a try and let us know how it goes.

  • Profile Image
    clwmarshall
    Answered on June 18, 2021 at 03:44 PM
    File extensions can vary and not limited to .pdf. We are currently having individuals upload images. Also, the link provided below does not work.
    Thanks,
    Carrie
    ...
  • Profile Image
    Mike_G
    Answered on June 18, 2021 at 10:59 PM

    We would like to apologize for any inconvenience. May we ask that you clarify if what you are trying to do is move or send to Sharepoint the files that your respondents will upload on the form you linked in your last reply, please?

    If that is the case, may I suggest that you follow the instructions given by my colleague, EltonCris, on this ticket, please?

    The first step requires that you insert the value of the File Upload field on your form into a Form Calculation widget, which will get the complete filename of the file with the extension.

    1624070034_60cd57924c76a_zt210618_223049

    Result:

    1624070127_60cd57ef39d29_zt210618_223446

    You will then use the Form Calculate widget in Sharepoint when you create the link that will download the uploaded file on your form.

    Please give it a try and let us know if you need any further assistance.