ODATA Filter Query - Only published Sharepoint Pages

(0) Share

Report

Posted on by Community Power Pla...

I want to send an email to a group of people every week containing a table of Sharepoint pages that has been created that week. But I only want the pages that has been published, not only created.

I figured out there is a Version Number value that ends with '.0' if a page is published. But I can not create the query to filter those out. Im using Sharepoint - Get Items but I can not figure out what the version number "column" is called (its not a custom column but a built in one). I've seen several ones mentioned on different sites:

VersionNumber
UIVersionNumber
ODATA_UIVersionNumber
VersionLabel

But no matter which one I try I get the message that my expression is not valid.
Anybody know how to filter out only published pages from Sharepoint?

All responses (1)

Answers (0)

Expiscornovus 32,140 Most Valuable Professional on at

Like (1)

Report

Re: ODATA Filter Query - Only published Sharepoint Pages

Hi @Anonymous,

The name of the field is {VersionNumber}. However, it looks like the OData filter doesn't like the format of this field.

As a workaround you could use a Get filers properties only with pages which have been created in the week. After that you could use filter array to filter for published pages.

Btw, I would also suggest to filter for Promoted State equals 0. Otherwise you would also get the published news posts in your overview.