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:

Mobile App

Using Apps Using Formulas

All responses (2)

Answers (1)

kagostinho 42 on at

Like (0)

Report

Canvas App - Total field display during update

That worked perfectly - thank you so much!
Verified answer

SaiRT14 1,961 Super User 2025 Season 1 on at

Like (1)

Report

Canvas App - Total field display during update

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!