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
Microsoft
Microsoft

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,408)