cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AB1
Level: Powered On

undefined

I work in a school and i wanted to know if this is possible!

When entering a student email into a sharepoint list or a form how can i link it to a parent email from a data base, which then emails the parent instead of the student. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: undefined

Hi @AB1,

 

I have made a test on my side to two lists:

1. list "test3" with a single line of text column "student email",

2. list "test4" with a single line of text column "student email", and a single line of text column "parent email",

Capture.PNG

You could refer to screenshot below to create the flow:

Capture.PNG 

When you create an item in the sharepoint list3 as below:

Capture.PNG

 

The flow would run successfully to send the email as below:

Capture.PNG

 

 

Best regards,

Alice

 

 

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: undefined

Hi @AB1,

 

I have made a test on my side to two lists:

1. list "test3" with a single line of text column "student email",

2. list "test4" with a single line of text column "student email", and a single line of text column "parent email",

Capture.PNG

You could refer to screenshot below to create the flow:

Capture.PNG 

When you create an item in the sharepoint list3 as below:

Capture.PNG

 

The flow would run successfully to send the email as below:

Capture.PNG

 

 

Best regards,

Alice

 

 

View solution in original post

AB1
Level: Powered On

Re: undefined

Work Perfectly, thank you! 

Highlighted
AB1
Level: Powered On

Sharepoint list and excel documents

Hi Alice, 

 

Is there a way that this flow can be done with excel and sharepoint list? instead of both sharpoint lists as for some reason it works but only sometimes! i have put in 1500 enteries and only a few work weirdly!

 

So the 'get items' being the excel action is this possible?

 

can you help please!

 

Thanks,

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,367)