SOLVED

Request Sign-Off on SharePoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-2644573%22%20slang%3D%22en-US%22%3ERequest%20Sign-Off%20on%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2644573%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20SharePoint%20List%20and%20one%20of%20the%20columns%20include%20%22Approved%20By%22%20and%20this%20is%20a%20column%20where%20you%20can%20add%20a%20users%20name%20from%20the%20system.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20this%2C%20I%20want%20to%20%22request%20a%20sign-off%22%20but%20I%20would%20like%20for%20the%20approvers%20name%20to%20be%20automatically%20populated%20from%20the%26nbsp%3B%22Approved%20By%22%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20that%20possible%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20assistance%20is%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2644573%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2645008%22%20slang%3D%22en-US%22%3ERe%3A%20Request%20Sign-Off%20on%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2645008%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1050788%22%20target%3D%22_blank%22%3E%40drishm13%3C%2FA%3E%26nbsp%3Bnot%20within%20SharePoint%20itself%2C%20you%20would%20need%20a%20flow%20in%20Power%20Automate%20(triggered%20by%20a%20JSON-formatted%20button%20in%20a%20column%20in%20your%20list)%20with%20a%20start%20and%20wait%20for%20approval%20action%20which%20sends%20an%20adaptive%20card%20by%20email%20and%20Teams%20to%20the%20approver.%20Once%20the%20approver%20has%20clicked%20the%20relevant%20decision%20button%20and%20added%20their%20comments%20the%20flow%20then%20updates%20the%20list%20with%20the%20approver's%20name%2C%20date%20of%20decision%20and%20comments.%20We%20use%20this%20for%20example%20for%20when%20staff%20request%20software%20to%20be%20purchased%20and%20installed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I created a SharePoint List and one of the columns include "Approved By" and this is a column where you can add a users name from the system.

 

From this, I want to "request a sign-off" but I would like for the approvers name to be automatically populated from the "Approved By" column.

 

Is that possible? 

Any assistance is appreciated. 

 

Thank you. 

1 Reply
best response confirmed by drishm13 (New Contributor)
Solution

@drishm13 not within SharePoint itself, you would need a flow in Power Automate (triggered by a JSON-formatted button in a column in your list) with a start and wait for approval action which sends an adaptive card by email and Teams to the approver. Once the approver has clicked the relevant decision button and added their comments the flow then updates the list with the approver's name, date of decision and comments. We use this for example for when staff request software to be purchased and installed.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User