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?
Solved! Go to 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.
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,
Initialize a string variable . Then apply condition to it. similar flow example can be found here :
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.
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
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.
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,
Thank you so much, did this the trick
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.
Never mind i made a space in the column in the trigger
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
42 | |
37 | |
37 | |
35 | |
25 |
User | Count |
---|---|
38 | |
38 | |
32 | |
30 | |
30 |