Jan 06 2021 02:09 PM
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
Jan 06 2021 09:08 PM
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?
Jan 07 2021 09:03 AM
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?