Need help with formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3217150%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217150%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENeed%20help%20with%20creating%20a%20formula%20that%20would%20link%20task%20to%20a%20specific%20person%20based%20on%20the%20requestor.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20scenario%3A%26nbsp%3B%20I%20have%20a%20client%20who%20has%20multiple%20offices.%26nbsp%3B%20We'll%20say%206%20for%20the%20purpose%20of%20this%20discussion.%26nbsp%3B%20I%20have%203%20employees%20who%20will%20support%202%20offices%20each.%26nbsp%3B%20I%20need%20a%20formula%20for%20my%20sharepoint%20list%20that%20would%20automatically%20populate%20the%20employee's%20name%20(email)%20based%20on%20the%20office%20ID.%26nbsp%3B%20So%20for%20example%2C%3C%2FP%3E%3CP%3EIf%20Office%20ID%20Value%20%3D%20XXX%20then%20Emloyee%26nbsp%3B%20is%20xxx.%26nbsp%3B%20The%20employee%20column%20will%20be%20a%20people%2Fgroup%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20help%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3217150%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3222139%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3222139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318718%22%20target%3D%22_blank%22%3E%40HeyCanYouHelpMe%3C%2FA%3E%26nbsp%3BYou%20cannot%20populate%20Person%20or%20Group%20column%20using%20formulas%20in%20SharePoint.%20First%2C%20you%20can%20create%20a%20list%20with%20offices%20%26amp%3B%20support%20user%20details%20then%20you%20can%20achieve%20this%20using%20two%20ways%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Add%20lookup%20column%20from%20above%20list%20in%20your%20current%20list%2C%20customize%20the%20SharePoint%20list%20form%20using%20Power%20Apps%20and%20populate%20the%20person%20or%20group%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Run%20Power%20automate%20flow%20on%20item%20creation%2Fitem%20update%20and%20populate%20the%20person%20or%20group%20column%20based%20on%20office%20selection.%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%26nbsp%3B%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%26nbsp%3B%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Community,

 

Need help with creating a formula that would link task to a specific person based on the requestor.

 

Here's the scenario:  I have a client who has multiple offices.  We'll say 6 for the purpose of this discussion.  I have 3 employees who will support 2 offices each.  I need a formula for my sharepoint list that would automatically populate the employee's name (email) based on the office ID.  So for example,

If Office ID Value = XXX then Emloyee  is xxx.  The employee column will be a people/group column. 

 

Can you help me?

2 Replies

@HeyCanYouHelpMe You cannot populate Person or Group column using formulas in SharePoint. First, you can create a list with offices & support user details then you can achieve this using two ways:

 

1. Add lookup column from above list in your current list, customize the SharePoint list form using Power Apps and populate the person or group column.

 

2. Run Power automate flow on item creation/item update and populate the person or group column based on office selection.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

@ganeshsanap thanks for the reply.  I created a list and named it Office Support.  Can you share how I would run Power automate flow on item creation/item update and populate the person or group column based on office selection. 

What data should I add to the Office Support list in order for the flow to work?  

 

I'm sorry but I'm a newbie at this.