Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Connecting 2 SharePoint lists and sending an email

(0) ShareShare
ReportReport
Posted on by 65

Hello, I need to develop a Power App with a Power Automate flow that sends an email when a specific item is created or modified in a specific column of a SharePoint list,then include it and then send it to the people included in another SharePoint list. ( send it in a way that it looks up the people from a different SharePoint list column and then sends an email automatically (with the modified data) to a group/single of people from another SharePoint List). If you could help me I would appreciate it a lot. 🙂

  • annajhaveri Profile Picture
    annajhaveri 8,531 on at
    Re: Connecting 2 SharePoint lists and sending an email

    @Riidi  let me know what filter query you are using, i can help on that. I dont think long post will be a problem

  • Riidi Profile Picture
    Riidi 65 on at
    Re: Connecting 2 SharePoint lists and sending an email

    Hi Anna, yes, I did add the filter query parameter in the “Get items”. Still trying to figure out why it doesn’t execute it the way as it should. But I think this problem is making this community post a bit too long so I’ll try to solve it somehow different.

  • annajhaveri Profile Picture
    annajhaveri 8,531 on at
    Re: Connecting 2 SharePoint lists and sending an email

    @Riidi  from the screenshot it looks like the Get Items hasnt returned by items from the list, have you configured filter query parameter of Get Items?

  • Riidi Profile Picture
    Riidi 65 on at
    Re: Connecting 2 SharePoint lists and sending an email

    IMG_9580.jpeg

    I would love to send the full details of my flow but apparently the flow includes company details that I’m not allowed to publish. One or two things that I noticed was that I didn’t get an email and since I need to send it to the people of “people column” I have to also use “Custom value” in “Get Items” in order to access them. I think it’s better for all of us if I close this discussion and try to somehow figure it out myself. Still thank you for your help, I appreciate it.🤝

  • annajhaveri Profile Picture
    annajhaveri 8,531 on at
    Re: Connecting 2 SharePoint lists and sending an email

    @Riidi  can you share structure of your both lists, i can help you with how flow would look like

  • Riidi Profile Picture
    Riidi 65 on at
    Re: Connecting 2 SharePoint lists and sending an email

    Thank you Anna, I will try to make it happen, could you maybe also give me a brief overview of how it would look in Power Automate?

     

    Appreciate it and thank you for your help

  • annajhaveri Profile Picture
    annajhaveri 8,531 on at
    Re: Connecting 2 SharePoint lists and sending an email

    @Riidi  okay using the Get Items output from another list, you can store the email of people from another list in variable. Then use that variable in the Send Email, and within Email body you can use the current item data from Dynamic content of the trigger.

  • Riidi Profile Picture
    Riidi 65 on at
    Re: Connecting 2 SharePoint lists and sending an email

    As of right now I need to send one single e Mail, containing data of the individual item in the list.

  • annajhaveri Profile Picture
    annajhaveri 8,531 on at
    Re: Connecting 2 SharePoint lists and sending an email

    @Riidi  do you need to send one single email to multiple people from another list or individual email to multiple people or is it just one person?

  • annajhaveri Profile Picture
    annajhaveri 8,531 on at
    Re: Connecting 2 SharePoint lists and sending an email

    @Riidi yes you need to add Send Email action, and the data you want to send in email you will find the dynamic content 

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard