In SharePoint Online I have a doc library (Reference Docs) and a list (Projects).
The goal is for users to choose a doc from a lookup drop-down in Projects, which, when clicked, will directly open the chosen document stored in Reference Docs.
So, in Reference Docs I created a workflow that sets the value of the Title field with the Name field.
In Projects I created a lookup column referencing the Title field in Reference Docs
All works fine, except the link opens the document properties, not the document.
This should be simple, but I just can figure out what is incorrect.
Any help will be appreciated.