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

[JKort]

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:

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.

Thank you very much!

[CFernandes]

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.

[JKort]

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

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