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. 🙂
@Riidi let me know what filter query you are using, i can help on that. I dont think long post will be a problem
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.
@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?
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.🤝
@Riidi can you share structure of your both lists, i can help you with how flow would look like
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
@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.
As of right now I need to send one single e Mail, containing data of the individual item in the list.
@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?
@Riidi yes you need to add Send Email action, and the data you want to send in email you will find the dynamic content