Unanswered

Get Outlook account name in flow onto SharePoint List.

(0) Share

Report

Posted on by sskey89

I am building a Meeting tracker so I know which conference rooms are being used. I am using the output "value" from the Outlook calendar for each room.
For my dynamic content I am using "Location" which works in most cases but if a user opens a room calendar, in Outlook, and schedules a Teams meeting the location only says "Microsoft Teams Meeting" but not the room name in the location category.Sharepoint Entry

I am looking for a way to add the account name of the calendar so no matter how a room is scheduled it will display the account name instead of the location.

Flow Flow

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@sskey89

If the email address for the calendar reflects the room name, you might use Organizer from Dynamic properties. You'll need to parse out the "@" and everything that follows (organizer is an email address) but that is easy enough.

Was this reply helpful? Yes No
sskey89 74 on at

Like (0)

Report
Copy link

Link copied!

When I use organizer I get the user who scheduled the meeting, which is what I want, and I'm using it in my Organizer column in SharePoint (the red part in my SharePoint entry picture). Is there a way to use it twice to get the room account and the user who scheduled the meeting?

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@sskey89

I believe that if you schedule the meeting from the room calendar that the organizer IS the room calendar email.

Was this reply helpful? Yes No
sskey89 74 on at

Like (0)

Report
Copy link

Link copied!

The issue is that if someone has a pre-existing Teams meeting and they add the room as a "participant" (instead of location) at a later time the location field doesn't populate the room name and only has "Microsoft Teams Meeting" like the picture below.
I tested this and the meeting is added to the room calendar but the location field remains "Microsoft Teams Meeting" which is why I want to use the account name or calendar name instead of location.

Was this reply helpful? Yes No