Happy to be here. this is first time I am writing on the Blog. i hope everyone doing great.
I want to know a way where I can create a flow that would get newly added row details from an excel details, then will send an email.
in excel there will be three columns User,Email,Yes or no, so when i add user name and email and yes the flow should trigger and send email to the user whose i created.
Thanks in advance if its already solved please refer me to that link would appreciate.
@Hardesh15 I have tried as you suggested, I think its working but the problem is when i enter User name and email and company name and id in last row total 3 email going to the user.
Note :- I have triggered get list of rows when SharePoint file is modified. excel file is in SharePoint documents. below I will provide the flow structure.
@Hardesh15 oh okay. can you show me a solution to make this flow right. my motto is simple.
lets say I am conducting a program and I have to register participants Name and Email.
so when I add new Name and email in last row in excel (which is only saved in SharePoint documents) the participant whose email id I have entered should get mail with those details. I really appreciate.
@Hardesh15 Yes I tried that and its working exactly I expected. but due to some problems from management I can not use that method. I am sorry I couldn't provide you the information but. I have to do it though excel only.
After I tested , there are two ways working for me
Create one more column like "Mark"
Make this flow auto run every 10 mins
List rows present in a Table filter query with Mark ne 'sent'
Use apply to each
It will run by every line of the list one by one
Send a mail and update rows Mark to "sent"
Create new table like below
Rows = how many lines you already sent to mail
Mark = 1 just for easy get this rows
Make this flow auto run every 10 mins
Initialize variable type int with value 1
Get rows with new table column mark = 1
Initialize variable type int with value rows
List rows present in a Table from your original table
Use filter arrays by value from list rows
The name Not equal to empty
'获取行'= get rows
'筛选数组'= filter arrays
You can change the name by your own
If true then do nothing, if false then do like below:
When the index > rows then send mail
And then make the index = index + 1
After this loop, update the rows like
And then show you the full map like below:
I use Chinese version , but I mark the point to English, I guess you can recognize that.
If you can't recognize some of that, please let me know it.
I hope it helps.
i don't know why i reply your post 3 times, all the time display success, but when i refresh the web, my reply is gone.
so i just can give you a big screen shot for that.
Hi @Ler Thank you very much for your reply really really thank you. for your effort to make me understand. unfortunately I am fully confused by those steps please I will mention my mail here send all screenshots with number as screenshot 1 and screenshot 2. but I am very happy that you are able to find solution. here is my email email@example.com
I appreciate it
i guess the admin fix the problem.
so you can read all detailed and clear screen shots in your post now.
if you still can not read that , pls let me know it , i will send you a package of all screen shots😎
I am very happy to share my ideas, if the idea can help you.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.