Get Last Row from excel and send email which will be present in rows.

[chandra1]

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. 

[Hardesh15]

@chandra1 

Please create one more column -ID in your excel and then configure excel connector as shown below-

Thanks

Hardesh

[chandra1]

Sure let me try right now and give feedback. Thank you very much for you response.

[chandra1]

@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]

@chandra1 

This is due to no of modification in excel. Excel sheet modified 3 times that's why it is sending 3 emails.

[chandra1]

@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]

@chandra1  Why are you doing it through excel way. Use SharePoint List form and send email when new item is created.

Thanks

Hardesh

[chandra1]

@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. 

[Ler]

@chandra1 

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

Spoiler

int(outputs('获取行')?['body/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

Spoiler

int(outputs('获取行')?['body/rows'])

Right side

Spoiler

length(body('筛选数组'))

'获取行'= 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

Spoiler

length(body('筛选数组'))

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

[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.

[chandra1]

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

[Ler]

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

[chandra1]

Please Send All screenshots please as a zip file i am not able to understand it. Thanks