Power Platform Community Forum Thread Details

Hi everyone!

Was hoping to get some help on a flow I want to build for 2 recurring New Hire Orientations I have scheduled in Outlook. One occurs at 7:30am PT (for our new hires who work in the central or eastern time zones), and another occurs at 9:30am PT (for our new hires who work in the west time zone) so that we can capture our new hires who work across the US in different time zones.

Is there a way to have new hires from a spreadsheet who are assigned to different time zones be automatically added to one of the two New Hire Orientations in Outlook based on their time zone listed in excel? The flow would need to run weekly on a Friday so that new hires for the upcoming Monday are invited to one of two upcoming week's New Hire Orientation (based on their assigned time zone).

Thanks for any guidance here!

Erica