Error building condition to send an email to assigned user based on list value.

[C8T]

I'm trying to create my first power automate flow linked to a SharePoint list that is dependent on the person column "Assigned To". Once the field is populated or changed, it will send an email to the person in the assigned to role for the list item. I keep getting an error within the process of building the conditional for the statement below.... Any guidance on what exactly I'm doing wrong or not understanding would be greatly appreciated. My initial condition is to ensure that Assigned To = not empty = True.

[C_Hansen]

May I suggest using the 'Get changes for an item or a file (properties only)' action to determine if that field has changed. You would need to subtract 1 from trigger version in the 'since' field ;

sub(int(item()?['{VersionNumber}']),1)

You can then use dynamic content from this action in your condition to check if the field changed and is not blank.

You could also add a 'Trigger Condition' so the flow will only run when the field is not blank. If you would like more details please let me know.

Thanks,

[michael0808]

It is unnecessary to use the "Get Items" action when you are using "When an file or item is modified". They both return all the data you need.

What I would suggest is for you to create a new column in your list, lets call it "Email Sent". This will be updated by the flow when it triggers to ensure that you are only sending one email.

In your trigger conditions, add the following in order to make sure that your trigger only happens when 1. The Email column is not empty, and 2. When the "EmailSent" column is not = "Yes"

@And(not(equals(empty(triggerOutputs()?['body/Email']), true)), not(equals(triggerOutputs()?['body/EmailSent'], 'Yes')))

Create your Send Email action as you normally would, then right after, create an "Update Item" action to change the value of "EmailSent" column to "Yes".

I hope this helps get you on the right track!

[C_Hansen]

Form my understanding the flow needs to trigger when the user is changed, this would require the email sent column to be cleared as well. 

If you check the person field has changed every time the list is edited, then an email can be sent every time the user is changed/ added, but will not send in any other instance.

Trigger condition could look like this to ensure it only runs when the person field is not blank.

@not(equals(item()?['PersonField/Email'], null))

[michael0808]

With this condition, it won't matter what column is changed, the flow will trigger if any column changes. My method prevents this from happening, however, it can be modified to account for changes to the Person column.

[C_Hansen]

Your flow will also run when any column is changed, but only when email sent and Person field is not blank. This is fine unless you don't want to make the user clear the email sent column when updating the user.

From my understanding there is no way to trigger a flow from a specific column change, hence why you need to check which column changed once the flow has started. Can you elaborate on how you can trigger the flow based on a specific column change?