cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gareth-
Advocate II
Advocate II

best way to access data items returned by Get Events (V4)

Hi community,

 

I am hitting a brick wall with this.  It is going to be something simple - but it has me stumped, so thanks in advance for any help.

Scenario: I want to grab an ID of a calendar event (so I can extend the invite to another colleague) there are multiple events with similar subject like 'Event Stream 1' , 'Event Stream 2' etc.

 

I am using 'Get Events (V4) ' with an odata query to pull out events when the subject contains 'Event Stream ' - this is all working fine.  Sample output data below (I have changed the email addresses manually for this post and emptied the body text)

{
  "value": [
    {
      "subject": "Event Stream 2",
      "start": "2020-09-24T18:30:00.0000000",
      "end": "2020-09-24T18:55:00.0000000",
      "body": "",
      "isHtml": true,
      "responseType": "organizer",
      "responseTime": "0001-01-01T00:00:00+00:00",
      "id": "AAMkADE3MmJjNjczLWUyMjYtNDU3MS04NzE5LWQyYmUzMjMzMmJmZABGAAAAAACO84RtEwf6R6rgX48Ph_uBwCavEk1Z3d8T49R5hImgL0uAAAAB688AAD-6b1lMvLARKh4i7vuKNUkAAJ2rR8lAAA=",
      "createdDateTime": "2020-09-22T19:10:35.2035891+00:00",
      "lastModifiedDateTime": "2020-09-23T03:25:03.9362746+00:00",
      "organizer": "some.email@company.com",
      "timeZone": "UTC",
      "categories": [],
      "webLink": "https://outlook.office365.com/owa/?itemid=AAMkADE3MmJjNjczLWUyMjYtNDU3MS04NzE5LWyYmUzMjMzMmJmZABGAAAAAACO84RtEwf6R6WrgX48Ph%2BuBwCavEk1Z3d8T49R5hImgL0uAAAAB688AAD%2F6b1lMvLARKh4i7vuKNUkAAJ2rR8lAAA%3D&exvsurl=1&path=/calendar/item",
      "requiredAttendees": "some.email@company.com;",
      "optionalAttendees": "",
      "resourceAttendees": "",
      "location": "Microsoft Teams Meeting",
      "importance": "normal",
      "isAllDay": false,
      "recurrence": "none",
      "reminderMinutesBeforeStart": 0,
      "isReminderOn": true,
      "showAs": "busy",
      "responseRequested": true
    },
    {
      "subject": "Event Stream 1",
      "start": "2020-09-24T18:00:00.0000000",
      "end": "2020-09-24T18:25:00.0000000",
      "body": "",
      "isHtml": true,
      "responseType": "organizer",
      "responseTime": "0001-01-01T00:00:00+00:00",
      "id": "AAMkADE3MmJjNjczLWUyMjYtNDU3MS04NzE5LWQyYmUzMjMzMmJmZABGAAAAAACO84RtEwf6R6WrgX4Ph_uBwCavEk1Z3d8T49R5hImgL0uAAAAB688AAD-6b1lMvLARKh4i7vuKNUkAAJ2rR8kAAA=",
      "createdDateTime": "2020-09-22T19:10:27.0862292+00:00",
      "lastModifiedDateTime": "2020-09-23T03:25:03.7650273+00:00",
      "organizer": "some.email@company.com",
      "timeZone": "UTC",
      "categories": [],
      "webLink": "https://outlook.office365.com/owa/?itemid=AAMkADE3MmJjNjczLWUyMjYtNDU3MS04zE5LWQyYmUzMjMzMmJmZABGAAAAAACO84RtEwf6R6WrgX48Ph%2BuBwCavEk1Z3d8T49R5hImgL0uAAAAB688AAD%2F6b1lMvLARKh4i7vuKNUkAAJ2rR8kAAA%3D&exvsurl=1&path=/calendar/item",
      "requiredAttendees": "some.email@company.com;",
      "optionalAttendees": "",
      "resourceAttendees": "",
      "location": "Microsoft Teams Meeting",
      "importance": "normal",
      "isAllDay": false,
      "recurrence": "none",
      "reminderMinutesBeforeStart": 0,
      "isReminderOn": true,
      "showAs": "busy",
      "responseRequested": true
    }
  ]
}

Is this data (above) a JSON encoded array or a string or?

I need to extract the Subject and ID so I can later filter on Subject and retrieve the ID for use later in the Flow.  

I have tried using Parse JSON as next step, but just get stuck getting hold of the data.

 

What is the best method please?

thanks 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @Gareth- ,

 

I’m afraid I’m not sure what data you need to get. The Dynamic content output by Get events action can be directly quoted. Like:

55.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-bacao-msft
Community Support
Community Support

 

Hi @Gareth- ,

 

I’m afraid I’m not sure what data you need to get. The Dynamic content output by Get events action can be directly quoted. Like:

55.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Many thanks @v-r  thank works fine.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,879)