Filtering off the OData__ModerationStatus

[NWEASD]

I am trying to filter a sharepoint list based on the Approval Status.  I confirmed that the flow is running when I do not filter on the Approval Status.  When I ass the OData__ModerationStatus eq 'Pending' (or '2') it fails.  Any thoughts on how to make this work?  

[PrasadAthalye]

I tested using GetItems and it worked fine. Refer below. The field is of type integer. Can you remove single quotes around the value 2 and test?

[NWEASD]

This still fails.  

[NWEASD]

I have given up on trying to filter by the ModerationStatus.  Now when I go to paging and try to get it to pull more than 100 records to run in the apply to each loop I am getting an missing required property.  I am not sure where this came from.  Any thoughts on this?

[v-LilyW-msft · Accepted solution]

Hi @NWEASD 

Has your problem been solved?

Is your 'OData__ModerationStatus' column a choice type?

I test on my side with the filter below and it can works well.

You can try it again with the filter below.

Created le '2021-11-16' and OData__ModerationStatus eq 'Pending'

Regarding this error, please check if there is a blank value in your EndDate column.

If yes, please review the items in the list and fill that blank field and try again.

Hope the content above may help you.

Best Regards

[NWEASD]

So I will try the OData__ModerationStatus again.  I am not sure of the column type of this as I am trying to reference the current status of an approval item.  Basically, I do not care about pulling anything that has an Approved Status.  

As far as the EndDate issue I am seeing, I do not have a column on the sharepoint list that is called EndDate.  I have an End Time and that is required for every item on the list to have.  There should not be an item on the list that does not have an End Time value.

[NWEASD]

Update on this.  I was able to get the OData__ModerationStatus to filter.  Thankfully.  Now the problem that I am running into is the EndDate issue.  I am not sure why.  I only get this issue when I am trying to use the "End Time" column and I pull more than 1 record in the get items.  I confirmed that the column has the correct information in it when I pull that 1 record.

[NWEASD]

To give you a picture update of what is happening.

It seems like the item it is pulling has a null end time.  When I open that item, it is showing the correct end time.  Not sure why it is acting that way.

[NWEASD]

Not sure why the 1 item supposedly does not have an end time but I just configured a run-on failure and it worked and got me the information I needed.  Thanks for your help on this.