Microsoft Flow: sends data from Jotform to Excel, but the flow times out.

  • Profile Image
    susanr804
    Asked on June 10, 2020 at 05:08 PM

    Our organization just moved to 365. We are trying to figure out how to use Microsoft Power Automate. What we would like to have happen is having form responses go directly into an Excel file. We see there is one Flow built for Excel but also utilizes a Google Calendar. Our IT department will not let us use Google calendars or sheets. I have tried to remove the Google portions of the flow to no avail.

    Will you be working on more Flows using 365 platforms? It would be super helpful to our organization to have a Flow that will go directly into Outlook 365.

  • Profile Image
    BDAVID
    Answered on June 10, 2020 at 08:52 PM

    Hi, thank you for contacting us. Passing data from Jotform to Excel through Microsoft Flow does not require a connection with Google Calendar. Please check this video:

    https://player.vimeo.com/video/224162123 

    Hope that helps.

  • Profile Image
    susanr804
    Answered on June 11, 2020 at 12:39 PM

    Thanks! It was a huge help. The only problem is when adding the action in Excel, Insert Row is not an option. I selected Add a row into a table. When I test it, nothing seems to happen. It says it may take a few moments but it has been 15 minutes. 

  • Profile Image
    Richie_P
    Answered on June 11, 2020 at 01:38 PM

    May we know if you have submitted a test submission and then tested the flow?

    Unfortunately, I cannot connect with Excel however I did test with Google Sheets and it seems the flow is working.

    15918970611.png

    Kindly try to setup the flow again and let us know how it goes.

  • Profile Image
    susanr804
    Answered on June 11, 2020 at 03:56 PM

    The form is live and I could see new responses. The flow just times out.

  • Profile Image
    BDAVID
    Answered on June 11, 2020 at 05:38 PM

    Could you please share a screenshot of the flow configuration, and also the error? https://www.jotform.com/help/438-How-to-Post-Screenshots-to-Our-Support-Forum

  • Profile Image
    susanr804
    Answered on June 12, 2020 at 01:49 PM

    1591984124flow1.JPG



    1591984150flow2.JPG

  • Profile Image
    BDAVID
    Answered on June 12, 2020 at 04:02 PM

    Hi, I have tested it, and set it up pretty much the same way as you have set it up:

    1591991731configured.png

    Ran a few test submissions:

    1591991804sent.png

    Even updated the flow name, but it never timed out:

    1591992094timeout.png

    How long after saving the flow and receiving submissions did it time out?

  • Profile Image
    susanr804
    Answered on June 12, 2020 at 04:28 PM

    It timed out about 10 minutes after I started the test. I started to test the Flow at 15:15 and had an entry into Jotform at 15:16.

  • Profile Image
    BDAVID
    Answered on June 12, 2020 at 05:38 PM

    Let me forward this to our back-end team to check further. You will be updated here.