Unanswered

Jotform Submission -->Flow-->Sharepoint List

(0) Share

Report

Posted on by tomh

159

Hello, I recently started using Jotform MS Flow Integration and have been able to successfully publish Jotform Submission fields to a Sharepoint list via flow. However, having one issuse relating to being able to post Hidden fields like 'Submission Date.' Other hidden fields like 'Form ID and Submission ID' are populating to the field dropdown selector for 'dynamic fields' but not Submission date. Is ther a way to manually input the retrevial of this field data in the input/output triggers or actions list?

Thanks!

Tom

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@tomh :

I haven't used JotForm, so I can't test possible solutions but I would like to make one suggestion. It is possible that the date string provided by JotForm doesn't look like a date to Flow so i isn't presented as an option.. You might try creating a string variable. Initialize or set the string variable using the formatDateTime expression and feed it the Submission Date from JotForm as the timestamp. Then reference the variable when you are populating the SharePoint list.

You might try similar techniques for other columns that you can't seem to reference.

Also, I am assuming that you have already clicked on "more" if you see it in Dynamic properties and the column you want to reference still doesn't show.

It's worth a try...

If this addresses your issue, please mark your post as Solved.

Scott

Was this reply helpful? Yes No
tomh 159 on at

Like (0)

Report

Scott, Thanks for your response on this. "You might try creating a string variable. Initialize or set the string variable using the formatDateTime expression and feed it the Submission Date from JotForm as the timestamp. Then reference the variable when you are populating the SharePoint list."
I'm not all that familiar with Flow...How exactly do you create a sting variable?

I did try and click "more" in the dynamic content dropdown and columns are not showing. I've used Zapier integration with Jotform and allows for numerous fields to be populated including multiple that are not visable on the form itself. Do you know if you can edit the input/output calls in the action? Also, Field Id's seem arbitrary...how are these being generated? From my experience the Field ID that is called has already been assigned by Jotform. Is flow renaming these ID's? Pardon all the questions I'm a newbee at flow.

Thanks!

Tom

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@tomh:

To create a variable, search on Variable when adding an action and you'll see the various variable options.

Can you post a screen shot of your Flow? That may help those who may be able to assist.

Scott

Was this reply helpful? Yes No
tomh 159 on at

Like (0)

Report

Was this reply helpful? Yes No
tomh 159 on at

Like (0)

Report

Scott, I was able to figure it out by creating a 'Condition' to populate a field if "X" was contained in another field.
Might be down and dirty but it worked!
Thanks.

Tom

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report

Hi @tomh,

Thanks for updating and sharing.

Glad to hear that you have figured it out.

Best regards,

Mabel

Was this reply helpful? Yes No