Help adding jotform attached file to sharepoint list with flow

[Brianna]

Hi all!

I am currently using JotForm because of how easy it is to customize, but it seems the options in Power Automate are very limited. I currently have an approval flow that is triggered by a JotForm submission.

JotForm submitted > creates Sharepoint list > sends approvals > updates as needed.

The request we have set up requires files to be uploaded for the approval. I am looking to have those files attached to the Sharepoint list. Every time I try to attach them directly from JotForms I get an error, could there be a work around for this? Maybe create the file in a folder and then move it to the list? Would I be able to move that specific file to that specific line?

TYIA! 

[anupam8555]

Hi @Brianna ,

What kind of error are your receiving ? Can you post screenshot if possible ? 

Let me know. 

Thanks

Anupam

[breid · Accepted solution]

See this from Jotform .. I had same issue.  Turns out you can only have 1 attachment attached to JotForm, and must set params to accept only 1 file.

https://www.jotform.com/answers/2612213-power-automate-unable-to-connect-to-the-jotform-connector#19

This might help.

Bruce

[anupam8555]

Hi @breid , @Brianna ,

Please look at below jotform article. It shows way to upload single file and multiple file. I haven't tried ever JotForm but you can try and let me know if it doesn't work. 

Thanks

Anupam

(Please mark resolved/give kudos if it really helps you.)

[Brianna]

Edit.

I think I may have figured it out. I will reach out once I've had time to test. 

Thanks

[Brianna]

@anupam8555 @breid 

Thanks guys! The documentation that breid posted guided me in the right direction. It was not exact, but it helped to get me there. 

[bu11frogg]

I know this is 2+ years too late, but I needed to make this work (get multiple attachments from JotForm, including file names as supplied, and upload to a SharePoint List item as attachments).  Note that we are never getting 0 or just 1 attachment, so I have not tested for that possibility.

Contrary to JotForm Support's recommendation, the first step is to set the output to HTML (not Text).

Then create your a new SP list item or whatever you're doing with the text-based responses.

The last step is to iterate through the provided list of attachments and get the attachment Body and Name, then add each to the SP list item.  I did that like this:

The split Expression in the Apply to Each is taking the input from the "File Upload" attachment field in the JotForm.  When supplied using HTML, each attachment is separated by an HTML break <br> which is handy for splitting in the flow (you'll obviously have to substitute your own attachment field reference...that's the part with the square brackets):

split(triggerOutputs()?['body/08 - File Upload'],'<br>')

The ComposeFullURL is referenced by subsequent actions and is just the "Current Item" in the Apply to Each.

The image URL is pulled from the "full URL" via another split Expression:

split(outputs('ComposeFullURL'), '"')[1]

Then we have the HTTP calls as supplied by JotForm.  The first HTTP call uses the Compose Image URL for the URI field.  The final HTTP call is using the Compose getURL (JotForm Support opted for a variable, but Compose doesn't require an initiation action).  Don't forget to set the Compose getURL to run when the first HTTP action fails.  (How to upload the files in a submission to Sharepoint through Power Automate? (jotform.com))

To get the filename as supplied in the File Upload box, use another split Expression in a Compose:

split(outputs('ComposeFullURL'), '"')[5]

In the "Add attachment" action, just use the Compose Filename output for the File Name field, and the Body of the 2nd HTTP output as the File Content: