MS Flow: Edited submission is not updated in MS Flow data.

  • GerardHamel
    Asked on May 25, 2020 at 9:38 PM

    I know it is possible to return in a form that has been submitted and re edit the content again to submit the changes.  But It seem when the form is submitted a second time and more, the process that triggers the automated flow in Microsoft's Power Automate, only works on the first time (the initial submit) and not the others.

    I do an integration between JotForm and "Microsoft's Power Automate" to create an entry in a SharePoint list when a form is submitted. But I not able to capture changes that are made when people return in the JotForm form.

    it seems that the trigger that activates Power Automate work only for the first submit and not the others.  Is there a way to fix this problem?

    Gérard

  • Girish JotForm Support
    Replied on May 25, 2020 at 10:02 PM

    I understand that when the submission is edited, the changed entries are not reflected on MS Flow (earlier MS Power automate).

    As far as I can see, edited submissions should be triggered too.

    Could you let us know the form URL which you are trying to integrate?

    Also, was this working earlier on your form OR has this issue started only recently?

    Could you also share with us how you have set up the flow on MS flow so that we could try replicating the same at our end too?

    Additionally, could you try recreating the flow on MS flow to check if that solves.

  • GerardHamel
    Replied on May 25, 2020 at 10:24 PM

    Here's the JotForm form

    https://www.jotform.com/build/201035834642045

     

    Here's the code that trigger

    {

        "inputs":

            "host":

                "connection":

                    "name": "@parameters ($connections')[shared_jotform']['connectionId']"

                }

            },

            "body":

                "url": "ListCallbackUrl() "

                "Form_ID": "201035834642045"

                "format": [

                    "Text"

                ]

            },

            "path": "/webhook"

            "authentication": "@parameters ($authentication')"

        },

        "metadata":

            "flowSystemMetadata":

                "swaggerOperationId": "TriggerNewResponse"

            }

        }

    }

     

    And the code for Sharepoint

     

    {
        "inputs": {
            "host": {
                "connection": {
                    "name""@parameters('$connections')['shared_sharepointonline']['connectionId']"
                }
            },
            "method""post",
            "body": {
                "Title""@triggerBody()?['09 - Nom Complet']",
                "Submission_x0020_Date""@{utcNow(utcNow())}",
                "Nom_x0020_de_x0020_famille""@{triggerBody()?['08 - Nom de famille']}@{triggerBody()?['08 - Nom de famille']}",
                "Pr_x00e9_nom""@{triggerBody()?['07 - Prénom']}@{triggerBody()?['07 - Prénom']}",
                "Autre_x0020_pr_x00e9_nom""@triggerBody()?['11 - Autre prénom']",
                "Autre_x0020_nom_x0020_de_x0020_f""@triggerBody()?['12 - Autre nom de famille']",
                "Sexe""@triggerBody()?['14 - Sexe']",
                "Date_x0020_de_x0020_naissance""@triggerBody()?['15 - Date de naissance (AAAAMMJJ)']",
                "Permis_x0020_de_x0020_conduire_x""@triggerBody()?['16 - Permis de conduire SAAQ']",
                "Num_x00e9_ro_x0020_permis_x0020_""@triggerBody()?['17 - Numéro permis de conduire SAAQ']",
                "Nom_x0020_de_x0020_famille_x0020""@triggerBody()?['18 - Nom de famille de votre mère à la naissance']",
                "Langue_x0020_de_x0020_correspond""@triggerBody()?['19 - Langue de correspondance']",
                "Mode_x0020_de_x0020_correspondan""@triggerBody()?['20 - Mode de correspondance']",
                "Submission_x0020_ID""@triggerBody()?['01 - Submission ID']",
                "Courriel_x0020_de_x0020_Agence""@triggerBody()?['126 - Adresse courriel']"
            },
            "path""/datasets/@{encodeURIComponent(encodeURIComponent('https://xxxxxxxxx.sharepoint.com/sites/Gestiondespermis'))}/tables/@{encodeURIComponent(encodeURIComponent('bc2da10b-c276-468e-bbbb-b14235ea0a7b'))}/items",
            "authentication""@parameters('$authentication')"
        },
        "metadata": {
            "flowSystemMetadata": {
                "swaggerOperationId""PostItem"
            }
        }
    }
  • GerardHamel
    Replied on May 25, 2020 at 10:44 PM

    Here are the rest of the answers: 


    The integration with "Power automate" never worked more than on the first submit. 

    As you asked me I did recreate the work flow and it's always the same result it's working only on the first submit.


    Gérard

  • Jed_C
    Replied on May 25, 2020 at 11:57 PM

    Thanks for the information. We'll try to replicate it from our end and if we need more information, we'll get back with you on this ticket.

  • Jed_C
    Replied on May 26, 2020 at 10:02 AM

    I have now forwarded this to our L2. It seems that the reason behind this is that Jotform only has one trigger which is "When a response is Submitted" and the main function is for initial submission only.

    I've asked our L2 team to confirm if it's a lacking feature where to add a trigger for edited submissions or to fix if it's a bug.

    We'll let you know in this ticket once we have an update on this.

  • GerardHamel
    Replied on May 30, 2020 at 8:36 AM

    Hi

    What was working yesterday doesn't work anymore. Before the trigger was recognized on the first submit, today nothing, yet on my side nothing has changed, since my first post.

    Is it possible that you are intervening on this feature at this time.

    Gérard

  • Amin JotForm Support
    Replied on May 30, 2020 at 3:27 PM

    Hi again, @GerardHamel!

    This information has been successfully delivered to the case assigned developers. Once we hear back from them, we will instantly update you via this support ticket.

    Your patience and understanding are most appreciated.