Skip to main content
Community site session details

Community site session details

Session Id : RJx36RJFUcUk3tS2268zu+
Power Automate - Building Flows
Unanswered

Power Automate Outlook Triggers are pulling different "id" information

Like (0) ShareShare
ReportReport
Posted on 18 Aug 2023 15:46:04 by 4

Good Morning,

I have been all over this forum and have come up short. I am running into some issues with Power Automate and need of some assistance.  I have been tasked to move a share calendar of event to a visual to power bi to only show certain items. Since this calendar is used to track different type of event and the users are good for using their categories to separate their events. So, what I decided to do without creating a separate calendar to take required recurring events from different levels.

  1. I use “Get calendar view of events (V3)”
  2. Which I use to identity the calendar I am using.
  3. I do an “Apply to each”
  4. Convert time Zone: (Start time zone)
  5. Convert time Zone: (End time zone)
  6. Compose: guid ()
  7. And apply the results by “Add a row into a table” using the Excel Action with the following columns:
    1. Subject
    2. Start Time (expression: formatDateTime(outputs('Start_time_Zone')?['body'],'MM-dd-yyyy HH:mm')
    3. End Time (expression: formatDateTime(outputs('Start_time_Zone')?['body'],'MM-dd-yyyy HH:mm')
    4. Categories: items('Apply')?['categories']?[0]
    5. Id
    6. seriesMasterId
    7. iCalUId
    8. MappedID (from compose action) more information on this later.

Now, this function great and information is loaded into the excel document. The next requirement is where I am having some issues and does not make any sense.

The users would also like to be notified when there is a change or modification to a single event in a series or the entire series. The single would then send out an email to required and optional attendees. However, with the entire series modification will need to be approved before the update occurs. And I pretty much under stand this for the most part. When I create the second flow to use either available Outlook trigger in Power Automate the pull and completely different “id” which should be unique identifier correct? This is the reason I created the guid and try to get the flow to look into the excel document by comparing the start/end date as well as other combination and that has not been working.

 

Here are my questions.

Why are the Outlook triggers pulling different id from my outlook calendar?

  • If the id were the same, this would not be an issue.
  • How if I do just one singular event that is not attached to a series it works??
  • The second flow would be an automatic flow but it fails because there is no matching "id" and that is why created the guid, but still fails as well.
  • Wiz2023 Profile Picture
    4 on 22 Aug 2023 at 14:25:17
    Re: Power Automate Outlook Triggers are pulling different "id" information

    @Nived_Nambiar 

    Here is the event "Id" that is being pulled by 1 Outlook Trigger and 2 Outlook Actions:

     

    "Get calendar view of events (V3)" (This is an action)
    AAMkADJmZTg5NGMzLWIyOGUtNDhkNy1iNGU4LWRjNzQzYjU1NGMzNAFRAAgI26Q1D01AAEYAAAAAaiKjNwq7uUmjwa4RmVqvKwcAASl74Oniyk21HcVFuvsWEAAAQa1g1wAAASl74Oniyk21HcVFuvsWEAAAQa2A0AAAEA==

     

    "When an event is added, updated or deleted" (This is a trigger)
    AAMkADJmZTg5NGMzLWIyOGUtNDhkNy1iNGU4LWRjNzQzYjU1NGMzNAFRAAgI29-tprJAAEYAAAAAaiKjNwq7uUmjwa4RmVqvKwcAASl74Oniyk21HcVFuvsWEAAAQa1g1wAAASl74Oniyk21HcVFuvsWEAAAQa2A0AAAEA==

     

    "When an event is modified (V3)" (This is a trigger)
    AAMkADJmZTg5NGMzLWIyOGUtNDhkNy1iNGU4LWRjNzQzYjU1NGMzNABGAAAAAABqIqM3Cru5SaPBrhGZWq8rBwABKXvg6eLKTbUdxUW6_xYQAABBrWDXAAABKXvg6eLKTbUdxUW6_xYQAABBrYDQAAA=

     

    This seems to be the issue that I am having right now, no 'id" it is being pulled in the same for the same outlook event.

     

    Thank you for your time and effort.

     

    Wiz2023

  • Wiz2023 Profile Picture
    4 on 22 Aug 2023 at 13:11:30
    Re: Power Automate Outlook Triggers are pulling different "id" information

    Good Morning @Nived_Nambiar;

    Here are the answers to your questions above.

    1. To get all of my events from Outlook I am using the trigger “Get calendar view of events (V3)”. However, any other Outlook trigger that I am trying to use is pulling in an entirely different "ID" from Outlook for the same events. That is why I can up with the idea to use a guid, that Power Automate assigns with getting events.

     

    2. We have tried everything we could to not go the guid route. And you are right in that matter of using ID, but the only time that the "ID" are the same are for a single event that is not recurring that is created in Outlook. With that then all the other triggers in Power Automate seem to function correctly. However, 99% of the events that we create here are recurring and the triggers seems not to function correctly when dealing with them.

     

    3. So for the second flow, is to identify changes for single event in a series and the recurring series as a whole. The single event in the series will just get an alert email of the change and changes in the recurring series will go through an approval process before changes are made and then an email alert will go out.

     

    My biggest challenge is the triggers at this moment and why are they are not pulling the same ID from Outlook? Or am I missing something here?

     

    Thank you for your time and effort.

     

    Wiz2023

  • Nived_Nambiar Profile Picture
    17,972 Super User 2025 Season 2 on 20 Aug 2023 at 14:19:59
    Re: Power Automate Outlook Triggers are pulling different "id" information

    Hi @Wiz2023 

     

    First of all i have few doubts/ need few confirmations.

     

    1. i did not get what u meant by below highlighted one ?

    Nived_Nambiar_0-1692541015054.png

     

     

    2. Also you are using guid as id for event when documenting in excel, at that point why you haven't used the ID from event as ID there, correct me if i am wrong here .

     

    3. For your second flow , you are trying to do a flow which sends an email to attendees when any event in recurrance changes  right ?

     

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!