Skip to main content
Community site session details

Community site session details

Session Id : C3PyBuz0KcBCXPRR4Ar9st
Power Automate - Building Flows
Unanswered

Send an email When an item in a SharePoint list is modified based on the column which has changed

Like (0) ShareShare
ReportReport
Posted on 6 Feb 2024 14:19:13 by 2

Hi all,

I have created a workflow to send an email when an item in our sharepoint list for months ending has changed to "done". In general, the workflow works. My problem is, that there is a limit of nested conditions. 

Does anyone have an alternate way for the following process?

 

Process:

Everyone in column "Information an" should get an email, if an item in the columns Jan 24, Feb 24 ... to Dez 24 has changed to "done". The mail should include a sentence like that: "Hello User (from Information an"), 'Title' has changed to 'Value of the column which has changed'". In this example our mail as well as the list would be in German.

See the following columns:

JKort_0-1707228399102.png

 

I tried it with many conditions (e. g. If Jan24 has the value "done", send an email, if not, check if Feb 24 has changed to "done"). It works well, but I just can use 8 Conditions.

JKort_1-1707228939737.png

JKort_2-1707229072942.png

JKort_3-1707229092677.png

Thank you very much!

  • JKort Profile Picture
    2 on 06 Feb 2024 at 14:33:27
    Re: Send an email When an item in a SharePoint list is modified based on the column which has changed

    Thank you @CFernandes. But the first part of the Flow works.

    JKort_0-1707229766421.png

    But then I want to send an email to all the people named in the "Information to" column. The email should contain the information in the text as to which column (e.g. column Feb 24) has been changed to "Done". There are 12 different columns (one for each month) which could have changed to "done".

  • CFernandes Profile Picture
    8,295 Most Valuable Professional on 06 Feb 2024 at 14:26:32
    Re: Send an email When an item in a SharePoint list is modified based on the column which has changed

    Hey @JKort - If I understand correctly, you want to Trigger a Flow when a Column is modified and the value is set to Done? 

     

    You use the action and  "Get changes to an item or file (properties only)" . You can find more details at https://powerautomate.microsoft.com/en-us/blog/run-a-flow-when-a-sharepoint-column-is-modified/ 

     

    The action outputs helpful tokens such as “Has Colum Changed:<Column name>” that can be used to filter your flow to just the column(s) you care about.

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete