Email Notification when comments added or modified on a list item

(0) Share

Report

Posted on by ElizabethK

129

Hello,

I need a flow to send an e-mail any time a comment is added or modified to a list item. I think I have the start of it but I don't know what to put for the expression to make it recognize that data has been entered or modified in a column (the comments column)

All responses (3)

Answers (1)

v-bacao-msft on at

Like (0)

Report

Re: Email Notification when comments added or modified on a list item

Hi @ElizabethK ,

It should be body('Parse_JSON')?['d']?]['results'][1]['{ModerationComment}'].

However, the problem you are experiencing now is that the field value of a certain field is empty, but the type of this field defined in the schema needs to be integer, and cannot be empty.

You can change the type of this field in Schema error, it will be set to ["Integer", "null"].

Check this article to solve this problem:

https://blog.thenetw.org/2019/03/11/quick-fix-microsoft-flow-error-invalid-type-expected-string-but-got-null/

https://powerusers.microsoft.com/t5/Building-Flows/Parsing-JSON-Response-error-quot-message-quot-quot-Invalid-type/td-p/301536

Best Regards,
ElizabethK 129 on at

Like (0)

Report

Re: Email Notification when comments added or modified on a list item

@v-bacao-msft and @ScottShearer

I followed the instructions you provided but I am getting an error at the Parse JSON step.
Here is a shot of my test run:
This is the specific error message
I ran into issues right about here in the instructions:
I can't confirm what I typed but I think it was body('Parse_JSON')?['d']?]['results'][1]['Comments']

Any ideas?
Verified answer

v-bacao-msft on at

Like (0)

Report

Re: Email Notification when comments added or modified on a list item

Hi @ElizabethK ,

Please refer to this blog to achieve your requirements.

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Check-for-a-Change-in-a-SharePoint-List-Column-Value/bc-p/248270#M503

We need to use Send HTTP request to SharePoint to get the version of the item and check if the specific column has been modified.

Best Regards,