Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

OData Moderation Status stopped filtering

Like (0) ShareShare
ReportReport
Posted on 7 Feb 2023 17:21:30 by 174

I had a power automate that would pull from sharepoint and filter the get items using the OData__ModerationStatus eq 'Pending'.  All of a sudden this stopped working.  It is still attempting to filter the sharepoint list, however it is returning nothing.  I have changed the filter to something like Category eq null and I looked at the data being pulled from that and I see "{ModerationStatus}"="Pending".   Any thoughts on what might have changed to make this filter stop working?

  • NWEASD Profile Picture
    174 on 08 Feb 2023 at 14:00:26
    Re: OData Moderation Status stopped filtering

    Thank you.  I swear I tried this as part of the solution and it did not work.  It is working now.  Who knows but thank you.

  • Verified answer
    abm abm Profile Picture
    32,464 Most Valuable Professional on 07 Feb 2023 at 20:48:13
    Re: OData Moderation Status stopped filtering

    Hi @NWEASD 

     

    Thanks for your quick reply.

     

    Moderation Status values are:

     

    • 0 for “Approved”
    • 1 for “Rejected”
    • 2 for “Pending”

    Try OData__ModerationStatus eq '2'

     

    Let me know the results.

     

    Thanks

  • NWEASD Profile Picture
    174 on 07 Feb 2023 at 19:29:33
    Re: OData Moderation Status stopped filtering

    Sure thing.  

     

    NWEASD_0-1675797815792.png

    Here is a snip of a couple items on the list.  The Approval Status is a default column on there when items require approval.  I have found that the column in automate is called Moderation Status.

    NWEASD_1-1675797916915.png

     

    Previously I was using this as part of the Get Items filter.  When it is in the filter array it will work, but I will also miss some items I actually want on the original get items command.  

    With the help of the community, I was able to get it to work by using "OData__ModerationStatus eq 'Pending'"  That just seemed to stop working one day and not sure why.  If I try changing the OData filter to {ModerationStatus} I get an error about the column not existing.

    NWEASD_2-1675798166271.png

     

  • abm abm Profile Picture
    32,464 Most Valuable Professional on 07 Feb 2023 at 19:19:39
    Re: OData Moderation Status stopped filtering

    Hi @NWEASD 

     

    Could you post a screenshot of your SharePoint column (ModerationStatus)  setting details?

     

    Thanks

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard