Canvas App - Total field display during update

(0) Share

Report

Posted on by kagostinho

I'm pretty new to Canvas Apps so some guidance would be appreciated.

I have 10 input fields (txt_PercentValue_1) that I have formatting to percent with the following:

Default Property: Text(Value(varPercentValue_1),"0.0%")

OnChange Property: Set(varPercentValue_1,Self.Text);Reset(txt_PercentValue_1)

I have a hidden total field (txt_PercentTotalValue) which sums the 10 input fields with the following:

Default Property: (txt_PercentValue_1.Text+txt_PercentValue_2.Text...+txt_PercentValue_10.Text)*100

And I have a visible total field (lbl_PercentTotal2) which formats the hidden one with the following:

Text Property: Text(Value(txt_PercentTotalValue.Text),"#%")

Everything calculates correctly and the final values are displayed correctly after you tab off the cell. However, there is weird behavior in the visible total field during the update of the input fields:

Once I finish typing it looks fine:

But does anyone have a suggestion for how I can fix the field so it does not show the initially incorrect value during the input process? I'm fine with hiding it / changing the font colour to white during the update - just not sure how to.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

SaiRT14 1,992 Super User 2025 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Try

concat('/ExpenseTracking/', items('Apply_to_each_2')?['tigexpns_id'], '.xlsx')

1. Update the Default Property of the Input Fields: - OnChange Property:
Set(varPercentValue_1, Value(Self.Text)); Reset(txt_PercentValue_1)

2. Update the Default Property of the Total Field (txt_PercentTotalValue):Default Property
(varPercentValue_1 + varPercentValue_2 + ... + varPercentValue_10)

3. Update the Text Property of the Visible Total Field (lbl_PercentTotal2):Text Property:
Text(Value(txt_PercentTotalValue.Text), "0.0%")

4. Ensure Real-time Updates:OnChange property of txt_PercentValue_1:
Set(varPercentValue_1, Value(Self.Text)); Reset(txt_PercentValue_1);
Set(varTotalPercent, varPercentValue_1 + varPercentValue_2 + ... + varPercentValue_10)

let me know how it works!

Was this reply helpful? Yes No
kagostinho 42 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked perfectly - thank you so much!

Was this reply helpful? Yes No