web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate PAD Two Variable Addit...

Power Automate

Unanswered

PAD Two Variable Addition Syntax reference not correct

(0) Share

Report

Report

Posted on by henryhvb5

46

Hi everyone,

I have seem the post as follow

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Power-Automate-Desktop-PAD-How-to-perform-math-on-2-or-more/m-p/963044

Asking the same question about add two variable value together. I have checked the reference link as follow

https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-manipulation

But there is no sum up two variable,

whatever e.g

%Var1 + Var2% or %Var1% + %Var2%

Result show the same e.g. 1 + 6

But not 7

Attached with the screen capture for reference

Source TableAddition Result Result

How can I sum up the result equal to 20 ?

Please let me know if any alternative way for this case

Thanks

Henry

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

kinuasa 799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi,
I suggest using the "Convert text to number" action to calculate it as a number.

Regards,
kinuasa

Sample Flow:
Variables.CreateNewDatatable InputTable: { ^['Value', 'Original text'], [20, '20'], [0, '0'], [3, '3'], [0, '0'], [13, '13'], [4, '4'], [0, '0'], [0, '0'] } DataTable=> RecognizedEntities SET Sum TO 0 LOOP FOREACH CurrentItem IN RecognizedEntities Text.ToNumber Text: CurrentItem['Original text'] Number=> TextAsNumber SET Sum TO Sum + TextAsNumber END

Was this reply helpful? Yes No
henryhvb5 46 on at

Like (0)

Report
Copy link

Link copied!

Hi kinuasa,

Thank you very much for your advice, convert text as number solve my problem.

I overlook the flow missing to convert text as number.

Regards,

Henry

Was this reply helpful? Yes No

Join the conversation