cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Convert a value from a calculated SharePoint column, convert to number -- InvalidTemplate error

I am trying to get a value from a calculated column in SharePoint, convert it to number and then use that output to update a different column in SharePoint. I'm getting an InvalidTemplate error.

 

What am I doing wrong here? Thanks you for your help!

 

f1.png

f3.png

f2.png

1 ACCEPTED SOLUTION

Accepted Solutions

So strange, mine works fine.

 

Snag_1845b039.pngSnag_1845ba3b.png

 

 

I would try to rewrite the float() function. Beyond that I'm not sure 

 

sorry @kreed 

View solution in original post

8 REPLIES 8
Resolver II
Resolver II

@kreed 

 

I don't believe the Compose step is needed. You can use the expression you created right in the field in the update item step. 

 

Let me know if this helps! 

@danmitchell36-- thank you for looking at this--it's driving me crazy! 😄

 

I'm still getting the same error. The SharePoint column is calculated and stored as text, though I have tried it in number format with the same result when I try to run the Flow.

 

f5.png4.png

I have no issue doing this. Can you add a screenshot of the output of the get item step?

This is what mine looks like. My calc field is "Test calc"

 

Snag_1803a6d4.png

I'm trying to convert SI and use it to update another column, SIS.

 

g4.png

So strange, mine works fine.

 

Snag_1845b039.pngSnag_1845ba3b.png

 

 

I would try to rewrite the float() function. Beyond that I'm not sure 

 

sorry @kreed 

View solution in original post

@danmitchell36Thank you so much for helping me with this! After iterating on this several times, I finally closed my browser, cleared my cache, rewrote the expression and it worked. Is there a preferred browser for building flows?

@kreed ,

 

Glad it worked! I prefer Chrome.

Helper IV
Helper IV

I am having the same issue

I am using Chrome  and have tried clearing cache.

If I try Expression - float() or int(), the calculated field is not listed under Dynamic content to add it as parameter.

Any ideas?

Thanks    

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (5,793)