Forum Discussion

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...

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

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?