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