No worries — your terminology is actually fine 👍
This is a very common first-time Power Apps question, especially when working with Excel.
The good news: you don’t need buttons at all, and you can make URLs clickable directly inside the form.
✅ Why it’s showing as plain text
When Power Apps connects to Excel, all URL columns are treated as Text, not as hyperlinks.
So the form correctly displays the value, but Power Apps will never auto-convert Excel text into clickable links.
You must explicitly tell Power Apps to launch the URL.
✅ Correct solution (works inside forms)
You’ll modify the Data Card that already exists in the form.
🔹 Step-by-step
1️⃣ Unlock the data card
-
Click the form
-
Select the Website data card (e.g. WebSite1)
-
In the right panel → click Unlock to change properties
2️⃣ Select the DataCardValue label
Inside the card, select the control that displays the URL
(it’s usually called something like DataCardValue12).
3️⃣ Change it from Label → Link behavior
Set these properties:
Text
ThisItem.WebSite1
(or it may already be set automatically)
OnSelect
Launch(ThisItem.WebSite1)
That’s it.
Now the text becomes clickable.
✅ Optional: make it look like a hyperlink
Set these properties on the same control:
Color = Color.Blue
Underline = true
HoverColor = Color.DarkBlue
Cursor = Cursor.Hand
Now it behaves exactly like a web link.
✅ Repeat for Website2 and Website3
Each card just uses its own column:
Launch(ThisItem.WebSite2)
Launch(ThisItem.WebSite3)
Because the form is bound to the selected state, the URL automatically changes when a different state is selected.
You don’t need to reference the gallery at all.
❌ Why your button always opened the same state
You likely used something like:
Launch(Gallery1.Selected.WebSite1)
That works only if:
Forms already track the selected record internally, so using ThisItem is the correct and reliable approach.
✅ Final working setup
Gallery
Items = ExcelTable
Form
Item = Gallery1.Selected
Website DataCardValue
Text = ThisItem.WebSite1
OnSelect = Launch(ThisItem.WebSite1)
Repeat for each website column.
✅ Result
When the user selects:
Alabama
The form shows:
https://example1.com
https://example2.com
https://example3.com
Clicking any link:
🔹 Important note
If the Excel cell contains:
example.com
It must be:
https://example.com
or Launch will not work.
✅ Summary
-
Excel URLs are treated as plain text
-
Power Apps does not auto-create hyperlinks
-
Use Launch() on the DataCardValue
-
Use ThisItem.ColumnName
-
No buttons required
-
Works perfectly inside forms
