Power Platform Community Forum Thread Details

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

Community site session details

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

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates