Unanswered

Converting from String to Integer

(0) Share

Report

Posted on by zyraglee

Hi All,

I have a number column (Billing ID) on my SharePoint list that contains unwanted commas and as a solution I created a single line of text column called Billing Account that contains calculated value of which it converts the integer to a string.

Now for my workflow, when I sent an email, the Billing Account is blank. Any idea why?

All responses (4)

Answers (0)

zyraglee 14 on at

Like (1)

Report

Re: Converting from String to Integer

Hi, I solved this problem by creating a field with calculated value
GabrielStJohn on at

Like (0)

Report

Re: Converting from String to Integer

Hey, @zyraglee!

It appears as though @v-yamao-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted! Thank you for being an active member of the Flow Community!

-Gabriel

Flow Community Manager
v-yamao-msft on at

Like (0)

Report

Re: Converting from String to Integer

Hi @zyraglee,

Could you share more details on your scenario? Have you created a Calculated column to convert another column to type of single line of text?

According to your description, I have made a similar test with @ScottShearer. It runs without issues, the value of the calculated column can be displayed in the email body.

Please share more details for better understanding.

Best regards,

Mabel Mao
ScottShearer 25,212 Most Valuable Professional on at

Like (0)

Report

Re: Converting from String to Integer

Can you post a screen shot of your Flow?

I just ran a quick test and had no issues.
I have a SharePoint list with a number column (MyNumber) and a calculated text column (MyCalc) that references the number column.
I send an email upon change that references the calculated column.
My Flow runs without issue.