I'm trying to get the numbers from two SharePoint fields to use in a subtraction expression.
The one field is coming in fine, but the other value is coming back as 2.0000000000 (see below) which is causing the expression to throw the following error: "Unable to process template language expressions in action 'Days_Remaining' inputs at line '1' and column '37863': 'The template language function 'sub' expects its second parameter to be an integer or a decimal number."
How do I format the output so that it returns a whole? I've just tried changing the number of decimal places on the SP field to 0 but it still comes back with 2.000000000000. all help appreciated.
Solved! Go to Solution.
The name of the Dynamic Value is 'Holiday_allocation'. If I type 'int( )' in the expression I can't see it in Dynamic Content only Body and Values, and if I just type
in the expression field I'm getting the 'expression is invalid'. Where am I going wrong?
So this seems to be a formatting issue,
Can you try and create another Compose action below the first one.
So now you will have 2 compose actions,
1 for storing the dynamic value for Holiday_allocation.
and in the second Compose, use the int() expression and put the outputs of the first compose in the ( )
Actually that worked! The expression was
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.