Unanswered

How to send an email, when a new row is created and matches a particular column name.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So, I'm pretty new to power automate. What I need is when a new row is created and the value in the column matches a particular word, an email is sent. For example; if a new row is created and the country column has the value "China" in it, an email is sent. This has to only happen on new rows and not from column data of previous rows. Please refer to the screenshot for example.

Any help would be appreciated and thanks in advance.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is the list a sharepoint list, excel file, or other list?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This is an excel file in OneDrive.

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous I don't believe power automate is able to tell when new rows are added to excel. If you convert it to a sharepoint list, this would be an easy task to accomplish

Was this reply helpful? Yes No
BastienLin 6 on at

Like (0)

Report
Copy link

Link copied!

@srduval Hello,

I would like to know how would you do this with a sharepoint file ? I am trying to do something similar:
I would like to know if a new row has been added within my PowerBI Matrix with some specific rules defined.

Thank you for your help.

Was this reply helpful? Yes No