web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : thHnl4ttu/r7MZAgU3QNAh
Power Automate - Building Flows
Unanswered

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

Like (1) ShareShare
ReportReport
Posted on 26 Oct 2016 11:58:29 by 8

Hi

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

 
  • CatyChe Profile Picture
    9 on 23 Mar 2021 at 15:41:37
    Re: Sending Email when item Approval Status is changed to approved in sharepoint list

    Thank you very much for this solution! 

  • ZachS15 Profile Picture
    63 on 24 Apr 2019 at 15:35:13
    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

     

    image

     

    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 Platform Member Profile Picture
    on 28 Dec 2018 at 16:08:46
    Re: Sending Email when item Approval Status is changed to approved in sharepoint list

    Any solution for column '_ModerationStatus' Please ?

  • tianaranjo Profile Picture
    497 on 16 Feb 2018 at 19:45:11
    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 Profile Picture
    8 on 03 Dec 2016 at 03:34:45
    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 Profile Picture
    53 on 29 Nov 2016 at 23:16:31
    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 Profile Picture
    8 on 27 Oct 2016 at 07:28:58
    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 Profile Picture
    on 27 Oct 2016 at 06:17:01
    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.

     

    1. I created a SharePoint list called “ApprovalList”, with a Choice column named “Approval”. It has 3 choices which are Approval, Rejected, On Progress.

    1.PNG

    2. Create a Flow with the following settings:

    2.PNG

     

    When I modified one column to “Approval”, I will receive an email like this:

    3.PNG

    In this flow, the condition is:

    4.PNG

     

    Regards,

    Mona Li

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2