Solved

Compleate field in a library after use Document Generation in a list


Badge +2

I have created a LIST with several columns, four of them are person type (Initiator, Reviewer, Validator and Approver). When the initiator adds a new item in the list, it automatically starts running a workflow in the list and creates a document in a LIBRARY with "Document Generation".

 

The document is created without any problem in the library, but in this library I have the same four columns (Initiator, Reviewer, Validator and Approver) and when creating the document the data that has been filled in the list is not completed.

 

<<I would like to fill these four columns of the library with the same values that are in the list>>

 

I tried to take the ID of the item in the list to compare it with the ID of the document created in the library, as well as with the GUID and then make a "Set (or) Update List Item" in the library and in no case do the identifiers match :(

 

Please, does anyone have any idea how to do this?
Please can you help me? @vadim_tabakman , @SamSysum , @DocGenVinnie 
Thanks in advance.

 

This is my list:

2866i50D56E6EAD4C1E3C.png

 

And this is my library:

2867i7DC922CB9DBAEE54.png

 

icon

Best answer by kmedina 16 September 2019, 11:28

View original

4 replies

Badge +4
From the document generation you can get as output the: file URL.

Have you tried to put in the Where condition of the action: Update List item, Source URL with the output of File URL? Not completely sure if this works.
Badge +8

I want to do something similar. When Generate Document creates the document in the document library, I want to update some columns in that library. Unfortunately the "Created by" column is not useful because it is set to "SharePoint App" rather than by the user who launched the workflow. 


 


I want to create a view that will display "My Items" for the user, rather than "All items."


 


I will try that "file URL"  that was mentioned and see if I can update the column.

Badge +8

Success!  After the "Generate Document" action, I used the "Update List Item" action with these parameters:


 


Target List = the name of the document library where the Generate Document created the PDF


Where column "Name (for use in forms)" = the name of the PDF generated in previous action (I used the same formula for both)


 


Then I set List Item Properties to the column that stores the user's name.  In my new view, I will filter by that user name.

Badge +2

Hello everyone.


I was able to solve my problem by saving the name of the document in a variable after the Document generation, with a "Set variable" I painted the document extension. Then with the action "Update list item" I applied a name filter indicating the name with extension previously saved and finally indicated the columns that I wanted to update the data and did it satisfactorily.


Please, dont hesitate to contact me in case of any doubt.


 



 



 


 



 

Reply