cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kreed
Level: Powered On

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

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

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 

7 REPLIES 7

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

@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! 

kreed
Level: Powered On

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

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

 

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

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

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

kreed
Level: Powered On

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

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

 

g4.png

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

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 

kreed
Level: Powered On

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

@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?

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

@kreed ,

 

Glad it worked! I prefer Chrome.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 49 members 4,899 guests
Please welcome our newest community members: