Power Automate: Unable to Connect to the Jotform Connector

  • Profile Image
    brucereid
    Asked on October 02, 2020 at 12:03 PM

    I am getting this msg when trying to "login" to connect the jotform trigger. I am using the Starter (Free) plan to test ..

    1601654585_5f774f39dff45_

  • Profile Image
    Jimmy_D
    Answered on October 02, 2020 at 03:01 PM

    Our apologies for the inconvenience caused.

    I received the same error when I tried to connect to my Jotform account from MS Flow. I have raised this to our back-end team for further investigation.

    We will send you a message via this ticket once we have an update. 

    Thank you.

  • Profile Image
    onurince
    Answered on October 05, 2020 at 11:13 AM

    Sorry for the inconvenience. This issue has been resolved.

    Thanks for reporting.

    Please let us know if you have any questions.

  • Profile Image
    brucereid
    Answered on October 05, 2020 at 03:50 PM

    Ok, excellent.. This worked. I was able to connect jotform, and create a flow, and it populated my sharepoint item.

    How do I get the attachment from jotform to populate the attachments in the Sharepoint item?.. I did not see any capability to get the attachment from the Flow Trigger.

    Bruce

  • Profile Image
    Jimmy_D
    Answered on October 05, 2020 at 05:16 PM

    Hi,

    Kindly refer to the workaround suggested by my @EltonCris on this ticket.- https://www.jotform.com/answers/2358500

    Feel free to contact us if you need further assistance.

    Regards,

  • Profile Image
    brucereid
    Answered on October 07, 2020 at 11:27 AM

    I am getting an error at the Init Variable step.

    1602084344_5f7dddf8c3fae_


    1602084412_5f7dde3cc147c_

  • Profile Image
    Elton
    Answered on October 09, 2020 at 06:19 AM

    @brucereid

    I get the same error when the file upload field is empty. Try uploading a file when you make a test submission. Aside from that, the flow only works on a single file upload field for now. If this is the form you're trying to integrate with Sharepoint https://www.jotform.com/202744702698058, please turn off the multiple file upload option and try it again.

    Here's how:

    10092020_M1LQzQPUPv.png

    Please let us know how it goes.

  • Profile Image
    brucereid
    Answered on October 11, 2020 at 01:37 PM

     

    @eltonchris

    I just tried a single upload, with proper settings, and still failed, with "empty" in the expression step.

     

     

  • Profile Image
    brucereid
    Answered on October 11, 2020 at 01:51 PM

    here is the image..


    1602438680_5f8346189b81f_

  • Profile Image
    Elton
    Answered on October 11, 2020 at 07:16 PM

    Sorry, I got confused with the file upload settings on the card form. The following changes should fix it.

    1. Set the file upload limit to 1 in your file upload field. Example:
      chrome_cOg7AMF2Lw.png
    2. After that, edit your first flow and make sure the output format is set to Text, like this.

    chrome_7mFBHMexJf.png

    This worked for me on my test card form https://form.jotform.com/202847166371054

    chrome_qeNdYYnq5T.png

  • Profile Image
    brucereid
    Answered on December 07, 2020 at 05:17 PM

    Sorry, I am just getting back to this flow. I am having difficulty getting the proper uri for the next step in the process.

    The first HTTP request never gets the uri for the form, whether the submitted step is either text or html. If you view the output, there is never a uri to provide to the http step.

    1607379274_5fcea94a0da5a_

    1607379394_5fcea9c272135_

  • Profile Image
    brucereid
    Answered on December 07, 2020 at 05:34 PM

    the only thing that appears to be a uri is field 13. but that is the actual image.

    1607380415_5fceadbf790db_


    My goal is to have form submitted, and this flow starts and it captures all the fileds in the form, and saves the attachment all to a sharepoint list item.


    1607380483_5fceae03545ff_

  • Profile Image
    Elton
    Answered on December 07, 2020 at 07:13 PM

    We will check this and get back to you with updates.

  • Profile Image
    brucereid
    Answered on December 08, 2020 at 09:07 AM

    these are the Dynamic content available at the time

    1607436427_5fcf888b695fd_

    1607436453_5fcf88a579696_

  • Profile Image
    Jessica
    Answered on December 08, 2020 at 09:34 AM

    Hi brucereid, thank you for reaching back to us and provide screenshots.

    Please kindly allows us some time to check into this. We will notify you via this ticket as soon as possible.

  • Profile Image
    Elton
    Answered on December 08, 2020 at 03:20 PM

    @rucereid

    I'm also getting the same error as you get, though there's no problem with the uploaded file. I'll look around in the power automate community and see if I could find a solution. I'll get back to you later today.

    Thanks for your patience and understanding.

  • Profile Image
    Elton
    Answered on December 08, 2020 at 11:54 PM

    @brucereid

    Unfortunately, multiple file upload field doesn't seem to work with HTTP action anymore like it used to. I'm not sure which changes on power automate that is affecting this but there's still a workaround using a Single File Upload field which works fine.

    Example:

    12092020_QF47sOdnGy.png

    To switch your Multiple File Upload field to Single File Upload, here's how;

    1. Open the File Upload field properties

    2. Go to Multiple tab

    3. Turn OFF the Multiple Files option

    12092020_fOfigkOGY2.png

    Then in your Flow, make sure the single file upload field is selected/updated on HTTP action. Example:

    12092020_OqY2wVW464.png

    Finally, don't forget to check the has failed in the Initialize Variable.

    12092020_uyiXq9FcKC.png

    12092020_SRMAECRJ62.png

    Please make another test after that. This should work fine.

    Thanks for your patience and understanding.


  • Profile Image
    brucereid
    Answered on January 18, 2021 at 11:06 AM

    Ok, I am still getting errors on capturing the attachment file name correctly as shown here.

    1610985630_6005b09e41fee_


    But it seems to be getting the image uploaded.

    1610985726_6005b0fe210ae_


    It is creating the Sharepoint list item, but then fails on attaching that image. (see list image, far right, no attachment)

    1610985956_6005b1e487557_

    1610985830_6005b166a6ffa_

  • Profile Image
    brucereid
    Answered on January 18, 2021 at 11:35 AM

    ok, I GOT IT!!!! it now works correctly! -


    The steps in your description above worked fine..1610987633_6005b87146dbd_



    I ended up reapplying the various elements in the add attachment step, and it now works correctly.


    Thanks all for your persistence!