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
Solved! Go to 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.
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.
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)
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
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?
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?
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.
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
Forget my previous post, I tried again from the PowerApp this morning and it worked 🙂
Thanks for you help 🙂
User | Count |
---|---|
89 | |
40 | |
22 | |
20 | |
16 |
User | Count |
---|---|
136 | |
54 | |
47 | |
36 | |
25 |