cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JimmyWork
Power Participant
Power Participant

If column contains a person, notify that person

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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:

19.PNG

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
PhantomSoul
Frequent Visitor

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...

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.

2019-03-14 14_32_25-Run History _ Microsoft Flow.png2019-03-14 14_32_38-Edit your flow _ Microsoft Flow.pngFor 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

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:

19.PNG

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thank you so much, did this the trick Smiley Happy

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.

 

2019-03-29 13_45_16-Run History _ Microsoft Flow.png2019-03-29 13_45_36-Edit your flow _ Microsoft Flow.png

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

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (12,658)