Assigned to column in Sharepoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-1381410%22%20slang%3D%22en-US%22%3EAssigned%20to%20column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1381410%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20manual%20list%20(without%20using%20the%20Issue%20Tracking%20List)%20and%20need%20to%20add%20the%20'Assigned%20To'%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20this%20through%20PowerApp%20as%20I%20know%20through%20Sharepoint%20it%20does%20not%20give%20an%20option%20unless%20using%20the%20Out%20of%20The%20Box%20Issue%20Tracking%20App.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1381410%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1395986%22%20slang%3D%22en-US%22%3ERe%3A%20Assigned%20to%20column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1395986%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663412%22%20target%3D%22_blank%22%3E%40Mo_Islam%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20a%20little%20unclear%20on%20your%20question...%20In%20a%20SharePoint%20custom%20list%2C%20you%20can%20add%20a%20%22People%22%20type%20field%20and%20call%20it%20AssignedTo%20(or%20whatever).%20Or%20are%20you%20looking%20for%20something%20else%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397146%22%20slang%3D%22en-US%22%3ERe%3A%20Assigned%20to%20column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397146%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F16657%22%20target%3D%22_blank%22%3E%40Sandy%20Ussia%3C%2FA%3E%26nbsp%3BHi%2C%20I've%20figured%20out%20that%20I%20need%20to%20add%20the%20'People'%20field%20which%20will%20search%20for%20email%2C%20but%20not%20sure%20how%20to%20notify%20the%20user.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Issue%20Tracking%20app%2C%20this%20is%20done%20for%20you%20where%20an%20email%20with%20all%20the%20list%20details%20is%20sent%20to%20the%20Assigned%20user%2C%20but%20I%20don't%20know%20how%20to%20do%20it%20if%20I%20am%20creating%20this%20under%20the%20'List'%20application.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1404364%22%20slang%3D%22en-US%22%3ERe%3A%20Assigned%20to%20column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1404364%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663412%22%20target%3D%22_blank%22%3E%40Mo_Islam%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECreate%20a%20Power%20Automate%20Flow%20to%20notify%20the%20user.%20Consider%20the%20%22Send%20a%20customized%20email%20when%20a%20new%20SharePoint%20list%20item%20is%20added%22%20template%20as%20a%20starting%20point.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1692065%22%20slang%3D%22en-US%22%3ERe%3A%20Assigned%20to%20column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1692065%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20give%20an%20example%20of%20how%20to%20send%20email%20notifications%20to%20a%20person%20in%20an%20%22assigned%20to%22%20identify%20field%20if%20a%20specific%20record%20that%20their%20identity%20is%20selected%20in%20that%20field%20-%20is%20created%20or%20changed%20please.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20learning%20Power%20Automate%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1715078%22%20slang%3D%22en-US%22%3ERe%3A%20Assigned%20to%20column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715078%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F801576%22%20target%3D%22_blank%22%3E%40geoffhicks%3C%2FA%3E%26nbsp%3BI%20recommend%20using%20the%20new%20item%20trigger.%20There%20are%20risks%20using%20the%20edited%20item%20trigger%2C%20because%20you%20could%20happen%20to%20face%20a%20situation%20where%20the%20same%20%22assignedTo%22%20user%20is%20getting%20spammed.%3CBR%20%2F%3E%3CBR%20%2F%3E1.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Femea.flow.microsoft.com%2Fen-us%2Fgalleries%2Fpublic%2Ftemplates%2F1f8edba0b70e11e68af78d1a54677f1f%2Fsend-an-email-when-a-new-item-is-created-in-sharepoint%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Femea.flow.microsoft.com%2Fen-us%2Fgalleries%2Fpublic%2Ftemplates%2F1f8edba0b70e11e68af78d1a54677f1f%2Fsend-an-email-when-a-new-item-is-created-in-sharepoint%2F%3C%2FA%3E%26nbsp%3B%2C%20use%20this%20template%2C%20it%20will%20be%20triggered%20when%20a%20new%20item%20is%20created.%20When%20that%20item%20is%20created%2C%20check%20if%20the%20%22assigned%20to%22%20is%20populated%20(not%20empty).%20If%20it%20has%20a%20user%20value%2C%20email%20that%20specific%20user.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EIf%20you%20need%20further%20assistance%2C%20please%20notify%20me%20and%20I%20will%20gladly%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1717622%22%20slang%3D%22en-US%22%3ERe%3A%20Assigned%20to%20column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1717622%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F801576%22%20target%3D%22_blank%22%3E%40geoffhicks%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%20for%20the%20delayed%20response.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F284426%22%20target%3D%22_blank%22%3E%40ArefHalmstrand%3C%2FA%3E%26nbsp%3Bresponse%20makes%20sense%20to%20me.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20%22Create%20item%22%20trigger%20will%20send%20the%20email%20to%20the%20assigned%20person.%20Make%20sure%20your%20list%20makes%20%22Assigned%20to%22%20required.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20are%20other%20options%20and%20more%20advanced%20patterns%20that%20you%20can%20consider.%20I.e.%20you%20can%20manually%20initiate%20a%20message%20or%20action%20to%20the%26nbsp%3B%22Assigned%20to%22%20using%20a%20Power%20Automate%20%22button%22.%20You%20could%20also%20use%20the%20%22Create%20or%20modify%22%20trigger%20to%20take%20action%20based%20on%20certain%20value%20changes.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI've%20been%20documenting%20the%20Power%20Automate%20patterns%20that%20I%20use%20on%20my%20%3CA%20href%3D%22https%3A%2F%2Fnormyoung.ca%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eblog%3C%2FA%3E.%20They%20could%20serve%20as%20a%20reference%20for%20you.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

 

I created a manual list (without using the Issue Tracking List) and need to add the 'Assigned To' function.

 

Is there a way to do this through PowerApp as I know through Sharepoint it does not give an option unless using the Out of The Box Issue Tracking App.

 

Thank you in advance

6 Replies
Highlighted

Hi @Mo_Islam,

 

I'm a little unclear on your question... In a SharePoint custom list, you can add a "People" type field and call it AssignedTo (or whatever). Or are you looking for something else?

 

 

Highlighted

@Sandy Ussia Hi, I've figured out that I need to add the 'People' field which will search for email, but not sure how to notify the user.

 

In the Issue Tracking app, this is done for you where an email with all the list details is sent to the Assigned user, but I don't know how to do it if I am creating this under the 'List' application.

Highlighted

Hi @Mo_Islam,

 

Create a Power Automate Flow to notify the user. Consider the "Send a customized email when a new SharePoint list item is added" template as a starting point.

 

I hope this helps.

 

Norm

Highlighted

@Norman Young 

 

Could you give an example of how to send email notifications to a person in an "assigned to" identify field if a specific record that their identity is selected in that field - is created or changed please.

 

I am learning Power Automate

 

 

Highlighted

@geoffhicks I recommend using the new item trigger. There are risks using the edited item trigger, because you could happen to face a situation where the same "assignedTo" user is getting spammed.

1. https://emea.flow.microsoft.com/en-us/galleries/public/templates/1f8edba0b70e11e68af78d1a54677f1f/se... , use this template, it will be triggered when a new item is created. When that item is created, check if the "assigned to" is populated (not empty). If it has a user value, email that specific user.

If you need further assistance, please notify me and I will gladly help.

Highlighted

Hi @geoffhicks,

 

Sorry for the delayed response. @ArefHalmstrand response makes sense to me.  

 

The "Create item" trigger will send the email to the assigned person. Make sure your list makes "Assigned to" required.

 

There are other options and more advanced patterns that you can consider. I.e. you can manually initiate a message or action to the "Assigned to" using a Power Automate "button". You could also use the "Create or modify" trigger to take action based on certain value changes.

 

I've been documenting the Power Automate patterns that I use on my blog. They could serve as a reference for you.

 

I hope this helps.

 

Norm