Unanswered

send an email when only certain items are modified not depending on what column is modified

(0) Share

Report

Posted on by abihoughton27

Hi,

I have created a flow which if an item is modified i get an email (this works fine) - but this is for if any list item is modified - i want it to be only when certain list items row is modified - i have seen and used before when a specific column item is modified but i want to know when a specific list item row is modified from any of the columns

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

NiloferA on at

Like (0)

Report

Hello @abihoughton27 ,
I am not sure if I understand your requirement, but a specific list item is identified only by the values selected for it's columns. For e.g. Every List Item that is created has an ID assigned to it 1, 2, .. and so on . Now, ID is nothing but a Column and it's value uniquely identifies the row.
Can you elaborate your requirement further?

Was this reply helpful? Yes No
abihoughton27 on at

Like (0)

Report

Hi @NiloferA
Thanks for getting back to me you
I have a SharePoint list of 400 items, I want to be able to get email notification when a specific 30 of these items are modified it doesn't matter what column is modified in the table just if any column in those 30 have been modified I'd like to get an email – does this make more sense?

Was this reply helpful? Yes No
Verified answer

NiloferA on at

Like (0)

Report

Hello @abihoughton27 ,
Yup, I do get it now, but again you will need a column to uniquely identify these rows because the Flow triggers for an item where any kind of modification is done to any column. To selectively run for specific items, you need to filter the items out based on the values in the column.
Maybe add a new column "SendEmail" and update the value to Yes for the 30 items in question the rest will remain blank.
Then in the trigger condition of your Flow check for this field to be equal to Yes, this ensures that the items where SendEmail is Yes, the Flow will trigger irrespective of which column is modified. But as a conclusion, you will need a column to filter the items on which the Flow needs to run.
I hope this makes sense and answers your question

Was this reply helpful? Yes No
abihoughton27 on at

Like (0)

Report

Thank you - this has worked

Was this reply helpful? Yes No