(REQUEST) Format the body of Microsoft Flow input

  • grymca
    Asked on June 5, 2020 at 4:36 PM

    Currently our flow receives an input schema similar to:

    {
      "01 - Date of Expense:": "2020-06-03T00:00:00+00:00",
      "02 - Mileage:": "45",
    }
     
    Because of the "01 " part of the string, every time we make a small change to the form, it breaks every single link to the following fields.
     
    This causes a huge headache for developers using Flow, as every addition or removal of a field means having to correct several variables (in my case- like 40-50 for editing something on the first page)
     
    I was hoping we could amend this format to:
     
    {
      "Date of Expense:": "2020-06-03T00:00:00+00:00",
      "Mileage:": "45",
    }
     
    Or use the 'unique name' I see in the properties of each field. By doing this, the order of the fields wouldn't matter, and we could safely edit our forms without the fear of links breaking on the back-end!
     
    I really appreciate your time, and have been having a great time moving old company forms onto this well-thought-out application!
  • Girish JotForm Support
    Replied on June 5, 2020 at 9:21 PM

    I understand that you are using MS Flow to integrate some application with your form.

    Could you let us know for which application are you using Microsoft Flow to integrate with JotForm? 

    Additionally, these flow schema are created within MS Flow. So as far as I can see, then changes need to be done on MS Flow itself. But please do let us know the application as requested above, so that we could check if there is a direct integration with JotForm.

  • grymca
    Replied on June 7, 2020 at 11:02 PM

    We are taking the Jotform data and using it to create an automatic approval process.

    It's not the flow schema, it's the schema for the JSON output that is sent to flow, from Jotform. This tells me the JSON is compiled on Jotform's end and sent to Flow. Can I submit this as a developer request?

    I understand this may be hard to fix, but an opt-in solution would be fantastic for those of us who use jotform and flow to handle many of our workflows.

  • Girish JotForm Support
    Replied on June 8, 2020 at 1:36 AM

    Before I forward your request, I would like to understand few details.

    I understand that you are using JotForm for an automatic approval process, but MS Flow is usually used to integrate JotForm with some other application available on MS Flow  (similar to using Zapier) such as Sharepoint and the like. Aren't you using any other application to integrate with JotForm?

    How is your process flow setup on MS Flow i.e. is it setup to send submission to MS Flow whenever a new submission is received on JotForm?

    If you are not integrating JotForm with any other application on MS Flow and if your purpose is to build an automatic approval process, you may check out this guide: https://www.jotform.com/help/432-A-General-Approach-on-Building-an-Approval-Process-Workflow