Answered

Covert miles to feet dynamically between 2 textboxes and avoid circular reference

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to create a "live" conversion between two text fields so that the user can enter either feet or miles and the conversion between the textboxes will happen depending on whichever measure they are filling out.

The logic:

I added a datacard with 2 textboxes.

TextBox1 (miles) Loads the Parent.Default (I'm only storing the miles in the database).

TextBox2 (feet) converts whatever is in TextBox1 (miles):

(If(!IsBlank(TextBox1.Text),TextBox1.Text*5280))

How do I also make the reverse happen without hitting a circular reference?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

SBax 1,348 on at

Like
a
(0)

Report
Copy link

Link copied!

I've achieved similar before with miles and kilometres.

I couldn't figure out how to avoid the circular issue either so ended up with a toggle to lock one field, if it's "on" and the other if it's "off" then used a formula to look at the toggles value and did the conversion based on that
Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!

hi @Anonymous

you could do the following:

In both the text boxes set the OnChange to:

textbox miles: UpdateContext({varFeet: Value(Self.Text) * 5280})

textbox feet: UpdateContext({varMiles: Value(Self.Text) / 5280})

Set there Defaults to

textbox miles: varFeet

textbox feet: varMiles

Result

Hope it helps,

R
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks. I also added a variable that only switches to true OnChange of one of those textboxes and I reset it to false when loading the form. This allows me to load the miles to an existing form. i.e if(!conversion,Parent.Default,varMiles)