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

3.png

2.png

1.png

All responses (14)

Answers (1)

LucaNeedsHelp 207 on at

Like (0)

Report

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

Hi, and what is, if i have two choices with "correct" and "incorrect"?
It also should trigger one time.
ChamC1 39 on at

Like (0)

Report

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

Hi Sunshine,

I think this has worked. Thank you so much for your help!
Verified answer

v-yetonggu-msft on at

Like (0)

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

Hi @ChamC1 ,

I did a test based on the information you provided and found that the flow will be triggered and the email will be sent only when I change the Status single choice column to 'Yes'.

My Test:

My Flow:

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

Best Regards,

Sunshine Gu
v-yetonggu-msft on at

Like (0)

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

Hi @ChamC1 ,

Please check if your Stauts column is a single selection column, not a multiple selection column.

If it is a single-select column, please put this expression into the condition in your trigger.

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

Best Regards,

Sunshine Gu
ChamC1 39 on at

Like (0)

Report

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

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
v-yetonggu-msft on at

Like (0)

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

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 (0)

Report

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

Hi Sunshine,

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

Thanks

Charmine
v-yetonggu-msft on at

Like (0)

Report

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

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 (0)

Report

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

is this helpful?

5 - Screenshot 20...

6.png