Answered

Launch a file from library within powerapps gallery search results

(0) Share

Report

Posted on by tpii

Hi, I have a Sharepoint site with a list, library, and a collection the collection was created from the files in the library.

Mylist (three column names: Name, Number, FileName) , Mylibrary (a group of PDF files named, FileName.pdf (matches the File name field in the list and collection) , Mycollection

I created a screen with a searchable gallery (either the Name or Number column) in MyList. works well.

I want to place an icon on the right side of the gallery box that will launch the PDF file with the same name as my list from either MyLibrary or MyCollection.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

WarrenBelz 153,781 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi @tpii ,

You did not say how exactly MyCollection was collected, so I will give you two possibilities.
If the collection contains the metadata for the library, then one of Launch(‘link to item’) or Launch(‘link’) should work (sorry I am not in front of my PC). You will see the parameters come up when you type Launch.
Otherwise you can launch it with the absolute URL (I assume it is in SharePoint). Launch(<SharePoint folder URL> & (file name)

Please click and accept as Solution if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Was this reply helpful? Yes No
tpii 5 on at

Like (0)

Report
Copy link

Link copied!

Warren, thanks for the note. I did find a solution in my code based on your note. I was not enclosing the hyperlink to launch in double quotes. frustrating to know what the app wants where, quotes, brackets, curvy brackets, square brackets... It almost seems each command has its own quirks.

thanks again, Tom

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

Like (0)

Report
Copy link

Link copied!

Hi Tom @tpii ,
Yes - Launch URL are strings, and any text outside control references needs to be in quotes.

Can you please accept as a solution to close this and also allow others with similar queries to easily find it.

Was this reply helpful? Yes No
MaintenanceGuy 30 on at

Like (0)

Report
Copy link

Link copied!

what if i want to grab the file name from table located in the power app?
launch (<url to sharepoint>& (datacardvalue1))

i know i am missing something here in the data grab from there just not sure? any help

Was this reply helpful? Yes No
Xardas87 8 on at

Like (0)

Report
Copy link

Link copied!

'Link to item' gives a weblink that is a mixed bag for Launch function.
Example: SharePoint URL/Nameofdoc.docx?d=w"GUID"&csf=1&web=1&e=etc...

The way around this is to create a direct link from the value returned by 'Link to item"

Launch(Left('DataCardURLvalue',Find("?d=",'DataCardURLvalue')-1))

PowerApps will Launch( based on the extension the string ends with ".docx" or ".PDF" example.
(Left return the address value Left of the Find( "?d=" This will be the absolute URL mentioned by @WarrenBelz
Data source
Find("?d=" this is the first part of the unwanted web string right of our extension ".docx" or ".PDF"
Data source
-1) Remove the question mark from the end of direct link .docx?

Launch(Left('DataCardURLvalue',Find("?d=",'DataCardURLvalue')-1))

Was this reply helpful? Yes No
Xardas87 8 on at

Like (0)

Report
Copy link

Link copied!

If you are using 'Link to item' in a gallery or in a Form data card. Its not going to give you a direct link. If you view it as a URL it will open in Web View. Library settings for Default application do not apply to web view links. So you need a direct link if you want to launch the document.

Launch(Left('DataCardURLvalue',Find("?d=",'DataCardURLvalue')-1))

Was this reply helpful? Yes No