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)

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
ElizabethK 129 on at

Like
a
(0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No