Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Sending email collecting 2 sharepoint related list

(0) ShareShare
ReportReport
Posted on by 223

Hi All,

Good day, I have 2 sharepoint list. I can send an email with the list of submitted items. But i would like to include other information from the 2 list. For instance, i have 2 list s shown below.

 

a2.PNG

 

The above table is a relational table, Whereby whenever a submission is made on PowerApps, it goes to both sharepoint list using the ID and Uid as the relational column.

How can email be sent collecting information from both list when an item is created?

Like this

 

a3.PNG

 

Thanks.

  • Verified answer
    Re: Sending email collecting 2 sharepoint related list

    Hi @caslasgee,

    Do you want to send info from SP list2 based on the new item create in list1?

     

    vqiaqimsft_0-1688714531196.png

    And for the first html table based on the created item in list1, just repeat the above actions, and then within the email body, insert these 2 html table.

     

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,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics