cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Find data in a spreadsheet and populating "to" and "cc" fields in an Outlook email

I am looking to use information pulled from a Microsoft Form to auto populate the "to" and "cc" fields in an auto generated email that will be sent to multiple people. The information pulled from the form will be a users name and I want it to pull their email address and their managers email address from a single spreadsheet located in my  OneDrive. All of this information is stored on the same row in the spreadsheet. Is this possible? 

 

Thanks,

Gabe

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Find data in a spreadsheet and populating "to" and "cc" fields in an Outlook email

Hi @Anonymous ,

 

Do you want to find the information of the corresponding row in Excel table by the name submitted by the user in MS Forms?

If so, you could try the following method.

Prerequisites:

1. Spreadsheet has defined the Excel table.

2. The username has a unique value so that it can be used as key column to get the value of the corresponding row.

 

  • Use the username submitted in MS Forms as the key value.
  • Configure Get a row to get the information of the corresponding row, and then configure the content in email action.

Image reference:

5.PNG

Hope it helps.

 

Edit: The actions in Excel Online(Business)and Excel Online (OneDrive) are basically the same. You could select the same action in Excel Online (OneDrive) when configuring.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Find data in a spreadsheet and populating "to" and "cc" fields in an Outlook email

Hi @Anonymous ,

 

Do you want to find the information of the corresponding row in Excel table by the name submitted by the user in MS Forms?

If so, you could try the following method.

Prerequisites:

1. Spreadsheet has defined the Excel table.

2. The username has a unique value so that it can be used as key column to get the value of the corresponding row.

 

  • Use the username submitted in MS Forms as the key value.
  • Configure Get a row to get the information of the corresponding row, and then configure the content in email action.

Image reference:

5.PNG

Hope it helps.

 

Edit: The actions in Excel Online(Business)and Excel Online (OneDrive) are basically the same. You could select the same action in Excel Online (OneDrive) when configuring.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

Top Solution Authors
Top Kudoed Authors
Users online (7,339)