Blank responses from Jotform via PowerAutomate

Hi,

We are relying on the Jotform integration with PowerAutomate to get leads from our submissions in Jotform into Dynamics CRM. Unfortunately, every 10 or so submissions on the form https://form.jotform.com/212774882945066 will show up as blank in PowerAutomate:

{

    "headers": {

        "Connection": "close",

        "Accept": "*/*",

        "Host": "prod-241.westeurope.logic.azure.com",

        "Content-Length": "685",

        "Content-Type": "application/json"

    },

    "body": {

        "04 - Prenume": "",

        "05 - Nume de familie": "",

        "06 - Email": "",

        "07 - Telefon mobil": "",

        "08 - Status Academic": "",

        "09 - Clasa": "",

        "10 - An academic": "",

        "11 - Page Break": "\n",

        "14 - Page Break": "\n",

        "12 - 17:30 - 19:00": "",

        "13 - 19:00 - 20:30": "",

        "15 - 17:30 - 19:00": "",

        "16 - 19:00 - 20:30": "",

        "17 - 11.11.2021 17:30 URL": "",

        "18 - 11.11.2021 19:00 URL": "",

        "19 - 12.11.2021 17:30 URL": "",

        "20 - 12.11.2021 19:00 URL": "",

        "21 - 11.11.2021 17:30 GUID": "",

        "22 - 11.11.2021 19:00 GUID": "",

        "23 - 12.11.2021 17:30 GUID": "",

        "24 - 12.11.2021 19:00 GUID": "",

        "01 - Submission ID": "5113109195814687118",

        "02 - Form ID": "212774882945066",

        "03 - Form Title": "Conferinta Studentilor - 11-12 noiembrie 2021"

    }

}

When I go back to Jotform Submissions/Tables and Edit the entry, after the submission of the entry is done the syncronization works OK, though.

I hope you can assist me with this issues.

Hi there,

Thanks for reaching out to us!

I just cleared your forms cache. Please try to re-integrate the form if the problem still persists?

Let us know if you need further assistance.

Thanks for the quick reply. Do you mean I have to re-do the whole workflow in Power Automate? Why is that? Did clearing the cache change any of the form or field Ids?

Clearing cache is a general recommendation for all kinds of issues.

Yes, re-doing the workflow also might resolve this problem.

Let us know if the issue still persists.

Hi,

unfortunetaly, it didn't work. After spending a lot of time redoing the whole integration, I still am receiving blank responses. Received one just now.

Hello there,

Before we forward this to our back-end team, could you send let us know those submission IDs that are arriving blank with some screenshots of the blanks in Power Automate?

I have attached two screenshots in my previous message containing all the necessary data: form ID, submissionID, blank ("") details as answers to the questions etc.

Also, my initial message contained the actual code/json that was copied and pasted in.

Hi,

I can see there are blank in the submission.

I will escalate this to our backend team to investigate. Our apologies for the inconvenience caused.

Hello there,

We made some improvements on the code side. Could you please check your submissions in Power Automate and let us know if this issue persists?

Regards.

Hi! Thanks for the update! I will be on the lookout for sure but I can tell you right now that for the past 4 or 5 days no such blank submissions went through, so, it seems to be working.

Kind regards!