Trigger an email to user when their name is selected in sharepoint list item

[Alison1]

Hi all

I have a Sharepoint list with a Person or Group type column which allows a user selection from Active Directory, when a user is selected, I would like an email to be sent to that user advising them that a list item has been assigned to them.  Please can I get some help with this?

Thanks

[Expiscornovus · Accepted solution]

Hi @Alison1,

I would use a Get changes for an item or file action for this. With this action you can check if your person or group type column has a changed value. You can check if that is true in a condition. If Yes, you can sent an email.

Below is an example of that approach.

In this example my Person or Group type column is called AssignedTo btw. This sample also assumes you are only allowed to select one person in that person column.

[Alison1]

Hi @Expiscornovus 

Thank you for taking the time to reply, I appreciate your help.  I'm just working through this and am wondering which expression this is?

[Expiscornovus]

Hi @Alison1,

Apologies, I forgot to share that expression in my reply.

I know it is not very clear, but it is actually in the notes of the action directly above the Site Address field in the screenshot.

Here it is as a code snippet:

add(int(triggerOutputs()?['body/{VersionNumber}']),-1)

[Alison1]

Hi @Expiscornovus 

Thank you for your reply.  I tried again with the code. The flow runs, but unfortunately the email doesn't come through 😞

The only thing that looks that there could be an issue is this:

and the expression result of the Condition is false, not sure if that means anything.

I'm probably doing something wrong as I'm very new to flow.  My column is called Owner

Thanks

[Expiscornovus]

Hi @Alison1,

It looks like the flow thinks the value in the Owner column has not changed since the last version.

Lets double check the outputs. Can you expand the Get changes for a file or item action in that same flow history run and share the outputs as a screenshot?

[Alison1]

Hi @Expiscornovus 

Please see screenshots as follows:

Thank you!

[Grant_Jenkins]

Hi Alison - just been reading through the thread. It looks like it should work. Just to confirm, you need to check your Owner field has changed against the expression true, not just the value true. Are you able to share a screenshot of the condition?

[Alison1]

Hi @Grant_Jenkins 

Thanks for your help.

[Grant_Jenkins]

It looks like you've added the wrong dynamic field in your Condition. You need to use the Has Content Changed: Owner instead of the Owner/Email from the Trigger.

[Alison1]

Yes it worked, thank you so much @Expiscornovus @Grant_Jenkins 🙂

[Alison1]

Hi @Expiscornovus @Grant_Jenkins 

So the above solution works when I add an owner in the sharepoint list, but not when I add it through my powerapp.  I checked the list in sharepoint which did reflect the changes in the Owner column made in the PowerApp. Do you know what would cause this?

This is the result I get when assigning directly in Sharepoint

And this is what I get when assigning in the PowerApp

Thanks

[Alison1]

@Expiscornovus @Grant_Jenkins 

Forget my previous post, I tried again from the PowerApp this morning and it worked 🙂

Thanks for you help 🙂