cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
digitalstore00
Regular Visitor

Send email by using Excel online data

Hi,

I hope my flow is like this
1. After I receive an email from a sender
2. The sender email address will be stored in "Customer Email" column in Excel online

3. Then I would like to reply to the sender email address, using the data in the Excel online

digitalstore00_0-1625108657830.png


Here is the details of my flow Excel online

digitalstore00_1-1625108811835.png

I wish I have received the sender "aaa@outlook.com" email, it will store the sender email address in "Customer Email"
Then, I will reply back to "aaa@outlook.com" by using the data of Column A, B and C
Which i will reply back
A: abc
B: def
C: ghi

digitalstore00_0-1625109447199.png

 


Note: "Customer email" is dynamic, it will be inserted after the sender sent me
The data in column A, B and C are fixed

But i'm here facing a problem
In my Excel, after the "aaa@outlook.com" inserted in the column, the data of Column A, B and C can't be sent to the email

Hope you can help me
Thanks

 

2 REPLIES 2
v-LilyW-msft
Community Support
Community Support

Hi @digitalstore00 

I tried to reproduce your scenario and it works fine for me.

According to your screenshot about the flow,the value of ABC is empty.Please enter the value and try again.

vLilyWmsft_0-1625116220869.png

vLilyWmsft_1-1625116340311.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Thanks for your reply
But i'm hoping that the next reply email of column A, B and C are not "abc", "def" and "ghi" respectively
Meaning the first reply will be abc, def and ghi
But second reply is "qwe", "rty" and "uio"
And third reply will be "asd", "fgh", and "jkl"
Is there any way to do so?

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,755)