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

Community site session details

Session Id : acJgia6zJjb7iydmwxMbes
Power Apps - Building Power Apps
Unanswered

Link to files from a sharepoint list

Like (0) ShareShare
ReportReport
Posted on 21 Jan 2022 16:22:03 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 16 Feb 2022 at 03:54:47
    Re: Link to files from a sharepoint list

    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

  • Mimas Profile Picture
    39 on 15 Feb 2022 at 21:15:24
    Re: Link to files from a sharepoint list

    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.

  • Mimas Profile Picture
    39 on 15 Feb 2022 at 19:56:32
    Re: Link to files from a sharepoint list

    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

     

     

  • StalinPonnusamy Profile Picture
    Super User 2024 Season 1 on 27 Jan 2022 at 05:05:00
    Re: Link to files from a sharepoint list

    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

  • StalinPonnusamy Profile Picture
    Super User 2024 Season 1 on 21 Jan 2022 at 17:15:28
    Re: Link to files from a sharepoint list

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 982 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 396 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 356

Last 30 days Overall leaderboard
Loading started
Loading complete