SOLVED

SharePoint Online send email on Column Person / Group

%3CLINGO-SUB%20id%3D%22lingo-sub-2085712%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20send%20email%20on%20Column%20Person%20%2F%20Group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2085712%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I've%20created%20list%20and%20using%20column%20person%20%2F%20group%20on%20sharepoint%20online%20but%20how%20to%20send%20email%20to%20that%20person%20is%20assigned%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20Think%20using%20powerautomate%20but%20can%20anyone%20help%20to%20configure%20on%20powerautomate%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2085712%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2085828%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20send%20email%20on%20Column%20Person%20%2F%20Group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2085828%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F919315%22%20target%3D%22_blank%22%3E%40lucasignatius%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20you%20can%20achieve%20this%20using%20Power%20Automate.%20You%20can%20add%20trigger%26nbsp%3B%3CSTRONG%3EWhen%20an%20item%20is%20created%20or%20modified%3C%2FSTRONG%3E%20in%20your%20flow.%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20add%20%22Send%20an%20Email%20(V2)%22%20action%2C%20in%20%22To%22%20select%20%22Assigned%20To%20Email%20address%22%20from%20dynamic%20properties%20from%20above%20trigger.%3C%2FP%3E%3CP%3ESomething%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22power%20automate%20send%20email.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F248484i256D867173D5093F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22power%20automate%20send%20email.JPG%22%20alt%3D%22power%20automate%20send%20email.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSTRONG%3EReference%3C%2FSTRONG%3E%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Power-Apps%2FPower-Automate-how-to-trigger-an-email-workflow-when-Assigned-To%2Ftd-p%2F613920%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EPower%20Automate%20-%20how%20to%20trigger%20an%20email%20workflow%20when%20'Assigned%20To'%20value%20is%20changed%20to%20another%20'Assigned%20to'%20value%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%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
Contributor

Hi, I've created list and using column person / group on sharepoint online but how to send email to that person is assigned ? 

I Think using powerautomate but can anyone help to configure on powerautomate?

 

Thanks 

4 Replies
best response confirmed by lucasignatius (Contributor)
Solution

@lucasignatius 

 

Yes, you can achieve this using Power Automate. You can add trigger When an item is created or modified in your flow. 

Then add "Send an Email (V2)" action, in "To" select "Assigned To Email address" from dynamic properties from above trigger.

Something like this:

power automate send email.JPGReferencePower Automate - how to trigger an email workflow when 'Assigned To' value is changed to another 'As... 


Please click Mark as Best Response 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 

Okey, it work, but I'm using send email (v2)

But if want to add new list on share point , like this :

if category A : will be sent email to email person 1

if category B : will be sent email to email person 2

if category C : will be sent email to email person 3

 

because now, it must be manually to assign person , and i need to automatically based on category choose.

 

And my list oh sharepoint (below is my screenshoot)

Sharepoint Category.PNG

 

I'm just create on powerautomate like this (below is my screenshoot)

Send Email PowerAutomate.PNG

@lucasignatius 

 

For your requirements, you can use Switch action in your flow. Add switch action on Category field, create a case for each category value and then send email to particular user based on category selection. 

 

Your flow should look something like this (Image only for reference):


search-by-service-switch

You can find more details about switch action at:

  1. Search by service when you build flows and other new features 
  2. 3 ways to build multiple conditions in Microsoft Flow 

Please click Mark as Best Response 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 

This case is solved

Thanks anyway for your help it very usefully for me