HELP? - Send Teams Message when SharePoint Item is Modified?

[Anonymous]

Hi all,

I have a Sharepoint list that gets populated with items automatically by using another flow that will receive emails, extract that data and post that data to the Sharepoint List.

I spent some time putting this post together. I would appreciate it if someone could help. Thanks!

I'm now facing an issue:
One of our Columns is titled Assigned to:

Here someone from our team would manually go in and modify that particular field and assign it to someone. The rest of the list is updated automatically with another flow.

I'd then like to:

Only when that particular field in an item is modified/updated --> Trigger a Teams message.

I don't want it triggering if the ticket priority, ticket number, or Short Description field is updated. Only need a message triggered when a Assigned to field is updated.

How can I grab the name the Assigned to field was set to to then use as a recipient of where the Teams message      is going to be sent to?
What this is for is so it sends whoever was 'assigned a ticket' in the SP list to get notified of so and get to work.

Example:

I am going to assign a 'ticket' to myself

Since all the info was already there, how can I it have it trigger when only the assigned to field is modified and then how to send the Teams message which will be directed my way anyways?

Thanks I hope I explained myself 🙂

[FreddieV]

I’m going to assume that your ‘Assigned to’ field in SharePoint is a Person or Group field. If it is not, I would suggest that you make it so.

In your second flow you want to set it up like this: https://powerusers.microsoft.com/t5/General-Power-Automate/Trigger-flow-when-an-item-in-SharePoint-l...

After you have then determined that the list has been modified, you want to add another, separate condition. The thing is, you can’t trigger a flow to perform something when a column is simply ‘updated’; it needs an additional column with a value that can be selected in order that you can trigger the flow. I suggest something like an ‘Assignment’ column with ‘Assigned’ and ‘Unassigned’ as drop-down vales, that can be used in the Condition.

So you could have: If SP Column ‘Assignment’ is equal to ‘Assigned’ > ‘Post a message as the Flow bot to a user’ if the condition is true.

If it is false: ‘no’ then do nothing.

Then in the above card in the recipient field, you can obtain the email address via the dynamic content from the 'Assigned to’ column, so long as it’s a Person or Group column.

Hope that makes sense.

[Anonymous]

@FreddieV 

I think I somehow found a solution within this here: https://flow.microsoft.com/en-us/blog/run-a-flow-when-a-sharepoint-column-is-modified/

My issue is every time I add the Get Changes for an item or a file (properties only) it puts me into an Apply to Each loop which is not the case when the instructor shows him building it
Why is it putting me into a for an apply to each loop? I can't get rid of it or drag my action outside of it.

The video also then goes to show I can use the Assigned to Email variable to use that to send a message in teams or email which is great but not sure why my Flow insists on putting me into an Apply to Each loop.

[FreddieV · Accepted solution]

Apologies, I stand corrected.

I'm not sure on that one, I've just tested it on my side with two different lists and I don't get the apply to each; It could be something to do with your list. Why does it matter that it has an apply to each card? Have you tested it with the card and that is somehow causing it to fail?

You could always try the method I suggested.

[Anonymous]

I finally got it working with even though it put me into that apply to each. I am still uncertain of how versioning works. I set it to have a limit of 10k versions. What would happen since every time an item is modified = new version. And this would happen at least a couple hundred times per day.