Unanswered

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)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

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,865 Most Valuable Professional on at

Like (2)

Report
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

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