Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Hk1eJRDj3lj9OZDu0jdOo3
Power Automate - Building Flows
Unanswered

Jotform Submission -->Flow-->Sharepoint List

Like (0) ShareShare
ReportReport
Posted on 26 Nov 2018 18:32:56 by 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

 

  • v-yamao-msft Profile Picture
    on 28 Nov 2018 at 08:53:42
    Re: Jotform Submission -->Flow-->Sharepoint List

    Hi @tomh,

     

    Thanks for updating and sharing.

    Glad to hear that you have figured it out.

     

    Best regards,

    Mabel

  • tomh Profile Picture
    159 on 26 Nov 2018 at 20:25:07
    Re: Jotform Submission -->Flow-->Sharepoint List

    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

     

  • tomh Profile Picture
    159 on 26 Nov 2018 at 19:31:47
    Re: Jotform Submission -->Flow-->Sharepoint List

    Flow Errors.PNG

  • ScottShearer Profile Picture
    25,223 Most Valuable Professional on 26 Nov 2018 at 19:25:55
    Re: Jotform Submission -->Flow-->Sharepoint List

    @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

  • tomh Profile Picture
    159 on 26 Nov 2018 at 19:12:42
    Re: Jotform Submission -->Flow-->Sharepoint List

    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

     

  • ScottShearer Profile Picture
    25,223 Most Valuable Professional on 26 Nov 2018 at 18:56:47
    Re: Jotform Submission -->Flow-->Sharepoint List

    @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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 79

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard
Loading started