Passing submission to an Excel Sheet in One Drive via Microsoft Flow fails intermittently

  • Profile Image
    JoshReagan
    Asked on December 19, 2019 at 02:23 AM

    Some of my Microsoft Flows (now called Power Automate) fail because the Jotform trigger fails to communicate to the Microsoft flow. The Flow (Power Automate) is supposed to add a row into a OneDrive for Business online excel file. It fails about 5 percent of the time and Microsoft Flow Runs don't even show it failing so Microsoft thinks it is a problem on the Jotform side. I have an open ticket with Microsoft on this issue. Help?



    This is a re-post of a comment on Jotform Now Available on Microsoft Power Automate

  • Profile Image
    KrisLei
    Answered on December 19, 2019 at 02:44 AM

    Hi,

    Thank you for contacting us.

    May I ask if you are showing any error message for the failed connection of Microsoft Flow on your form? If so, please provide us a screenshot of the error message you are showing for us to further assist you. 

    Please follow these steps to post your screenshot on our Forum Page as we are unable to access attached images on emails: How-to-Post-Screenshots-to-Our-Support-Forum

    Thank you. We will wait for your response.

  • Profile Image
    Mike_G
    Answered on December 19, 2019 at 03:08 PM

    To my understanding, you are trying to have the submissions made through your form passed over to the Excel Sheet that is saved in your One Drive via Microsoft Flow (Power Automate).

    Please allow us some time to check and reproduce the issue first. Then, we will try to come up with a solution to your concern. We will update you in this thread with our findings as soon as we have any.

  • Profile Image
    Mike_G
    Answered on December 22, 2019 at 02:54 PM

    We would like to apologize for any inconvenience.

    I was not able to reproduce the issue you have described when I tested it on my end.

    To my understanding, you have selected this option to insert form submissions to rows in Excel (OneDrive).

    1577043227zt12_57_201.png

    And you were able to also connect it successfully. The issue is that, intermittently, the data are not being passed to the Excel in OneDrive.

    During my test, I have also encountered a slight delay in my Runs.

    1577043503zt14_26_09.png

    But it still succeeded after a few minutes.

    1577044311zt14_51_36.png

    When you check the My Flows section on your Power Automate account, do you see the submissions not being passed to Excel (OneDrive) as "Running"?

    So far, all of my 5 test submissions went successfully to Excel (OneDrive).

    1577044414zt14_53_16.png

    Just to add, I have removed the Google Calendar and Notification in my flow and I have only connected my form with Excel (OneDrive) alone.

    1577044242zt14_47_18.png

  • Profile Image
    JoshReagan
    Answered on January 03, 2020 at 07:07 PM

    1578096358Parking Jotform Trigger Not Wo


    As you can see, some did not make it.

  • Profile Image
    roneet
    Answered on January 03, 2020 at 09:05 PM

    Are you referring to the submissions which are edited? Please confirm so that we can make a test submissions.

    Thanks.