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

(0) Share

Report

Posted on by Alison1

119

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

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

Expiscornovus 32,820 Most Valuable Professional on at

Like (1)

Report

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

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.

Was this reply helpful? Yes No
Alison1 119 on at

Like (0)

Report

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

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?

Was this reply helpful? Yes No
Expiscornovus 32,820 Most Valuable Professional on at

Like (1)

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

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)

Was this reply helpful? Yes No
Alison1 119 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Expiscornovus 32,820 Most Valuable Professional on at

Like (1)

Report

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

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?

Was this reply helpful? Yes No
Alison1 119 on at

Like (0)

Report

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

Hi @Expiscornovus

Please see screenshots as follows:

Thank you!

Was this reply helpful? Yes No
Grant_Jenkins 57 on at

Like (1)

Report

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

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?

Was this reply helpful? Yes No
Alison1 119 on at

Like (0)

Report

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

Hi @Grant_Jenkins

Thanks for your help.

Was this reply helpful? Yes No
Grant_Jenkins 57 on at

Like (2)

Report

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

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.

Was this reply helpful? Yes No
Alison1 119 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No