Skip to main content

Notifications

Power Platform Community / Forums / Using Flows / Send an Email after a ...
Using Flows
Unanswered

Send an Email after a Sharepoint Item is created to a Person based on another Sahrepoint list

Posted on by 17
Hello Power Auotmate Community,

What we would like to do is to generate an Email from a shared mailbox after a new Sharepoint Iteam is created. 
The special requiremnt is, that the Mail needs to be send to multiple persons based on another sharepoint list, where Keyusers get assigned to there module. 
 
The Process looks as follows:
1.) Via Forms a Customer submits a request to a certain module (For example "SD/BI Sales and Distribution")

2.) The flow creates the sharepoint item, then at the end of the flow there is a look up where the flow checks which module is used and then checks the additional sharepoint list, to see who is assigned to the Module.

 
3.) Mail gets send to the responsible persons (keyusers) of the module (In this case a mail to Person A and B)

Our current solution looks like this:


After the Sharepoint item is created, we use the "get items" as well as the selct function to get the content of the sharepoint list with the responsible Keyusers.
Afterwards we use the filterarray function to get only the Keyusers of the module which is related to the forms request

Next step is the Compose Action where we extract the mail of the Keyuser of the module

Lastely we send an email to the Output of the compose Action


The problem with that flow is, that it does not send on joined mail, but it sends out 20 (amount of moudles in the list) mails to the responsible Keyusers. 
How do we need to adjust our flow, so that we are just sending out one email to 2,3,xyz Keyusers who are listed in the sharepoint responsible list.

Best regards,
 
  • Smilo Profile Picture
    Smilo 17 on at
    Send an Email after a Sharepoint Item is created to a Person based on another Sahrepoint list
    Hi FLMike,

    1.) I'm not using any filter for the Get Items (i would like to filter here but have no idea how to. I would like to only get the items where the value from my response, in this case "Titel" is equal to content of "column titel" How could that be done?


    2.) Need to see the Select



    3.) Need to see the Input to the For Each



    I understand where the issue with that solution is, but it feels like I'm blind to find the solution :D
     
  • FLMike Profile Picture
    FLMike 26,162 on at
    Send an Email after a Sharepoint Item is created to a Person based on another Sahrepoint list
    Hi,
     
    1. need to see the Get Items Filter
    2. Need to see the Select
    3. Need to see the Input to the For Each1
     
    You are most likely using the Body/Value of the Get Items as the Input to your For Each 1, that is the only reason it would do what you said.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

September 2024 Newsletter…

September 2024 Community Newsletter…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 141,065

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,407

Leaderboard

Featured topics

Restore a deleted flow