Good afternoon, I am using a Gallery on my PowerApps app that is being fed by a document library. Only one file in that doc lib (SampleDoc1.xlsx) has a value in these columns - columns are named "SeparateWO1" and "SeparateWO2."
When that SampleDoc1.xlsx is selected from my Gallery, I want to show a clickable link to open links to the files in a browser.
I have played around with the HTMLText control, but seems more complicated because I only want to show the values from those two columns when this specific file "SampleDoc1.xlsx") is selected in my gallery, hence why I am wanting to use the column values for this instead of a label (varRecord.SeparateWO1)
The SeparateWO1" and "SeparateWO2" columns in my doc lib are Hyperlink columns and have a friendly name in the doc lib (screenshot below), but I can't figure out how to bring in the friendly name into my PowerApp; it's only bringing in the long URL which I don't want.

How can I customize the text being displayed here?
How Can I customize the text being shown here to be whatever I want?
Thoughts?
Thank you in advance!
Morghan C.