iCal to Outlook - Filtered Calendar?

Question

I have a sheet that collects information relevant to multiple people, think of these items as task assignments. I would like to have this integrated into each individual's Outlook calendar, but I want to filter it only to what pertains to them, is this possible?

I understand it can't be done from a report. I also considered copying rows to individual sheets, but then I lose the ability to have any further information updated from the master sheet? Thoughts?

ScottyB123 · Answer

Thanks for your response, @AngB789. I've never heard of 'Power Automate'! I will investigate, thanks for giving me a string to pull :)

AngB789 · Answer

Hello @ScottyB123.

Do you have Power Automate? If you do I would suggest below:

*If you have Power Automate*

Use Power Automate to push tasks to each person’s Outlook Calendar:

Power Automate watches your master sheet and whenever:

-A task is assigned to someone

-A date changes

- A status changes

It creates or updates a calendar event on the correct person’s Outlook calendar.