Method to pull in Unique Name or Field ID's rather than Field Number-Field Name via Common Data Service + PowerPlatform

  • clwmarshall
    Asked on February 9, 2021 at 5:01 PM

    We are currently successfully brining in data from JotForm to Dynamics 365. The only caveat is when we update the JotForm with additional fields. When a field is added to the form, the number assigned to the name of the field is sequential and is renumbered with each new additional field.

    I'm curious if there is a method to pull Unique Name or Field Id's rather than field number-field name when using Common Data Service in PowerAutomate?

    Thanks-Carrie

    Jotform Thread 2886805 Screenshot
  • roneet
    Replied on February 9, 2021 at 8:46 PM

    You can use the API call to get the unique name of the fields:

    1612921394 60233a32533d5  Screenshot 10

    Guide: https://api.jotform.com/docs/#submission-id

    Let us know if you have further questions.

    Thanks.