Unanswered

Incorporating the link from a lookup filed in SharePoint in PowerApps

Like (0) Share

Report

Posted on 14 May 2021 12:27:55 by Community Power Pla...

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

I have the same question (0)

All responses (5)

Answers (0)

zaphod88 502 on 14 May 2021 at 12:42:44

Like (0)

Report

Re: Incorporating the link from a lookup filed in SharePoint in PowerApps

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... on 14 May 2021 at 13:02:24

Like (0)

Report

Re: Incorporating the link from a lookup filed in SharePoint in PowerApps

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 14 May 2021 at 13:21:17

Like (0)

Report

Re: Incorporating the link from a lookup filed in SharePoint in PowerApps

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... on 14 May 2021 at 17:43:17

Like (0)

Report

Re: Incorporating the link from a lookup filed in SharePoint in PowerApps

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 14 May 2021 at 17:54:49

Like (0)

Report

Re: Incorporating the link from a lookup filed in SharePoint in PowerApps

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