If column contains a person, notify that person

[JimmyWork]

What i want to achive.

I have a Column in a SharePoint list named Assigned.

This column is a people/group column.

I want to build a flow that when the column Assigned contains a person it should send a email to that person.

If the column contains nothing the flow should exit or do nothing.

I can make so the column contains "Unanssigned" instead of blank if that helps.

I have tried using Switch and Control but im not able to achive it. I do not know how to use if command correct for this or if its even needed to be used?

[PhantomSoul]

Initialize a string variable . Then apply condition to it.  similar flow example can be found here :

https://powerusers.microsoft.com/t5/Building-Flows/Assign-Approval-to-User-based-off-a-Value-in-a-Sh...

[JimmyWork]

Thank you but i do not know how to do this, according to the link it uses "if"

Im not able to get it right in any way i try.

Column name = Assigned

If Assigned contains any value then notify the user in Assigned.

If Assigned is null do not run flow or exit.

[JimmyWork]

For some reason if value is null the flow will fail.

Condition is: Assigned contains AssignedDisplayName

But if the Assigned column is null the flow fails

[v-bacao-msft · Accepted solution]

Hi @JimmyWork ,

The first thing to note is that when an existing item is modified is actually when an item is created or modified.

You could use the following method to configure Flow.

• Use Empty() function to determine if this field is empty. If it is empty, no action is configured.
• If it is not empty, send an email to Assigned user.

Expression reference:

empty(triggerBody()?['Assigned'])

Image reference:

Besides, if it automatically apply Apply to each when configuring Assigned Email, this is normal. Because your field is set to Allow multiple selections, it will traverse all the users you choose by default and send the email to each user.

If you want to send only one email to all users, feel free let me know, I would provide example for you.

Best Regards,

[JimmyWork]

Thank you so much, did this the trick 

[JimmyWork]

For some reason this worked perfectly last week, now it does not. Nothing changed.

No the result is alwaus false no matter if the column Assigned To contains anything or not.

[JimmyWork]

Never mind i made a space in the column in the trigger