web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Trying to Match Variab...

Power Automate

Answered

Trying to Match Variable to a Single Line text field number

(0) Share

Report

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:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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!
Verified answer

v-alzhan-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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.

Join the conversation