Updating a doc library column base on a change in a list library.

M
Badge +8

I have a SP list in SP 2010 which has attachments for each item. I want to store these attachment in a separate document library which I have achieved.

I now need to set up a process where a certain condition (using action wait for item upload) occurs in the SP list that for the relevant attachment  the column "completed" in the doc library is set to yes.

Any ideas? In the SP list I have created a WF to update the item but I keep getting error with no reason.

10 replies

C
Badge +8

So do you wish to update a column in SP List once the attachment in the SP list is successfully uploaded to a SP Library?

P
Badge +7

Same question happy.png... 

M
Badge +8

At a certain point in the process when a column is updated in the SP list, a notification workflow sends an email to the SP document library. The library is set up to only show the attachments.

Then later in the process back in the list library, the attachment of the item is reviewed/edited. When the review/action has completed a field "completed" is set to yes. What I want is the document Libary to also update so I can see the task is completed. i.e. a duplicate of the completed field in the the list library.

I hope this make sense.

Thanks

P
Badge +7

Dear,

Why don't you use "Copy to SharePoint" action so you copy your SP List Form attachments to an SP Library and at every time you update (Review,edit...) the attachments in the lists, you recall this action to update the attachments in the Library?

C
Badge +8

Can you share the details of the error which is encountered on SP List item update?

FYI,

Requirement: Whenever the review/action is completed a field "Completed" is set to Yes in SP List, and when this field is set a similar field in SP Library also needs to be set.

Solution: Configure a Nintex workflow in the SP List which is triggered when field Completed=Yes to update the similar field in SP Library.

NOTE: Ensure you have a logic to find out the attachment of the SP List in the SP Library

200697_pastedImage_1.png

200698_pastedImage_2.png

M
Badge +8

Thanks, all I will try these

Is there a way to pull the attachment name into a column? I need the attachment name to match the column on the list and doc libraries.

P
Badge +7

You need to do this through Workflow

M
Badge +8

Please, can you advise how?

Thanks

C
Badge +8

Maintain a Primary Key and Foreign Key references on the SP List and SP Library, in this you will be able to track attachments both ways.

Example:

  1. On the SP List create column named ListID with unique values only and store data like <<Title>>_<<ID>> etc. 
  2. On the SP Library create LookUp column named RefListID pointing to above-created column
  3. When an attachment from the SP List is added to SP Library update the above lookup column
M
Badge +8

Hi all

Many thanks for your help. I found the issue. There was a double entry in one of the update mutiple items fields.

The workflow now works.

Thanks

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings