web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Link to files from a s...
Power Apps
Unanswered

Link to files from a sharepoint list

(0) ShareShare
ReportReport
Posted on by 39

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

Categories:
I have the same question (0)
  • StalinPonnusamy Profile Picture
    Super User 2024 Season 1 on at

    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 Profile Picture
    Super User 2024 Season 1 on at

    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 Profile Picture
    39 on at

    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 Profile Picture
    39 on at

    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 Profile Picture
    Super User 2024 Season 1 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 392 Most Valuable Professional

#2
11manish Profile Picture

11manish 136 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 109 Super User 2026 Season 2

Last 30 days Overall leaderboard