Trying to Match Variable to a Single Line text field number

(0) Share

Report

Posted on by Portland

167

I have a variable, let's say it contains the number 5

Next, I have a condition to ask if the variable is equal to the SharePoint item. SharePoint is displaying 5 in the list

However, when the flow runs it fails. They don't match.

I check my variable -it is displaying 5

I check the SharePoint column, and it is displaying 5.000000000000000 Guessing this is why they don't equal.

I tried setting the SharePoint (Calculated field type) to Number and decimal is 0, but when I check the flow compose, it's still seeing 5.000000000000 in the workflow.

Looking for help please.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Portland

You can use the format number action in Flow and pass the calculated column from sharepoint to this action as an input and then select the output format. Based on this, you can then compare with the variable values.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (1)

Report
Hi @Portland ,

You could save the calculated column value in a Compose, then refer to screenshot below to create the flow:

int(first(split(outputs('Compose'),'.')))

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No