Power Automate to Smartsheet issue

[cfitzsimmo1]

Hi Community,

When I move numbers from my flow into Smartsheet, instead of 0.5, for example, it shows as '0.5

This is a concern because I want to use a formula in Smartsheets, but in its current state I am stuck with having to manually go in and delete the ' from each cell. Any solutions out there? Thank you!

[Rahber]

Can you show your flow? If the ' doesnt exist in your data and is coming up in flow its quite possible that you might have a extra character some where.

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,

Rahber

[cfitzsimmo1]

Yeah here it is @Rahber 

Then,

Initialize variable 

Name: Date Diff Ticks

Type: Integer

Value: sub(ticks(triggerBody()?['end']),ticks(triggerBody()?['start']))

Then,

Initialize variable 

Name: Difference Seconds

Type: Integer

Value: div(variables('DateDiff Ticks'),10000000)

Then,

Initialize variable 

Name: Difference Hours

Type: Integer

Value: div(variables('Difference Seconds'),3600.00)

[linxiao]

Could you please provide the screenshot of your flow in edit mode. I'd like to see how do you move numbers from flow to Smartsheet.

[cfitzsimmo1]

@linxiao Here is it in edit mode, let me know if you need anything else. Thanks for your time!

[linxiao]

I saw that you are calculating the different hours which is a string type variable. The issue may caused by the formula in the Initialize variable 3 action. Please:

1. Show me that whole formula
2. Take a screenshot of one of your failed running history, especially for the Initialize variable 3 step (expand that action then i can see the input and output of it).

[cfitzsimmo1]

@linxiao 

1. Initialize variable 3 formula - 

div(variables('Difference Seconds'),3600.00)

2. I do not have a failed running history, but if I change it from a string to an integer I get this:

Typically it runs successfully and I get something like this, which correctly calculates everything, it just puts the ' 

[linxiao]

That's really weird.

However, why not have some tests?

• Test 1

1. change the type of different hours  variable to float
2. replace your formula with 0.3333
3. run the flow
4. check result

• Test 2

1. keep the type as string
2. replace your formula with 0.3333
3. run the flow
4. check result