Answered

Only send one e-mail to when a list is modified

(0) Share

Report

Posted on by ChamC1

Hi All,

I have a flow to send email when a sharepoint column value is changed to yes. But I've noticed that the flow is triggered with any change in the sharepoint list not just the column in question. Is there a way to stop this that the email is only sent once, regardless of any other changes that happen in the list?

Do I need to create a new column that updates to say email sent that somehow stops the flow?

Thanks in advance

Categories:

Building flows

All responses (14)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ChamC1 ，

Please select you change column and set 'Has change column:ColumnName' is equal to 'true'.

Best Regards,

Sunshine Gu
ChamC1 39 on at

Like
a
(0)

Report
Copy link

Link copied!

It's already set to that. Unfortunately it doesn't make a difference, it still sends multiple email if any change is made in any other column
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ChamC1 ,

Please show me a screenshot of your condition setting parameters.

Best Regards,

Sunshine Gu
ChamC1 39 on at

Like
a
(0)

Report
Copy link

Link copied!

Sure here they are
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ChamC1 ,

That's not what I meant. I want to look at the configuration parameters in the condition control.

Best Regards,

Sunshine Gu
ChamC1 39 on at

Like
a
(0)

Report
Copy link

Link copied!

is this helpful?
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ChamC1 ，

Do you want to change the Status column to yes to send an email, or do you want to send an email if the makeupsession changes?

Best Regards,

Sunshine Gu
ChamC1 39 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sunshine,

I only want it to send if the column is changed to yes. And only once.

Thanks

Charmine
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ChamC1 ,

Is your Status column not a radio-select column, but a Yes or No column?

If so, please check this test:

My SharePoint List:

My Flow:

@equals(triggerOutputs()?['body/Status'], true)

Best Regards,

Sunshine Gu
ChamC1 39 on at

Like
a
(0)

Report
Copy link

Link copied!

No it's not a Yes/No column it was glitchy and it kept defaulting to yes rather than no so I'd prefer to not use it. I've used a choice column, is there a different solution?

Thanks for your help