Unanswered

from a dropdown selected result, Lookup and display a hyperlink in a textbox

(0) Share

Report

Posted on by MP_Squared

Hi,

I'm trying to use a dropdown selection to display a hyperlink in a Text label. Not sure exactly What the best way to do this is.

Currently I have a the dropdown items property set as Distinct(Source, ColumnName),

for the Text label I've tried setting the text property to Lookup(source, Dropdown.selected.result=Thisitem.columnname ) where the URLS are but no luck.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @MP_Squared ,

Assuming you have the same URL on each Distinct item

GroupBy( Source, "ColumnName", "URLFieldName", "Data" )

then use (with your URL field name)

ComboBoxName.Selected.URLFieldName

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MP_Squared 26 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz unfortunately they are not the same URLs. But let me explain what I'm trying to achieve, I may be going about it the wrong way.

The intent would be a user would view the gallery of brochures, They would then click the image of the brochure that they wanted to view, using the on visible property of the dropdown menu, would then show/hide the dropdown to show you the available languages for that brochure. selecting the language would then display the URL to the digital version of the brochure.

Currently the gallery items property are set using the following ForAll(Distinct('source', Title), LookUp('source', Title=Result)).
The reasoning for this is because some of the brochures on the sharepoint list are the same but the language column and the URL links are all different depending on the brochure. So I was trying to hide the duplicate items from the gallery. Shown below
Which then is the reason why using the distinct formula on the dropdown items property since there was multiple brochures with the same languages.

like I said, maybe I'm approach this the wrong way.

Appreciate it.

Was this reply helpful? Yes No