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?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
GabrielStJohn Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
zyraglee 14 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No