cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jspeer1
Helper II
Helper II

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

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.

SP1.png

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.

sp2.png

 

Example:

I am going to assign a 'ticket' to myself

sp3.png

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 🙂

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

4 REPLIES 4
FreddieV
Resolver I
Resolver I

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.

Jspeer1
Helper II
Helper II

@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.

sp4.png

 

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.

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.

View solution in original post

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,159)