web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Insert row in SQL stri...

Power Automate

Answered

Insert row in SQL string to number

(0) Share

Report

Report

Posted on by KarlNixon

164

Looking for brains trust help.

I have a string variable that I want to update into a number SQL field via Insert Row (v2)

What expression should I be using?

Categories:

Using connectors

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bacao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @KarlNixon ,

Please try the following expression:

int(variables('string')) or float(variables('string'))

Image reference:

Spoiler (Highlight to read)

You only need to use variables('VariableName') to get the value of the variable, then use int()/float() function to format string to number.

Please take a try.

Best Regards,

Was this reply helpful? Yes No

Join the conversation