I have a strange issue I cannot figure out.
I have a flow which when triggered should retrieve one record and then create a related record with values being a percentage of the source records. Seems straightforward, however the Flow fails on the create record step with the following error:
Unable to process template language expressions in action 'Create_PC_Line_Based_on_QS' inputs at line '1' and column '2726': 'The template language function 'mul' expects its first parameter to be an integer or a decimal number. The provided value is of type 'Null'.
The Expression referred to is a simple multiplication statement:
mul(body('Get_the_QS_Coverage')?['ssru_blanketlimit'],variables('QSPct'))
Solved! Go to Solution.
Thanks for your quick reply.
Please try this expression.
mul(body('Get_the_QS_Coverage')?['value']?[0]?['ssru_blanketlimit'],variables('QSPct'))
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog
Could you post your retrieve flow step screenshot please?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog
Try this
mul(body('Get_the_QS_Coverage')?['value']?['ssru_blanketlimit'],variables('QSPct'))
Let me know the result.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThanks @abm, tried that sadly just got another error:
Unable to process template language expressions in action 'Initialize_Building_Limit' inputs at line '1' and column '2726': 'The template language expression 'mul(body('Get_the_QS_Coverage')?['value']?['ssru_blanketlimit'],variables('QSPct'))' cannot be evaluated because property 'ssru_blanketlimit' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.
Thanks for your quick reply.
Please try this expression.
mul(body('Get_the_QS_Coverage')?['value']?[0]?['ssru_blanketlimit'],variables('QSPct'))
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThanks @abm that worked!
Any idea why the body fields need to be formatted that way? I have several more values to use in my flow and it appears I have to type the body expression for each value.
That's great.
The value is an array collection. Please see your earlier screenshot you provided.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog