Unanswered

Launch external URL using field value as parameter

(0) Share

Report

Posted on by CK-22072023-0

Hi,

I am struggling with launch syntax that would enable me to pass the value of a datafield as a parameter when I click a button. for example, if I wanted to pass the value of MyField to the URL to get the resulting URL opened in the browser where the value of MyField = '123'. The final URL would be: "https://somewebsite.com/account/account.nl?id=123"

Any guidance is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

CK-22072023-0 11 on at

Like (0)

Report
Copy link

Link copied!

I was not successful in pulling the data from the underlying data source. I just added the column to the form then hid it.

Was this reply helpful? Yes No
WarrenBelz 153,529 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ckelsoe ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No
WarrenBelz 153,529 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
If the Gallery has the ID of the relevant record containing MyField

With( { wField: LookUp( ListName, ID=GalleryName.Selected.ID ).MyField }, Launch("https://somewebsite.com/account/account.nl?id=" & wField) )

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.

Was this reply helpful? Yes No
CK-22072023-0 11 on at

Like (0)

Report
Copy link

Link copied!

MyField is the column in the underlying Sharepoint list. Is there not a way to select a column from the list that is not in the gallery?

Was this reply helpful? Yes No
WarrenBelz 153,529 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @ckelsoe ,

Firstly the single quotes in my example are used if the parameter is Text (a hyperlink will accept either single or double quotes but double have a different meaning in Power Apps).

Also if you have a numeric value in DataCardValue6

Launch("https://somewebsite.com/account/account.nl?id=" & Value(DataCardValue6.Text))

If MyField is selected in a records from a gallery

Launch("https://somewebsite.com/account/account.nl?id=" & GalleryName.Selected.MyField).

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.

Was this reply helpful? Yes No
CK-22072023-0 11 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

This example helped me a lot. I could not get the exact example to work as expected - I cannot figure out the reference to MyField directly. What I was able to get working is to pull the value from MyField_DataCard via Launch("https://somewebsite.com/account/account.nl?id=" & DataCardValue6). While this works, I really do not want to show the actual data from MyField_Datacard. I want to use the value of that field in the URL. I think that is what your example may represent. However, I am still not able to get it to work as expected.

Was this reply helpful? Yes No
WarrenBelz 153,529 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @ckelsoe ,

Try

"https://somewebsite.com/account/account.nl?id='" & MyField" & "'"

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.

Was this reply helpful? Yes No