Unanswered

Incorporating the link from a lookup filed in SharePoint in PowerApps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone,

I am fairly new to PowerApps and I sometimes struggle to find the right answer or struggle to understand them especially if they are pretty simple!

I have too Sharepoint Lists. The main one is called "ICQ" and the second "RACM"

I have created a lookup field in "ICQ" called "RACM Ref". This has a live link that will take me to the file from "RACM" is clicked. (it did it by itself and is very useful.

I also have a PowerApp that has Edi field from "ICQ" and display fields for extra information from "RACM", including the hyperlinked "RACM Ref"

The problem is that I cannot figure out how to keep the hyperlink active (or add something else to make it work) once I am PowerApps.

Can anyone point me in the right direction please?

Thanks very much

Gem

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

zaphod88 502 on at

Like (0)

Report
Copy link

Link copied!

You could use Launch(), like Launch(TextInput1.Text), and set it as OnSelect on an icon next to the input. It opens the link in a browser tab.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

THanks zaphod88. Launch sounds a great way to go. The problem I am having is that the field is type lookup and does not accept .text, .value etc.

I am using the data card value rather than the data card in the code?

Launch(DataCardValue32.text)

Thanks

Gemma

Was this reply helpful? Yes No
zaphod88 502 on at

Like (0)

Report
Copy link

Link copied!

Yep, you can use the DataCardValue.Text or lookup in your Datasource as well if you have the ID somewhere.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have been trying to make this work all afternoon and I am still getting it wrong. Whatever I do I end up with an error on the .text .value etc and it doesn't work. I have tried putting in the lookups to URLs, URLs in the core table and now I am trying to open just a direct table to see if I can get it to work at the most basic level - I can't 😞

I have a button OnSelect with (link is only to test data)

Launch("https://supergroupplc.sharepoint.com/sites/ControlsSuperdry/Lists/RACMs/DispForm.aspx?ID=1&e=5AbebF".Text)

What am I doing wrong?

Thanks

Gem

Was this reply helpful? Yes No
zaphod88 502 on at

Like (0)

Report
Copy link

Link copied!

What's the content of the DataCardValue hidden below your button? Is the link in there? If yes, can you select it, please, and take another screenshot?

In your example, just take Launch("Link"), without any .text/.value behind it.

Was this reply helpful? Yes No