Trigger email - When a particular set of columns modified in Sharepoint List

(0) Share

Report

Posted on by GayathriTU

Hi All,

I need to develop flow that will trigger email to user when particular set of column modified in Sharepoint List.

I have Sharepoint list with almost 40+ columns in that if modification made in specific 20+ set of columns , I need to send email to user which column is modified and also the old and new modified values of the particular columns

Can you please help in developing the above logic , happy to discuss more in detail .

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@Gayathri_TU , you can use "When an item or a file is modified" trigger for the flow, then add Get changes for an item or a file (properties only) action, this action will give you details of which columns have been modified. Then you can get previous version of item using "Send an HTTP request to SharePoint" action to get the old values of columns. New values of columns you can get from the trigger, sample flow shown as below to see how you can configure these actions:

Was this reply helpful? Yes No
GayathriTU 64 on at

Like (0)

Report

Hi @annajhaveri

Thanks for the Quick response,

Also I need to Send email to the users when particular set of columns are modified(about 20) among 40+ columns , can you suggest me the logic to implement the same.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
@Gayathri_TU , you can add condition action and configure below expression to determine if column value has changed or not. Please note this expression is for two columns, you can add more columns in the expression. Replace test1 and test2 in expression with you column internal names.

or(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/test1'],outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/test2'])

and configure the condition action as follows:

Was this reply helpful? Yes No
GayathriTU 64 on at

Like (0)

Report

Hi @annajhaveri

It's working great,Thanks.

One more thing I need to send the values in the email body : Column Modified currently and Old value of the column in tabular view , can you please help me with that.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
@Gayathri_TU yes sure, as i mentioned in my previous replies, to get the old value of column, use Send HTTP Request to SharePoint action to use REST API to get previous version (old) values

After adding the above action, use below expression to get old values, replace title with you column internal name

body('GetVersion')['d']['Title']

Was this reply helpful? Yes No
GayathriTU 64 on at

Like (0)

Report

Hi @annajhaveri

How to get only display name form people picker field? in mentioned formula

body('GetVersion')['d']['Title']

Was this reply helpful? Yes No