Attaching multiple files to SP Doc Lib with additional fields

[sanderson82]

Hi

I have watched a few videos relating to attaching files to a SP Doc Lib however I can't see information to help with the following...

1) For each attachment I want to have 2 dropdowns, Contract and Unit ID.  These fields would then also be populated on the Doc Lib with the attached file.

Note This would normally be multiple entries at one time so possibly hold this info in a collection until all entries have been added?

2) Revisions.  If a user is uploading a revised document, I would like them to be able to select the contract and unit ID, then see the filename and current version of the associated document, and then upload the new version

Many thanks for any help

[WarrenBelz]

Hi @sanderson82 ,

I send the ID of the main item down in the metadata to the library as IDRef. You simply then filter a gallery on the library where IDRef equals the current item ID.

As for the viewing - here is a post I did recently for single files and this one for galleries. You can actually use some of post one to as an alternative for the single file bit in the second one.

[sanderson82]

Thanks @WarrenBelz for your help and advice.

My current struggle now is that I don't seem to be able to reference the drawing name (filename) in a text field filtered by contract and unit in my other app.  I've added my document library as a datasource however i'm unsure of the syntax

[WarrenBelz]

Hi @sanderson82 ,

Without visualising your app, I am not sure this applies, but as per my earlier post, I send the ID of the main file to the document metadata, so both "know" they belong to each other.

[sanderson82]

@WarrenBelz I'm learning all sorts of new things today lol turns out a simple lookup is all I needed

LookUp(Filter('Drawing Register','Drawing Type' = "Concrete"),
Contract in I_Contract.Selected.Contract &&
Unit in I_Unit.Selected.Unit).'Drawing No'

 

[WarrenBelz]

Hi @sanderson82 ,

Just watch out that the In filter is not delegable - try

LookUp(
   Filter(
      'Drawing Register',
      'Drawing Type' = "Concrete"
   ),
   StartsWith(Contract, I_Contract.Selected.Contract) &&
   StartsWith(Unit, I_Unit.Selected.Unit).'Drawing No')
)

[sanderson82]

Thanks @WarrenBelz that helped, I have no clue when it comes to delegation etc!  Still learning 🙂