Power Automate: Unable to Connect to the Jotform Connector

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 ..
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.
onurince

Jotform Developer

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.
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
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,
brucereid
Answered on October 07, 2020 at 11:27 AM

I am getting an error at the Init Variable step.
Elton

Jotform Support

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:
Please let us know how it goes.
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.
brucereid
Answered on October 11, 2020 at 01:51 PM

here is the image..
Elton

Jotform Support

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:
2. After that, edit your first flow and make sure the output format is set to Text, like this.
This worked for me on my test card form https://form.jotform.com/202847166371054
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.
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.

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.
Elton

Jotform Support

Answered on December 07, 2020 at 07:13 PM

We will check this and get back to you with updates.
brucereid
Answered on December 08, 2020 at 09:07 AM

these are the Dynamic content available at the time
Jessica

Jotform Support

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.
Elton

Jotform Support

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.
Elton

Jotform Support

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:
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
Then in your Flow, make sure the single file upload field is selected/updated on HTTP action. Example:
Finally, don't forget to check the has failed in the Initialize Variable.
Please make another test after that. This should work fine.
Thanks for your patience and understanding.
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.

But it seems to be getting the image uploaded.

It is creating the Sharepoint list item, but then fails on attaching that image. (see list image, far right, no attachment)
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..

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

Thanks all for your persistence!