I have a powerapp that has 3 different options on a radio toggle for location selection (see picture).
You either choose to submit your GPS location, choose your site location from a dropdown, or you can fill in a multi-line text input with anything.
Now, in the back-end, I have columns for each of these things (ie. latitude, longitude, site location lookup etc,) but I am wondering IN POWERAPPS if it's possible to have an invisible field that acts like a "Master Address" field. Basically if they select GPS, the coordinates will also get written to that master field, if they select Site location, the site location address will get written to that field etc. etc.
This way in SP there is only one column to look at for address information. How would I structure that expression? Thank you