How do I fix an aligenment issue in Microsoft Flow when Number values are not recognized?

William Thompson 125 Reputation points
2024-04-15T16:26:34.2166667+00:00

I am having a problem with matching data types in a Microsoft Automated Flow because it seems to ignore the 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 only difference between these and the other fields is the fact that these two fields are numbers and the others are short strings.

data-table

Microsoft 365 and Office SharePoint For business Windows
Community Center Not monitored
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ling Zhou_MSFT 23,620 Reputation points Microsoft External Staff
    2024-04-16T05:21:22.14+00:00

    Hi @William Thompson,

    Good Day!! Thank you for posting your concern in this Community.

    Per the description shared, I understand your concern but since it's related to jotform and power automate, I suggest you to post your concern in this jotform forum

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 

    and Power Automate forum to get the detailed help from the experts.

    Thank you for your kind understanding.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.