Sharepoint Calendar view Filter / Calculated columns?

%3CLINGO-SUB%20id%3D%22lingo-sub-2038204%22%20slang%3D%22en-US%22%3ESharepoint%20Calendar%20view%20Filter%20%2F%20Calculated%20columns%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2038204%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20filter%20a%20calendar%20by%20another%20column%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20the%20new%20Microsoft%20lists%20but%20the%20option%20to%20filter%20gives%20me%20an%20error%20and%20then%20I%20just%20get%20a%20blank%20calendar%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOtherwise%20anyone%20knows%20a%20trick%20to%20use%20calculated%20columns%20as%20the%20date%20for%20the%20calendar%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%20would%20be%20greatly%20appreciated.%20I%20have%20been%20stuck%20for%20months%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2038204%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2038892%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Calendar%20view%20Filter%20%2F%20Calculated%20columns%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2038892%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F854194%22%20target%3D%22_blank%22%3E%40LISTSNEED124%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENoticed%20the%20same%20error%20when%20adding%20more%20columns%20to%20calendar%20view%2C%20so%20I%20would%20say%20that%20it's%20not%20currently%20supported.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECalculated%20fields%20cannot%20be%20used%20as%20date%20fields%20for%20calendar%20view.%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20option%20could%20be%20to%20use%20Power%20Automate%20to%20update%20stardard%20date%20field%20based%20on%20action%2C%20for%20example%20when%20list%20item%20is%20updated.%20What%20are%20you%20looking%20for%20to%20achieve%20with%20calculated%20date%20field%20in%20calendar%20view%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2040802%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Calendar%20view%20Filter%20%2F%20Calculated%20columns%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2040802%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5628%22%20target%3D%22_blank%22%3E%40Matti%20Paukkonen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20I%20have%20a%20list%20with%20events%20for%2010%20users%2C%20I%20just%20wanted%20to%20show%20an%20individual%20calendar%20for%20each%20user.%20Basically%20filter%20by%20user%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20thought%20of%20was%20to%20have%20a%20column%20for%20each%20user%20with%20the%20dates%20and%20use%20that%20for%20the%20calendar%20view%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%20is%20that%20they%20need%20to%20constantly%20update%20the%20date%20but%20I%20cant%20have%2010%20date%20box%20inputs%20in%20the%20powerapps%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all,

 

Is there a way to filter a calendar by another column?

 

I am using the new Microsoft lists but the option to filter gives me an error and then I just get a blank calendar

 

Otherwise anyone knows a trick to use calculated columns as the date for the calendar?

 

Help would be greatly appreciated. I have been stuck for months 

2 Replies

Hi @LISTSNEED124,

 

Noticed the same error when adding more columns to calendar view, so I would say that it's not currently supported. 

 

Calculated fields cannot be used as date fields for calendar view. 

One option could be to use Power Automate to update stardard date field based on action, for example when list item is updated. What are you looking for to achieve with calculated date field in calendar view?

Hi @Matti Paukkonen 

 

Basically I have a list with events for 10 users, I just wanted to show an individual calendar for each user. Basically filter by user

 

What I thought of was to have a column for each user with the dates and use that for the calendar view

 

Problem is that they need to constantly update the date but I cant have 10 date box inputs in the powerapps form.

 

Any ideas?