Forum Discussion

LISTSNEED124's avatar
LISTSNEED124
Copper Contributor
Jan 06, 2021

Sharepoint Calendar view Filter / Calculated columns?

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...
Lists
microsoft lists
SharePoint Online
Matti Paukkonen's avatar
Matti Paukkonen
Iron Contributor
Jan 07, 2021

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?

  • LISTSNEED124's avatar
    LISTSNEED124
    Copper Contributor
    Jan 07, 2021

    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?

     

Resources