Saving name from a text field to a people/group column, how?

%3CLINGO-SUB%20id%3D%22lingo-sub-277094%22%20slang%3D%22en-US%22%3ESaving%20name%20from%20a%20text%20field%20to%20a%20people%2Fgroup%20column%2C%20how%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-277094%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20got%20a%20request%2C%20a%20strange%20one%2C%20but%20a%20request%20at%20the%20end%20of%20the%20day.%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20list%20that%20contain%20one%20column%20of%20type%20people%2Fgroup%2C%20and%20there%20is%20an%20add-in%20that%20manage%20this%20list%20(CRUD)%20and%20it%20contains%20a%20form%20to%20do%20that.%20In%20the%20form%20there%20is%20a%20input%20field%20type%20text%20where%20the%20user%20will%20write%20the%20name%20that%20will%20be%20send%20to%20the%20column%20of%20type%20people%2Fgroup.%20I%20asked%20if%20is%20it%20not%20enough%20to%20use%20a%20column%20type%20single%20text%20since%20the%20user%20that%20will%20fill%20the%20form%20knows%20already%20the%20username%20that%20wants%20to%20save%20but%20they%20say%20to%20me%20that%20in%20the%20future%20another%20task%20will%20be%20applied%20to%20this%20column%20and%20therefore%20needs%20to%20be%20of%20type%20people%2Fgroup.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20question%20is%20how%20can%20I%20save%20the%20username%20to%20the%20people%2Fgroup%20column%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3EAmerico%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-277094%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-277535%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20name%20from%20a%20text%20field%20to%20a%20people%2Fgroup%20column%2C%20how%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-277535%22%20slang%3D%22en-US%22%3E%3CP%3EI%20will%20give%20a%20chance%20to%20the%20Flow%2C%20it%20seems%20like%20it%20should%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20be%20back%20with%20the%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-277514%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20name%20from%20a%20text%20field%20to%20a%20people%2Fgroup%20column%2C%20how%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-277514%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20able%20to%20do%20something%20similar%20in%20the%20past%20by%20using%20a%20SP%20designer%20workflow.%20I%20was%20capturing%20the%20users%20email%20via%20plain%20text%20and%20then%20copying%20that%20into%20a%20person%20field%20via%20an%20Update%20Item%20step.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20certain%20if%20the%20same%20logic%20will%20work%20with%20a%20plain%20a%20First%20and%20Last%20name%2C%20I%20would%20think%20it%20would.%20One%20thing%20I%20would%20look%20out%20for%20if%20you%20go%20that%20route%20is%20if%20it's%20a%20large%20company%20with%20two%20%22John%20Brown%22s%20the%20workflow%20may%20have%20trouble%20resolving%20the%20name%20and%20error%20out.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20Flow%2C%20you%20may%20also%20want%20to%20look%20into%20the%20Resolve%20Person%20action.%20It%20seems%20like%20it%20would%20work%20the%20same%20way.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.chakkaradeep.com%2F2018%2F03%2F14%2Fvalidate-sharepoint-person-field-in-microsoft-flow%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.chakkaradeep.com%2F2018%2F03%2F14%2Fvalidate-sharepoint-person-field-in-microsoft-flow%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

Hi,

 

I got a request, a strange one, but a request at the end of the day. 

There is a list that contain one column of type people/group, and there is an add-in that manage this list (CRUD) and it contains a form to do that. In the form there is a input field type text where the user will write the name that will be send to the column of type people/group. I asked if is it not enough to use a column type single text since the user that will fill the form knows already the username that wants to save but they say to me that in the future another task will be applied to this column and therefore needs to be of type people/group.

 

So my question is how can I save the username to the people/group column?

 

Best regards

Americo

2 Replies

I've been able to do something similar in the past by using a SP designer workflow. I was capturing the users email via plain text and then copying that into a person field via an Update Item step.

 

Not certain if the same logic will work with a plain a First and Last name, I would think it would. One thing I would look out for if you go that route is if it's a large company with two "John Brown"s the workflow may have trouble resolving the name and error out. 

 

If you have Flow, you may also want to look into the Resolve Person action. It seems like it would work the same way. 

https://www.chakkaradeep.com/2018/03/14/validate-sharepoint-person-field-in-microsoft-flow/

 

 

I will give a chance to the Flow, it seems like it should work.

 

I'll be back with the results.

 

Thanks!