0

Hi SharePoint Developer experts,

We have one document library and one List on SharePoint 2013. Users update list daily base. There are two column on the list with name as "Document Title" and "Status". On other hand document library, we have nearly 100+ documents with "Document Title", "ID", "Status" etc columns. Our requirement was, when user add or click save option on the "List", items need to check "Document Title" name on the document library, if "Document title" name match, then "Status" data need to update on the document library. Can anyone please help out on the request.

enter image description here

0

You can use a SharePoint Designer workflow for that. Create a workflow on the list that runs when a list item is modified. Let the workflow find the document in the library, using the title (which must be a unique value!!), then write the status from the list item into the document.

| improve this answer | |
  • Thanks Teylyn. if possible, could you please share the steps for workflow. Or guide me with conditions on workflow. – murali kuruva Jun 29 at 5:40
0

Teylyn's reply is correct and have the basic structure. Update list item action has the part to find your required file/item in another list with the identifier. In your scenario, the identifier is the document title.

So the workflow is triggered when item is created/modified and associated with the list. Then we have a the document title value of current item. enter image description here

Some workflows examples for your reference: http://www.benprins.net/2017/03/13/sharepoint-2013-workflow-check-if-list-item-exists/

Workflow for checking if item exist in another list

| improve this answer | |
  • Sorry jerry i am not getting you. Our request, "status" column data need to update when document titles names match. Means when user add or click save option on the "List", items need to check "Document Title" name on the document library, if "Document title" name match, then "Status" data of list item need to update on the document library. Please share workflow steps. Thanks for support – murali kuruva Jun 29 at 6:28
  • @murali, it seems you are not quite familiar about the workflow actions. The update list item action supports updating library files too. It will fetch the library data and find the file has the correct value according to the settings in "Find the list item" part in my screenshot. For how to use this action, you can have a check on this thread:social.msdn.microsoft.com/Forums/lync/en-US/… – Jerry_MSFT Jun 29 at 6:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.