Link to files from a sharepoint list

[Mimas]

Hi!

I have a Sharepoint list with many columns containing info about Grants. In addition to the many info columns (i.e. title, important dates, people involved, annual budget, etc.) I want to be sure to refer to 3 important types of documents (application, letter of acceptance, annual reports). The best would be to have an attachment column by type of document. That way it would be easy to see if one of those document is missing. But I understand that there is no way to have more than one attachment column in a Sharepoint list. So I added URL columns instead to link to a Sharepoint Document Library (inside the same private Teams). That way we can indicate the location of the file with a form in Powerapps. It works but we have to copy-paste the long URL. I didn't find how to make the URL open directly from Powerapps.  So I am looking for how to make those links open directly by clicking on them or any better ideas to manage that situation where I want to be sure that all those documents are link to the Grant's info and to refer to them. They also are important documents to keep in the long run so maybe document libraries are better than list attachment in that regards?! I red a bit about Document set and other possibility with Document Libraries but didn't find something that seems to meet my goal. Any ideas to help me?

Thanks in advance!

Mimas

[StalinPonnusamy]

Hi @Mimas 

The document library is good to keep many documents and metadata. We can use the Launch function to open the document from the library

Launch("Document Library URL" ,{},LaunchTarget.New)

Thanks,
Stalin - Learn To Illuminate

[StalinPonnusamy]

Hi @Mimas 

Please let us know if anything needs on your post. We can help with this.

Please mark the post as Solved If I have answered your question.
Please give it a Thumbs Up if you find the suggestion helpful

Thanks,
Stalin - Learn To Illuminate

[Mimas]

Hi Stalin,

Thank you for your answer. Sorry for my late reply.

I did not found the way to use your formula exactly the way I wanted but found a work around. The launch fonction did not seem to work from a Form field. I had an "Hyperlink or Picture" type of field. I also tried with a text field on the "OnSelect" property but it not work. I was able to make a form field directly clickable by changing the Control type of the form field to "Edit URL" and then use "<a href='" & Parent.Default & "'>" & Parent.Default & "</a>" in the "htmlText" Property. But it looks like it is not possible to edit the link in Powerapps using that solution. In my case, that is unfortunate as I want to indicate the location of the wanted file and/or edit it if needed. 

So the solution I came up with is to use a regular text field and add an icon to the data card. I then use your Launch fonction on the "OnSelect" property of the icon like this: Launch(Datacard.text)

In anyway, thank you for your input!

Mimas

[Mimas]

Oops, I need to correct myself here. Adding the icon to the data card is not working. It seems like the "On Select" property is not working if the Form is on View Mode. Doesn't helps to put the datacard only on Edit mode. So I have put the icons on a banner on the bottom of the screen.

[StalinPonnusamy]

Hi @Mimas 

That's correct. In view mode, the user can't click anything. In this case, any links should be outside the form.

Thanks, Stalin
Blog - Learn To Illuminate Blog
YouTube - Learn To Illuminate Videos