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

  • Profile Image
    clwmarshall
    Asked on February 09, 2021 at 05: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

    Screenshot
  • Profile Image
    roneet
    Answered on February 09, 2021 at 08:46 PM

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

    1612921394_60233a32533d5_

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

    Let us know if you have further questions.

    Thanks.