Power Platform Community Forum Thread Details

I work in a hospital, and while most everything is done within our EMR, one of our clinical programs does all of their "planning" within MS Outlook. The admins will put in available first appointment dates, and with which clinicians. The clinicians are formally attached to the Outlook Event as a "Required Attendee" (although sometimes slotted as "optional attendee"). By having the user directly connected to the event - there should in theory be a way to grab the user details (at least - it would work that way in SQL which I am more familiar with). I am pulling the Calendar Details for both historical information, as well as projections of available appointments in the next 3 months as part of job planning.

The only fields within the "Get Calendar View of Events" action that provides user data pulls their email address. I am not seeing options to get their full names, departments, roles, or any other User specific data outside of that e-mail address.

I have tried to hunt a bit for other "get details", "get event", "get relevant people", etc. without luck of finding any functions that could JOIN the User level data to the Outlook event.

I already have all the required Event columns (Date of Event, Subject, ID), and the flow is built where any updates to the Calendar will update the excel database it is linked to based upon the Action Type (update, deleted, etc.) and using a Key Column of the Event ID. But I need to get User level data columns for the attached clinicians so that I can separate out the different roles (i.e. psychiatry, occupational therapy, etc.).

What additional actions can I add that will allow me to grab the User level data from the Outlook Calendar events?

Appreciate your thoughts!

Edit: Flow Details
Outlook - When an event is added, updated, or deleted
** Need to place a step here that can grab the User Data of those in the Calendar Event

Condition - Action Type is EQUAL TO Added

If Yes - Add row into Table (Event and User data)

If No - Condition - Action Type is EQUAL TO Updated

If Yes - Update a Row (Key Value = Outlook Event ID)

If No - Delete a Row (Key Value = Outlook Event ID)

Table is initially populated by a separate flow triggered manually to capture all existing events. Unable to find User level columns in either situation.

Categories:

Building flows