Answered

can i have a flow that send email if data is entered in a column

(0) Share

Report

Posted on by Dougers1

Hi i have built a flow that i run the flow so it send email- is it possible for it to send automatically if dat is entered in the row for that column - ie if we enter booking reference number into column h row 2 that person get confirmation email sent#

this is my current flow

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

BenUnlox 64 on at

Like (0)

Report
Copy link

Link copied!

@Dougers1 - Sure can! There's a couple of ways you could do this, but the best way would be to add a Filter Query to your initial 'List rows present in a table' action to reduce the amount of data that your Flow would process.
The forumula you would need to enter in the 'Filter Query' field of the 'List rows present in a table' action (under Advanced options) would be as follows:

NameOfColumn ne ''

In my example, the name of my column was 'Empty' so my full query was: Empty ne ''.

Hope that helps!

Was this reply helpful? Yes No
Dougers1 99 on at

Like (0)

Report
Copy link

Link copied!

Brilliant i will have a go at this later - Thanks

Was this reply helpful? Yes No
Dougers1 99 on at

Like (0)

Report
Copy link

Link copied!

i had a go and nothing ?

my column is BRN ne" which i typed into filter query in advanced on list rows present in a table - i even went to run flow manually and it never worked

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Dougers1 ,

If you like filter out a certain column of records in Excel whose values are not empty and send email to the relevant people.
Please try this:
The Expression of empty:

empty(items('Apply_to_each')?['ColumnName'])

Hope this helps you!
-----------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Dougers1 99 on at

Like (0)

Report
Copy link

Link copied!

The data for the request comes in from the teams form with the date and time ect of the appointment - what i need is that when i enter a booking reference number it sends... the email to that person straight away - i dont want it to keep emailing all people on the sheet with brn just when it 1st gets entered if that makes sense

Was this reply helpful? Yes No
BenUnlox 64 on at

Like (0)

Report
Copy link

Link copied!
@Dougers1 - There's a missing space in the Filter you've added.

Incorrect: BRN ne"
Correct:BRN ne ''

Does the Flow run correctly if you update that?

Then, if you didn't want the people to recieve multiple emails I would:

Add a column called to your table.
Add a condition to the 'For Each' loop to check the value of the new column.
If the value equals Yes, no action is taken.
If the value doesn't equal 'Yes', it sends the email and updates the value in the Table to Yes (to prevent any further emails from being sent).

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Dougers1 ,

There is currently no relevant Excel trigger to do this, I recommend you use SP list as your data source.

Best regards,
Rimmon Li

Was this reply helpful? Yes No