web

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

News and Announcements icon

Power Platform CommunityForums Power Apps iF EQUAL STATEMENT FOR...

Power Apps

Unanswered

iF EQUAL STATEMENT FOR CALCULATIONS

(1) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Evening, I have a form that is doing some calculations.

DataCardValue1= (DataCardValue28+DataCardValue29)

DataCardValue2= (DataCardVAlue30 + DataCardValue31)

These are all user input values.

Here is my code for the Default:

If( DataCardValue1=SUM(DATACARDVALUE28,DataCardValue29) & DataCardValue2=SUM(DataCardValue30,DataCardValue31), "Error"))

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

These are all user input values.
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
I think you are trying to evaluate if two calculations are true, and if so, you want to display an error message.

It seems you are calculating the sum of two pairs of DataCardValues and then checking if those sums are equal to the defined values DataCardValue1 and DataCardValue2. If the conditions are true, you want to display the "Error" message. Here's a corrected formula:

If( DataCardValue1 = (DataCardValue28 + DataCardValue29) && DataCardValue2 = (DataCardValue30 + DataCardValue31), "Error" )

I think you don't need to use the SUM function here since you're only adding two values together, and the + operator should suffice.

Also, I've replaced the & with && to ensure a proper logical AND comparison.

See if it helps @Anonymous

Join the conversation