Unanswered

Sending email once only when two columns has changes in it.

(0) Share

Report

Posted on by Poojan

I have a list where tickets get submitted via the power app, SP list has various columns such as username, creation time and Priority, status, and Assigned to.

The goal here is to send the username of that item when the status of that item changes to In Progress value and the Assigned column has any email (Person) in it.

I have tried a few variations of conditions but it keeps triggering itself and sends an email to the user.

further more just for the more information, Status column is choice based with 4 choices and Assigned is just people only.

I want to send the email only once when both of these status and Assigned column sees any changes for that item.

I hope someone would be able to help me.

Thank you in advance.😊

Categories:

Using flows

I have the same question (0)

All responses (21)

Answers (0)

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Poojan ,

You could set the flow as the following picture:

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Poojan 20 on at

Like (0)

Report
Copy link

Link copied!

I have tried it and its sending the email twice. not sure why its being triggered twice. Also when i add assignee email its adds Assignee as output of the first step automatically. Is that normal?

Thank you @v-zhoqian-msft for looking into it.

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

Like (0)

Report
Copy link

Link copied!

Hi @Poojan ,

Does the Assignee column allows multiple selections?

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Poojan 20 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-zhoqian-msft , it does and the reason behind this multiple selections is that more than one person can be assigned to that ticket and can work together.

Thank you again

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

Like (0)

Report
Copy link

Link copied!

Hi @Poojan ,

You could try the following method:

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Poojan 20 on at

Like (0)

Report
Copy link

Link copied!

whats is the expression in the compose? (Sorry i am complete rookie in this one)

Thank you again

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

Like (0)

Report
Copy link

Link copied!

Hi @Poojan ,

Compose in the picture is what I use for testing, it is not required. Compose 2 is used in condition.

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Poojan 20 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-zhoqian-msft
I have tried it but still receiving 2 emails.

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

Like (0)

Report
Copy link

Link copied!

Hi @Poojan ,

When modifying a record, how is it modified?
Modify the two columns separately?

Was this reply helpful? Yes No
Poojan 20 on at

Like (0)

Report
Copy link

Link copied!

yeah, currently being modified separately.
Open an item > assign it to someone and change the status to In Progress or vice versa. but yes being modified separately.

Was this reply helpful? Yes No