Forum Discussion

wm-thompson's avatar
wm-thompson
Brass Contributor
Apr 15, 2024

Matching data types in a flow ignores number data type.

We have created a successful flow which matches the data that is entered from a jotform UI/UX. Then the flow enters the information successfully into a Microsoft List row. Everything is fine and we tested it with a small amount of the data. Afterwards, I went ahead and started adding files and matching them with the incoming data.

 

The problem is noticed when I started to enter number fields instead of short strings. Look at the screen shot I am including. The values for Total TIme and "Flight time last 12 months" had no corresponding data type and the ony difference between these and the other fields is the fact that these two fields are numbers and the others are short strings.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

When I try to add connection for the number field, I get this error message. Please tell me what this means and how do I fix it.

 

 

 

  • wm-thompson's avatar
    wm-thompson
    Brass Contributor
    Is there some more information needed to get a response on this.  Please give me anything.
    • Rob_Elliott's avatar
      Rob_Elliott
      Bronze Contributor

      wm-thompson Before the create item action try adding a couple of Compose actions and select each of the Jotform number fields as the inputs for them. That way you can then check that the data has actually been brought back from Jotform. You could then add the outputs of the Compose into the relevant fields.

       

      Rob
      Los Gallardos
      Microsoft Power Automate Community Super User.
      Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources