You’re offline. This is a read only version of the page.
Announcements
Hi
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:
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?
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.
Share
Report
All responses (
Answers (
33,189
