SharePoint Notification new list item issue

[TimBuchanan]

Thanks in advance!

I have a List that has a "country" column. I have created a view for each of the Countries. I have tried to setup a Power Automate notification where certain people will be notified if a list item with USA is added, and another one where certain people will be notified if a list item with China is added. However, the email notification generates regardless of the Country selected when the list item is created. I used 'Limit Columns by View' set to China as the variable in the power automate flow.

The issue is I get the email no matter what country is selected. Is it because the email is triggered before the column value is determined or seen by the system? I also tried setting it up as notification for any items that have changed with China as the value, but that does not seem to fire when I add a new liast

[SudeepGhatakNZ]

That should be possible.

Can you share a screenshot of your flow?

[TimBuchanan]

It seems so simple! 🙂

The list has a view called China. Only a few list items are there. If I add a new item and select US, I still get the "china" email.

[SudeepGhatakNZ · Accepted solution]

@TimBuchanan ,

Unfortunately, that's not how it works.

This is how you can achieve it

[TimBuchanan]

Thanks! That kinda seems to work. If I have India as the first condition, and add a new India item, I get the email. (But not what I put in the email section of the flow? ) but then I add a second condition for China, but it does not send an email. Also added an email to the 3rd default condition and it doesn't send the email either. Thoughts?

[TimBuchanan]

NEVER MIND and so sorry for all the posts.

was using the wrong value, and the wrong email connector. Seems to be working as I need, thanks so much!