Forum Discussion

HeyCanYouHelpMe's avatar
HeyCanYouHelpMe
Copper Contributor
Feb 26, 2022

Need help with formula

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...
developer
SharePoint Online
ganeshsanap's avatar
ganeshsanap
MVP
Feb 28, 2022

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.

HeyCanYouHelpMe's avatar
HeyCanYouHelpMe
Copper Contributor
Feb 28, 2022

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. 

Resources