Skip to main content

Notifications

Power Automate - Building Flows
Answered

How to get the username o email address of an entry shared calendar in teams

Posted on by 38

Hi everyone
I have created a shared calendar in the General tab of a Teams channel.
I would like to get the user name or email addres of the owner of one created entry. 
I shared the calendar with 400 people, every one of them will create a booking for an interview.
With Power automate I would like to get who created the schedule and add it to an excel online 
Currently I am using the Teams trigger and the "get details message", however I don't see any way to get this info.


Is there any way to do that?
Thank
Carlos G.

  • CAGC031268 Profile Picture
    CAGC031268 38 on at
    Re: How to get the username o email address of an entry shared calendar in teams

    Excellent solution Nived!!!!... I appreciate your time to help me.

    Best regards

    Carlos G.

  • Verified answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 16,559 on at
    Re: How to get the username o email address of an entry shared calendar in teams

    Hi @CAGC031268 

     

    For the first method you have used, , after getting the message details

    Nived_Nambiar_0-1684029396809.png

     

     

    use get user profile / search for users under office 365 users action. 

    Nived_Nambiar_1-1684029424742.png

     

    then pass the id which I have highlighted in first screemshot into the get user or search for users action, you will get details like display name, email etc as output which you can then pass into the add row into table action 🙂

     

    Hope this helps !

     

    Mark it as solution if it resolves your query !

     

  • CAGC031268 Profile Picture
    CAGC031268 38 on at
    Re: How to get the username o email address of an entry shared calendar in teams

    Thanks a lot Nived for the new response...

    I am not sure if I am doing something wrong. Probably I am not using the correct trigger and/or actions.

     

    The new event entries in the shared teams calendar are added to share team calendar and to the calendar of the owner's event. That is ok from my side.

    remember that the owner of the shared Teams calendar is me. These new entries created by my team are not added to my personal calendar. That is ok for me.

     

    I have prepared a PDF file with the details I am doing and my goal

     

    I hope it can "help you to help me"

    Best

    Carlos G.

     

     

     

     

  • CAGC031268 Profile Picture
    CAGC031268 38 on at
    Re: How to get the username o email address of an entry shared calendar in teams

    Hi Nived_Nambiar, 

    Thanks a lot for the quick response. 

    it does not work for me, because using this trigger I just get my personal calendar. 

    I am working with a calendar created in the General TAB of Microsoft Teams (see my second screen).

    As you could know, we have a trigger available for Team but, it does not have any "action" in order to get this field (see my third screen).

    It seems that the Teams connector has not been developed deeply

     

    CAGC031268_0-1683801483888.png

     

    I have inserted the default calendar offered by Teams for the General tab (it is free)..in this case I named it as "AgendaEntrevistaDocente"

    This calendar, was shared to my team (I added them as members). But, the entry calendar created by them does not include the username. And I would like to rescue the username automatically and send it to a excel online row. I need to know who already scheduled.

     

    CAGC031268_1-1683801913139.png

     

     

    I just see this manner to get the details of any entry calendar (for my scenario)

    CAGC031268_2-1683802346238.png

     

    However, as you could see, this trigger does not include any action related with new events.

     

    In this trigger, I explored the action "get message details"..it looks fine, however, the platform only give me this field(yellow), and honestly I don't know how I can transform it to a plain text...it delivers a serial ID...and it general, most of the actions deliver a serial number...

    I appreciate if you can guide me...

     

    CAGC031268_3-1683802528366.png

     

     

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 16,559 on at
    Re: How to get the username o email address of an entry shared calendar in teams

    Hi @CAGC031268 

     

    try this 

     

    Nived_Nambiar_0-1683770263996.png

     

    (I could see even if you create a shared calendar in channel, whenever you add events to it, it will appear on main calendar, so in that case, when event is created trigger is used)

     

    Hope it helps !

     

    Mark it as solution if it resolves your query 🙂

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard