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
Hi @tomh,
Thanks for updating and sharing.
Glad to hear that you have figured it out.
Best regards,
Mabel
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
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
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
@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
stampcoin
79
Michael E. Gernaey
70
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1