Answered

OData Moderation Status stopped filtering

(0) Share

Report

Posted on by NWEASD

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?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @NWEASD

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

Thanks

Was this reply helpful? Yes No
NWEASD 174 on at

Like (1)

Report
Copy link

Link copied!

Sure thing.

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.

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.

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
NWEASD 174 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No