web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create notification me...
Power Automate
Unanswered

Create notification message that changes content based on what has been updated/modified

(0) ShareShare
ReportReport
Posted on by 2

Hey there,

 

I am trying to create a notification message every time a specified column has changed in one of my sharepoint lists. How do I set up the flow so that it will only produce the information that has been modified in the notification message. (This will be going into a teams chat btw). 

I am still new to this automation tool so bare with me. I have set up the following flow which pulls the changes from my sharepoint list. After which I run a condition to check what changes have occured -> I get to the post message to teams but realise here that these values are hardcoded but need to dynamically adjust based on what has been updated. 

Any help will be greatly appreciated

 

flow.jpg

Categories:
I have the same question (0)
  • RobElliott Profile Picture
    10,323 Super User 2025 Season 2 on at

    @vin_from_nz firstly, I think your condition should change to Or; the way you've got it at the moment every column has to have changed for it to go down the green if yes channel.

     

    But I would take a different approach (other flavours of a solution may be available). 

     

    I always turn on versioning for the list on list settings. 

     

    1. The trigger is when an item or a file is modified followed by the get changes for an item or a file when the since field has the following expression to compare the previous version with the current version:

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

     

    1-Flow.png

     

    2. Next, initialize a string variable then add a compose action to handle line breaks using <br>

     

    2-Flow.png

     

    3. Then for each question where you want to check if the column has changed add a condition. Leave the red if no channel empty and in the green if yes channel add a append to string variable action and add the text and dynamic content you want followed by the outputs of the line break compose.

    3a-Flow.png

     

    3b-Flow.png

     

    3c-Flow.png

     

    4. Outside of all the conditions add another compose action and select the variable. Finally, add the Teams post message in a chat or a channel action and add the outputs of the previous compose.

     

    4-Flow.png

     

    This is the result and because of the line breaks it will show each item on a separate line but only the items that have changed.

    5-Teams.png

     

    Hope that helps.

     

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

  • vin_from_nz Profile Picture
    2 on at

    Hi @RobElliott 

     

    Thanks heaps for your recommended solution. I can see where your going with the flow and that's really good for what I'm looking for. Just a question : I want in my message to refer to the old and new values so that when people see it they understand what the previous value was and what it is now. 

    Also, how exactly do you refer to your dynamic content? E.g. Lets assume I have a table that has two columns where one item has been modified. (Paper to Journal)

    ItemsOwner
    PenBob
    PaperPeter


    And the modified version : 

    ItemsOwner
    PenBob
    JournalPeter



    I would want my notification to say "The Owner Peters Items have changed from Paper to Journal" because while I do want to advise on what has changed I want to provide context by referencing the Owner in the notification. 

    (My example is based on a typical scenario for what I am trying to achieve for some online stores.) 

    The rest of the information you provided should be sufficient for achieving that with the line breaks however this is the key thing I am unsure about. How do I reference the both the old and new values in my notification/message. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard