Hi All,
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.
Please create one more column -ID in your excel and then configure excel connector as shown below-
Thanks
Hardesh
Sure let me try right now and give feedback. Thank you very much for you response.
@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.
This is due to no of modification in excel. Excel sheet modified 3 times that's why it is sending 3 emails.
@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.
@chandra1 Why are you doing it through excel way. Use SharePoint List form and send email when new item is created.
Thanks
Hardesh
@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
Method 1
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"
Method 2
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
Use condition
Left side
Right side
'获取行'= 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.
Best regards
Ler
hi Chandra1
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 sekharmalla.vfx@gmail.com
I appreciate it
hi @chandra1
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.
BR
Ler
Please Send All screenshots please as a zip file i am not able to understand it. Thanks
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
7 | |
2 | |
2 | |
2 | |
1 |