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!
Solved! Go to Solution.
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! :-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.
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"
@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?
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need
Find out where you can attend!
Watch & learn from the Flow Community Video Gallery!