Unanswered

Sending Email when item Approval Status is changed to approved in sharepoint list

Like (1) Share

Report

Posted on 26 Oct 2016 11:58:29 by GT

i am trying to creat a flow where a user will get a notification if the approval status value in sharepoint list changes to approved. i tried using "_ModerationStatus" matching it with value "0" "(@equals('_ModerationStatus', 0 )) "but its doesnt seems to working, what could be the issue

All responses (8)

Answers (0)

CatyChe 9 on 23 Mar 2021 at 15:41:37

Like (0)

Report

Re: Sending Email when item Approval Status is changed to approved in sharepoint list

Thank you very much for this solution!
ZachS15 63 on 24 Apr 2019 at 15:35:13

Like (1)

Report
Re: Sending Email when item Approval Status is changed to approved in sharepoint list

@Anonymous I'm facing this issue too and I found a solution from the article below. Bascially you'll need to use a 'Send an HTTP Request to SharePoint' action and then use an ODATA_ operator in front of the Approval Status (_ModerationStatus) field. _Moderation status is not exposed by standard REST calls so that is why odata is required.

https://www.techmikael.com/2018/05/use-microsoft-flow-to-implement.html

_api/web/lists/getbytitle('<Library Name>')/items(<id>)?$select=OData__ModerationStatus

The returned object will have the Approval Status id in it
{ OData__ModerationStatus: 1 }
The approval statuses are:
Approved = 0
Rejected = 1
Pending = 2
Draft = 3
Community Power Pla... on 28 Dec 2018 at 16:08:46

Like (0)

Report

Re: Sending Email when item Approval Status is changed to approved in sharepoint list

Any solution for column '_ModerationStatus' Please ?
tianaranjo 497 on 16 Feb 2018 at 19:45:11

Like (0)

Report

Re: Sending Email when item Approval Status is changed to approved in sharepoint list

@v-monli-msft

I have a similar need and am seeking help. I have an Issues list in SP.  I have a Status Column and Status Update Column.

If the troubleshooting team enters a status update and proposes it as a solution, prior to the Status Column being updated to 'Closed, I would like the Status Update mailed to the user who entered the issue and ask if they Accept it as a solution. If they click Approve, then I would like the Status Column to update automatically to 'Closed'. Is this all possible with Flow?

Also, when I added a flow identical to the one you shared above, it will not send an email when set as Is Equal To 'Closed' (which is what I want).

However, it will send the email when I set it as 'Is not equal to' 'Closed'. And continues to send emails if I change status back to In Progress.
GT 8 on 03 Dec 2016 at 03:34:45

Like (0)

Report

Re: Sending Email when item Approval Status is changed to approved in sharepoint list

Hi Patrick
its seems there is limitation with MS Flow that where it can not select and act on system intenal fileds, I just had revert back to old way of workflow cinfiguration in sharepoint to achiniving the desired results & which works absolutly fine.
patrickabel 53 on 29 Nov 2016 at 23:16:31

Like (1)

Report

Re: Sending Email when item Approval Status is changed to approved in sharepoint list

I'm in search of a similar need. I have a SharePoint Online list that is configured for "content approval for submitted items" and I'd like to use this column in a MS Flow condition. Is this possible? It doesn't show as avaialble with the other list fields as dynamic content.
GT 8 on 27 Oct 2016 at 07:28:58

Like (1)

Report

Re: Sending Email when item Approval Status is changed to approved in sharepoint list

Hi Mona, thanks for the efforts but this is not what i wanted , i wanted the condition specifcally work on system field "Approval status" whose inernal name is, i dont need a another approval column in the list as it has a drwaback where it got edit permission and any one who has edit permission to list but not the approver can modify this newly created column which isn't the case with "_ModerationStatus" field. I am using out of box sharepoint approval option provided in each list and wnat flow to mactch the value of the internal field.
v-monli-msft on 27 Oct 2016 at 06:17:01

Like (0)

Report
Re: Sending Email when item Approval Status is changed to approved in sharepoint list

Hi GT,

I have created a flow according to your requirement. And I got the result successfully.

I created a SharePoint list called “ApprovalList”, with a Choice column named “Approval”. It has 3 choices which are Approval, Rejected, On Progress.
2. Create a Flow with the following settings:

When I modified one column to “Approval”, I will receive an email like this:
In this flow, the condition is:

Regards,
Mona Li