Forum Discussion
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-thompsonBrass ContributorIs there some more information needed to get a response on this. Please give me anything.
- Rob_ElliottBronze 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)