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 ,

A couple of things first - Attachments to SharePoint lists do not have the ability to store metadata - the only thing you are really in control of the file name.

If you are talking about files stored in a SharePoint Library, then that is another matter - metadata can certainly be stored.

As for versions, here is an article that may help you.

I am not sure what level of guidance you are asking for in you post, but I am happy to point you in the direction of information that will assist you in your PowerApps journey.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[sanderson82]

Hi @WarrenBelz  thanks for your reply.  And yes, what I want to achieve is metadata stored in a document library along with the file (PDF).

My app has 2 drop downs, Contract and Unit ID.  I would want to select the appropriate Contract and Unit ID, attach the PDF that I want to upload and then repeat this process for however many drawings (PDFs) I need to upload.

Fields within the Document Library would be 
Contract   Unit    Title   Version

[WarrenBelz · Accepted solution]

Hi @sanderson82 ,

Firstly, watch this video from Shane Young @Shanescows 

If you run into issues after this, please advise and I will try to assist.

The other thing you might consider for bulk loading, is that it may be just as easy for the user to file directly in SharePoint and add the metadata.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[sanderson82]

Hi @WarrenBelz  that is the video I had been watching.  I have a screenshot below of my progress following @Shanescows instructions.  I'm just about to work on the flow element.  I still think this solution will only let me upload one at a time unless I have some sort of ForAll or loop in the flow to go through all items in a collection, this part I'm unsure of.  I'm wondering would it be easier for my button to trigger a flow, and upload one item, reset all fields, but show filtered items from the document library by modified date (or something similar) in a gallery as a way of knowing that the file was uploaded correctly?

[WarrenBelz]

Hi @sanderson82 ,

There are two options for loading more than one file - as you have suggested a ForAll looping through a collection of images and run a flow for each or send an array (some JSON required here) and do an "Apply to Each" in the Flow.

Your suggested approach is exactly what I do - they are site photos in the field and the user checks every one before proceeding (you cannot recreate the "before" photo after you have done the job).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[sanderson82]

@WarrenBelz I have the file upload working based on the video however I'm unsure how to pass the additional metadata fields from the app into the same new item on the document library? ie Contract and Unit Type from the drop downs

[sanderson82]

@WarrenBelz   Just another quick update, I have the metadata part working using "Update file properties" in flow referencing the ItemId from "Create File" in the previous step.  Things are only easy when you know how! lol

[WarrenBelz]

That is great @sanderson82 ,

Saved me a mail (Dinner time here in Oz).

I also have some processes for viewing the files, including on mobile devices.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[sanderson82]

@WarrenBelzat the moment the solution I'm working on is so that I can reference the file name of the drawing in another app for producing check sheets.

It is my plan however down the line to also make these drawing available to search and view so I would be very interesting in how you have achieved this