Calculation from Fields

(0) Share

Report

Posted on by CU04091249-0

Hi, I have a form that I'm using for an expense report. I'm trying to add up some fields and having trouble figuring out the syntax. For some reason, the form field is coming over not with the name of the question, but some long alpha numeric number too.

This is the output from the from the "Get response details"...

Ideally I would like to add the outputs of Amount (1st), Amount (2nd) and so on.

I will also trying to see if I can parse the JSON to make things work but I'm most likely missing the point somewhere.

Here's what comes out of the "Parse JSON"...I have no problem using long alpha-numeric name. What works easier.

Appreciate any insight!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

CU04091249-0 10 on at

Like (0)

Report
Copy link

Link copied!

Just saw this. I did pull in the fields from the Microsoft Form (e.g. 12.55). It looks like it's an integer, etc. Do I need to create a variable or something?

Unable to process template language expressions in action 'Populate_a_Microsoft_Word_template' inputs at line '0' and column '0': 'The template language function 'add' expects its first parameter to be an integer, a float or a decimal number. The provided value is of type 'String'. Please see https://aka.ms/logicexpressions#add for usage details.'.

Was this reply helpful? Yes No
CU04091249-0 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks Paul. My flow accepted this expression but it must be wrong somewhere. Any thoughts on where I messed up?

add(outputs('Get_response_details')?['body/reb53ee0af2314c759854bcfb8ddb6486'],outputs('Get_response_details')?['body/reb53ee0af2314c759854bcfb8ddb6486'])

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,865 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can do it using the Expressions tab and the Dynamic content tab. Use the expressions tab to get started by typing Add(. Then switch to dynamic content and access the questions from the list. You can see the questions from one of my demo flows below.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
CU29082038-0 14 on at

Like (0)

Report
Copy link

Link copied!

Agreed that the compose, JSON should not be needed. What would be the syntax?

Something like this?

add('Get_response_details')?['OutputName1'],'Get_response_details')?['OutputName2']

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,865 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What are you doing in the Compose that requires using a Parse JSON. The individual question responses are available after doing the Get Response Details as Dynamic Content without needing an additional Parse JSON.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No