DataCard calculation not always working

(0) Share

Report

Posted on by EG-31080115-0

118

Form= Gallery1.Selected

F is Gallery2 item and Gallery2 has different source but common column as Gallery1. F is populated with Gallery1.Selected

Calculation is for A and B. Calculation is (nutshell):

A= Round( E/F,0) B=E-(F*A) D is referenced in If statement to make sure E is calculated in same units as F (i.e. KG's)

I added C as test label to evaluate, Value(F.Text)

In some cases, not all, Value(F.Text) returns 0 in which case renders calculations for A inaccurate (i.e. A=0)

I'm wondering if some how there may be hidden leading/lagging characters for Gallery2 item in the source that causes Value() to not work. I checked my "source" file for Gallery2 Source and this doesn't seem to be the case. Thoughts? Thanks

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Abhilash_Swain 901 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you please explain, have you added the calculations as default, or is there any button that triggers these calculations?

If its in default,change to a button to recalculate and show.
EG-31080115-0 118 on at

Like
a
(0)

Report
Copy link

Link copied!

@Abhilash_Swain --It is set as default. However, what doesn't make sense is some Gallery1.Selected will the display value in both Gallery2 and in Label (C in screenshot). For other Gallery1.Selected it will display in Gallery2 but not Label. These are also the ones that fail to calculate.
Verified answer

EG-31080115-0 118 on at

Like
a
(0)

Report
Copy link

Link copied!

It appears to be either leading/lagging ghost character or some other code/formatting issue for some of the items uploaded to SP List from Excel. For those that won't display in Label or calculate if I delete and type in the value in the SP List it woks properly in PowerApp.
Abhilash_Swain 901 on at

Like
a
(0)

Report
Copy link

Link copied!

Super