We have built a flow in which it checks that if a SharePoint Calculated column field has some value in it (in numbers). If the there is any value then we want to further initiate some actions.
Since the field is a calculated column it was initially giving an error hence i have converted it in to Integer using int() expression.
Actually i am getting the desired results but the flow is getting failed and showing the below message.
InvalidTemplate. Unable to process template language expressions for action '3rd_Month_Total_Check' at line '1' and column '2864': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
Going through some references i tried to creating another copy using Save As and ran the flow but got the same error. Can anyone please help how to rectify it?
I tested your situation and had no issues using int(). If your SharePoint columns allow decimal numbers, you'll want to use the float() expression rather than int().
Many thanks for help. I tried with changing the Int with float but still same case. The flow is getting stuck in. I have attached the snap for your reference.
The flow is running successfully until the condition is true. It gets failed after 2nd false condition.
Ref: The SharePoint column is a Calculated Column | Name = =[Column A]+[Column B]+[Column C]
Can you provide screen shots of the Flow in Edit mode - the more detail the better especially when it comes to the condition. Also, I would like to see how the calculated column is configured. Can you post a screen shot from the SharePoint list settings showing the calculated column settings?
Hello @ScottShearer, Sorry took more time to answer your question.
Below the snap of condition as requested by you. The cursor is the expression. I have same 12 conditions below to this one (for better organizing, i have created a scope and added them in to it.)
Below the expression. (I have changed from int to float)
@AkshayManke What is the Column type in SharePoint. Could you please share with screen shot ? Also try int() instad of float once to check what happens
I tried to repro your issues but unable to get the error . Pleasee check below the details
Condition in Flow on Total 1
I reckon the key to resolve your issue is to check your SP Columns data type. Please make sure currency is correct or number format is correct and is matching your local settings.
Hi @ajdhingr , Many thanks for testing and replying on the issue. However i tried the same steps as you shown in the snaps. Also i tried with Float and Int expressions but somehow the flow is getting failed. Will let you know if I get anything.
If you are still getting the same error then You may raise a support ticket with Microsoft Support Team. They can help to resolve your issue.
Keep up to date with current events and community announcements in the Power Automate community.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Check out the latest Community Blog from the community!