Pulling properties from a list

%3CLINGO-SUB%20id%3D%22lingo-sub-1374483%22%20slang%3D%22en-US%22%3EPulling%20properties%20from%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374483%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20working%20with%20a%20customer%20that%20has%20a%20SharePoint%20(2013)%20list%20and%20associated%20form%2Fworkflow%20for%20requesting%20a%20new%20server%20built%20in%20their%20VMware%20farm.%20The%20workflow%20is%20user%20fills%20out%20the%20form%2C%20SP%20emails%20the%20team%20responsible%20for%20approving.%20Someone%20reviews%20and%20approves%20the%20build%2C%20and%20a%20column%20in%20the%20list%20titled%20Approved%20is%20set%20to%201.%20I%20then%20have%20automation%20that%20pulls%20all%20servers%20in%20that%20list%20where%20%22Approved%20%3D%201%22%20and%20builds%20those%20servers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPart%20of%20the%20automation%20creates%20a%20request%20in%20the%20customer's%20ticketing%20system%2C%20to%20track%20the%20build.%20I%20have%20been%20asked%20to%20add%20the%20name%20of%20the%20person%20who%20approves%20the%20server%20build%20to%20the%20request%2C%20but%20must%20admit%20I%20am%20unsure%20how%20to%20do%20this.%20I%20am%20not%20a%20SharePoint%20guy%20by%20any%20means%2C%20but%20have%20pulled%20all%20properties%20from%20the%20list%2C%20and%20do%20not%20see%20anything%20that%20correlates%20to%20%22approver%22%20or%20%22approved%20by%22.%20I%20see%20an%20editor%20property%2C%20but%20that%20is%20not%20always%20the%20same%20as%20the%20person%20who%20approved%20it.%20I%20can%20see%20in%20the%20workflow%20the%20name%20of%20the%20user%20who%20approved%20the%20server%2C%20just%20not%20sure%20how%20to%20grab%20that%20and%20work%20with%20it.%20Any%20suggestions%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1374483%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerShell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1375156%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20properties%20from%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1375156%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660938%22%20target%3D%22_blank%22%3E%40JLogan3o13%3C%2FA%3E%26nbsp%3BIf%20i%20understand%20you%20problem%20let%20me%20reiterate%20so%20that%20can%20help%20you%20wit%20some%20options%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20want%20to%20capture%20the%20Approved%20by%20person%20name%20and%20use%20it%20in%20the%20next%20automation%20process.%20As%20Last%20Modified%20By%20person%20not%20exactly%20the%20person%20who%20always%20approves%20because%20there%20might%20be%20further%20updates%20after%20the%20approval.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20first%20thing%20is%20to%20capture%20the%20approved%20by%20in%20column%20is%20needed%20to%20ensure%20you%20always%20get%20the%20good%20data%20this%20will%20be%20fail%20proof%3A%3C%2FP%3E%3CP%3EStep%201%3A%20Create%20a%20column%20named%20as%20Approved%20By%20make%20this%20as%20people%20picker%3C%2FP%3E%3CP%3EStep%202%3A%20Modify%20the%20workflow%20and%20check%20if%20the%20Approved%20%3D1%20and%20Approved%20By%20is%20empty%20then%20set%20the%20modified%20value%20in%20to%20the%20Approved%20By%20Column%3C%2FP%3E%3CP%3EThe%20step%202%20will%20ensure%20who%20ever%20changes%20the%20status%20Approved%20%3D1%20for%20the%20first%20time%20sets%20him%20as%20the%20Approver%20and%20this%20field%20can%20be%20used%20for%20your%20automation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps.%20Please%20mark%20the%20response%20appropriately%20if%20it%20helps%20in%20finding%20the%20resolution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVikram%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Visitor

I am currently working with a customer that has a SharePoint (2013) list and associated form/workflow for requesting a new server built in their VMware farm. The workflow is user fills out the form, SP emails the team responsible for approving. Someone reviews and approves the build, and a column in the list titled Approved is set to 1. I then have automation that pulls all servers in that list where "Approved = 1" and builds those servers.

 

Part of the automation creates a request in the customer's ticketing system, to track the build. I have been asked to add the name of the person who approves the server build to the request, but must admit I am unsure how to do this. I am not a SharePoint guy by any means, but have pulled all properties from the list, and do not see anything that correlates to "approver" or "approved by". I see an editor property, but that is not always the same as the person who approved it. I can see in the workflow the name of the user who approved the server, just not sure how to grab that and work with it. Any suggestions would be greatly appreciated.

1 Reply
Highlighted

@JLogan3o13 If i understand you problem let me reiterate so that can help you wit some options:

 

You want to capture the Approved by person name and use it in the next automation process. As Last Modified By person not exactly the person who always approves because there might be further updates after the approval.

 

So first thing is to capture the approved by in column is needed to ensure you always get the good data this will be fail proof:

Step 1: Create a column named as Approved By make this as people picker

Step 2: Modify the workflow and check if the Approved =1 and Approved By is empty then set the modified value in to the Approved By Column

The step 2 will ensure who ever changes the status Approved =1 for the first time sets him as the Approver and this field can be used for your automation.

 

Hope this helps. Please mark the response appropriately if it helps in finding the resolution.

 

Vikram