cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sanderson82
Helper IV
Helper IV

Attaching multiple files to SP Doc Lib with additional fields

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

15 REPLIES 15

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.

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

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.

 

@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'

 AppTest.jpg

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')
)

 

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

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (87,254)