Unanswered

Connecting 2 SharePoint lists and sending an email

(0) Share

Report

Posted on by Riidi

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. 🙂

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (0)

Sort by

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Riidi you can create a automated flow with trigger "When item is created or modified". Then you can add Get Changes action using which you can see if that specific column has changed or not. Then you can use Get Items action to get data from another list using filter query to get the matching item from another list.

Was this reply helpful? Yes No
Riidi 65 on at

Like (0)

Report
Copy link

Link copied!

Hi Anna, the first part seems good to me , do I just have to add then as a next step “The outlook , send email” function? How can I also include that data in the email( Outlook mail)?.

ps: I’m a Newbie so if it sounds like something obvious, then know that I’m not that experienced yet.;)

Was this reply helpful? Yes No
Riidi 65 on at

Like (0)

Report
Copy link

Link copied!

I have to send the data to the people in “people column” in a different list.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
Riidi 65 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Riidi 65 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Riidi 65 on at

Like (0)

Report
Copy link

Link copied!

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.🤝

Was this reply helpful? Yes No