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?
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.
Hi @NWEASD
Thanks for your quick reply.
Moderation Status values are:
Try OData__ModerationStatus eq '2'
Let me know the results.
Thanks
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.
Hi @NWEASD
Could you post a screenshot of your SharePoint column (ModerationStatus) setting details?
Thanks
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,075
Most Valuable Professional