Unanswered

Filtering off the OData__ModerationStatus

(0) Share

Report

Posted on by NWEASD

174

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?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

PrasadAthalye on at

Like (1)

Report

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?

Was this reply helpful? Yes No
NWEASD 174 on at

Like (0)

Report

This still fails.

Was this reply helpful? Yes No
NWEASD 174 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft on at

Like (1)

Report

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

Was this reply helpful? Yes No
NWEASD 174 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
NWEASD 174 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
NWEASD 174 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
NWEASD 174 on at

Like (0)

Report

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.

Was this reply helpful? Yes No