Link to item in SharePoint list attachment from one list available in another list

[MalyMajo]

Hello all,

I am creating an app for resource demand management and I am struggling with making the attachment of one list visible in another one.

There are 3 SharePoint lists involved - Resource roster, Demand list and Interview list.

• The Resource roster is managed by the manager of the team. He updates the resources which are available and uploads the CVs as attachments to this list for each resource. There is always one line per resource.
• When there is a demand for some resources, manager creates the demand request. This demand request contains only a name of demand (unique value) and a counterpart name. Counterpart is a contact person, who is requesting some resources.
• Afterwards, he selects the resources, which are proposed to the counterpart -> Interview records are created for each resource of this project in the Interview list.
  The counterpart then can take a look at the CVs of the proposed resources and can decide for each resource whether he wants him/her on the project or not.

Is it possible to have the attachments from the resource list available in the Interviews list? 

[uwenagel]

The question is, how you want to add the CV to the interview list, if not again as an attachment to each record.

This leads to the next question why you want to have the CVs added to the interview list at all. You could always show it using a Lookup to the resource list.

[MalyMajo]

If the CV is attached in the Roster gallery, I want the user to be able to download the CV when reviewing the Filtered demand in Interviews gallery.

I have added a button to the Interviews gallery with function on OnSelect

LookUp(Roster,Resource.Email = ThisItem.Resource.Email).Attachments

but I get an error, that the formula uses scope, which is not presently supported for evaluation.

[MalyMajo · Accepted solution]

I have managed to solve it. 🙂 

Sharing the code below, hope it will help someone as well.

Launch(First(LookUp(Roster,Resource.Email = ThisItem.Resource.Email).'{Attachments}').AbsoluteUri)