I need to open the first pdf file in a library through a hyperlink on my homepage. Currently I have set the URL to the Library view so that the end user can see the file in library and open it, however I need to open the first file directly rather then going to library and clicking it.
In the library there will be multiple files, I have created a view to get only the last uploaded file.
Now how do I get the URL for the file to open directly since the file name can change.
Working on Sharepoint online