web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Calculation from Fields
Power Automate
Suggested Answer

Calculation from Fields

(0) ShareShare
ReportReport
Posted on by 10
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:
I have the same question (0)
  • Suggested answer
    Pstork1 Profile Picture
    69,026 Most Valuable Professional on at
    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
     
  • CU29082038-0 Profile Picture
    16 on at
    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']
  • Suggested answer
    Pstork1 Profile Picture
    69,026 Most Valuable Professional on at
    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
     
  • CU04091249-0 Profile Picture
    10 on at
    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'])
  • CU04091249-0 Profile Picture
    10 on at
    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.'.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 283

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard