Modern Page: News Web Part; I cannot filter on Yes/No Column

%3CLINGO-SUB%20id%3D%22lingo-sub-1447609%22%20slang%3D%22en-US%22%3EModern%20Page%3A%20News%20Web%20Part%3B%20I%20cannot%20filter%20on%20Yes%2FNo%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447609%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20added%20a%20Yes%2FNo%20column%20on%20the%20Site%20Pages%20Library%20but%20under%20Filter%2C%20I%20cannot%20selected%20it%20in%20the%20list%20of%20Pages%20Property%20in%20the%20News%20Web%20Part.%3C%2FP%3E%3CP%3EIs%20it%20normal%3F%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EChristophe%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1447609%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447695%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Page%3A%20News%20Web%20Part%3B%20I%20cannot%20filter%20on%20Yes%2FNo%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447695%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F175263%22%20target%3D%22_blank%22%3E%40Christophe%20Raucq%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20I%20am%20not%20fully%20understanding%20what%20you%20mean%20here.%26nbsp%3B%20Please%20can%20you%20provide%20more%20information%20%2F%20description%20and%20perhaps%20some%20screenshots%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447821%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Page%3A%20News%20Web%20Part%3B%20I%20cannot%20filter%20on%20Yes%2FNo%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447821%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F616707%22%20target%3D%22_blank%22%3E%40PeterRising%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Peter%2C%3C%2FP%3E%3CP%3EIn%20my%20Page%2C%20I%20have%20added%20the%20Column%20Archive%3A%20Yes%2FNo%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Archive%20Column.PNG%22%20style%3D%22width%3A%20501px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197212i7A2667B3961867F1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Archive%20Column.PNG%22%20alt%3D%22Archive%20Column.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIn%20the%20News%20Web%20Part%2C%20I%20cannot%20select%20the%20Archive%20property%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22NewsWebPartFilter.PNG%22%20style%3D%22width%3A%20274px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197213iD949E73323F2AFCE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22NewsWebPartFilter.PNG%22%20alt%3D%22NewsWebPartFilter.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EChristophe%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1448161%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Page%3A%20News%20Web%20Part%3B%20I%20cannot%20filter%20on%20Yes%2FNo%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448161%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F175263%22%20target%3D%22_blank%22%3E%40Christophe%20Raucq%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%2C%20are%20you%20talking%20about%20adding%20a%20column%20to%20a%20site%20page%20like%20this%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-06-08%20at%2013.07.53.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197267iD74C67EE2B44CF25%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-06-08%20at%2013.07.53.png%22%20alt%3D%22Screenshot%202020-06-08%20at%2013.07.53.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20so%2C%20what%20type%20of%20column%20did%20you%20choose%3F%26nbsp%3B%20Sorry%20if%20I'm%20missing%20something.%26nbsp%3B%20I%20just%20can't%20seem%20to%20get%20to%20where%20you%20are.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Flaugh_40x40.gif%22%20alt%3D%22%3Alol%3A%22%20title%3D%22%3Alol%3A%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1448420%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Page%3A%20News%20Web%20Part%3B%20I%20cannot%20filter%20on%20Yes%2FNo%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448420%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F175263%22%20target%3D%22_blank%22%3E%40Christophe%20Raucq%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOK%2C%20I%20am%20with%20you.%26nbsp%3B%20And%20how%20in%20the%20News%20Web%20part%20are%20you%20getting%20to%20the%20filtering%20options%20please%3F%20Are%20you%20clicking%20to%20edit%20your%20home%20page%20and%20then%20editing%20the%20News%20web%20part%2C%20or%20are%20you%20clicking%20on%20see%20all%20on%20the%20News%20Web%20Part%20and%20then%20Manage%20Posts%3F%26nbsp%3B%20Apologies%20again%2C%20I'n%20just%20struggling%20to%20get%20to%20some%20of%20the%20places%20you%20are%20getting%20to.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1448345%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20Page%3A%20News%20Web%20Part%3B%20I%20cannot%20filter%20on%20Yes%2FNo%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448345%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F616707%22%20target%3D%22_blank%22%3E%40PeterRising%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Peter%2C%3C%2FP%3E%3CP%3EYou%20are%20on%20the%20right%20spot.%20Like%20I%20said%3A%20the%20Yes%2FNo%20column%20type%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EChristophe%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

I have added a Yes/No column on the Site Pages Library but under Filter, I cannot selected it in the list of Pages Property in the News Web Part.

Is it normal?

Regards,

Christophe

10 Replies
Highlighted

@Christophe Raucq 

 

Hi, I am not fully understanding what you mean here.  Please can you provide more information / description and perhaps some screenshots?

Highlighted

@PeterRising 

Hi Peter,

In my Page, I have added the Column Archive: Yes/No

Archive Column.PNG

In the News Web Part, I cannot select the Archive property

NewsWebPartFilter.PNG

Best regards,

Christophe

Highlighted

@Christophe Raucq 

 

Sorry, are you talking about adding a column to a site page like this please?

 

Screenshot 2020-06-08 at 13.07.53.png

 

If so, what type of column did you choose?  Sorry if I'm missing something.  I just can't seem to get to where you are. :lol:

Highlighted

@PeterRising 

Hi Peter,

You are on the right spot. Like I said: the Yes/No column type

Regards,

Christophe

Highlighted

@Christophe Raucq 

 

OK, I am with you.  And how in the News Web part are you getting to the filtering options please? Are you clicking to edit your home page and then editing the News web part, or are you clicking on see all on the News Web Part and then Manage Posts?  Apologies again, I'n just struggling to get to some of the places you are getting to.

Highlighted

@PeterRising 

In the Home page, you edit the News Web Part

You scroll in the right pane until Filter

Under Filter, you select Page Properties

Under Property Name, in the combobox, you do NOT see the column Archive.

Regards,

Christophe

Highlighted

@Christophe Raucq 

 

Oh yes I see what you are getting at.  Interestingly, when I look at my News Web part, I don't see half the options that you get for filtering/

 

Screenshot 2020-06-09 at 09.10.40.png

 

Sorry I've been no help to you at all and have in fact only asked you questions.  I will play around with this some more though and let you know if I find anything.

Highlighted

@PeterRising 

Thanks

As you are checking the possibilities, you can see that if you are adding a date field for filtering, can you tell me which date format you need in the filter to display only the news for this specific date.

I have tried different formats but nothing works.

Date.PNG

Regards

Highlighted

@Christophe Raucq - I had exactly the same in two different tenants - I ended up here looking for a solution - in the end it was quicker for me just to replace with a Choice field and yes & no choices

 

With your filter question about:

"News Date"

equals

05/20/2020 

 

apart from needing the date in US format despite using dd/mm/yyyy format, I got this working using:

 

"News Date"

between

05/20/2020 0:00

05/20/2020 23:59

Highlighted