Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

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

(1) ShareShare
ReportReport
Posted on 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 at
    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 at
    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 at
    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 at
    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 at
    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 at
    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 at
    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 at
    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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >