Get Value from Json Output in Copilot studio

(0) Share

Report

Posted on by Tobias_Brouwer

Hi,

I am really struggeling with Parsing a value from a JSON output from a connector.

I try to get the values of the property name "value" from the property "CreatedDateTime".

When I use the Set Variable and I enter a Formula I get this error.

How to fix this?

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

adilei on at

Like (0)

Report

Can you paste the JSON payload here as text?

Was this reply helpful? Yes No
Tobias_Brouwer 8 on at

Like (0)

Report

{ "@odata.deltaLink": null, "@odata.nextLink": null, "value": [ { "body": "<html>, "categories": [], "createdDateTime": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-02-29T09:17:48.2574022Z" }, "end": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-03-04T10:30:00.0000000Z" }, "endWithTimeZone": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-03-04T10:30:00.0000000Z" }, "iCalUId": "040000008200E00074C5B7101A82E0080000000050EC6A82F86ADA010000000000000000100000008D7C54BC53E2D545B9D1F7BF04CB1ED9", "id": "AAMkADY5MWIwMGJkLWQzNTgtNGRmNS1iZTk1LWQ2MmY4MGQ1YzVlYwBGAAAAAABM367r9ZRQTa3Pe5S1LmZ3BwBcdMM2Dp4CTLwdTujvm8bqAAAAAAENAABcdMM2Dp4CTLwdTujvm8bqAAJ3DhZNAAA=", "importance": "normal", "isAllDay": false, "isHtml": true, "isReminderOn": false, "lastModifiedDateTime": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-02-29T09:17:50.4076005Z" }, "location": "", "numberOfOccurences": null, "optionalAttendees": "", "organizer": "t.brrmaris.nl", "recurrence": "none", "recurrenceEnd": null, "reminderMinutesBeforeStart": 15, "requiredAttendees": "t.bteis.nl;", "resourceAttendees": "", "responseRequested": true, "responseTime": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "0001-01-01T00:00:00.0000000Z" }, "responseType": "none", "selectedDaysOfWeek": null, "sensitivity": "normal", "seriesMasterId": null, "showAs": "busy", "start": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-03-04T09:30:00.0000000Z" }, "startWithTimeZone": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-03-04T09:30:00.0000000Z" }, "subject": "Voeg", "timeZone": "UTC", "webLink": "https://outlooDY5MWI" }}

Was this reply helpful? Yes No
adilei on at

Like (0)

Report

This JSON is not valid. Not sure if that is the issue, but it means that I'm not able to test anything.

Was this reply helpful? Yes No
Tobias_Brouwer 8 on at

Like (0)

Report

{
"@odata.deltaLink": null,
"@odata.nextLink": null,
"value": [
{
"body": "<html>",
"categories": [],
"createdDateTime": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-02-29T09:17:48.2574022Z"
},
"end": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-03-04T10:30:00.0000000Z"
},
"endWithTimeZone": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-03-04T10:30:00.0000000Z"
},
"iCalUId": "040000008200E00074C5B7101A82E0080000000050EC6A82F86ADA010000000000000000100000008D7C54BC53E2D545B9D1F7BF04CB1ED9",
"id": "AAMkADY5MWIwMGJkLWQzNTgtNGRmNS1iZTk1LWQ2MmY4MGQ1YzVlYwBGAAAAAABM367r9ZRQTa3Pe5S1LmZ3BwBcdMM2Dp4CTLwdTujvm8bqAAAAAAENAABcdMM2Dp4CTLwdTujvm8bqAAJ3DhZNAAA=",
"importance": "normal",
"isAllDay": false,
"isHtml": true,
"isReminderOn": false,
"lastModifiedDateTime": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-02-29T09:17:50.4076005Z"
},
"location": "",
"numberOfOccurences": null,
"optionalAttendees": "",
"organizer": "t.brrmaris.nl",
"recurrence": "none",
"recurrenceEnd": null,
"reminderMinutesBeforeStart": 15,
"requiredAttendees": "t.bteis.nl;",
"resourceAttendees": "",
"responseRequested": true,
"responseTime": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "0001-01-01T00:00:00.0000000Z"
},
"responseType": "none",
"selectedDaysOfWeek": null,
"sensitivity": "normal",
"seriesMasterId": null,
"showAs": "busy",
"start": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-03-04T09:30:00.0000000Z"
},
"startWithTimeZone": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-03-04T09:30:00.0000000Z"
},
"subject": "Voeg",
"timeZone": "UTC",
"webLink": "https://outlooDY5MWI"
}
]
}

Was this reply helpful? Yes No
MattMMeyer 6 on at

Like (0)

Report

Working on the same issue, any movement?

Was this reply helpful? Yes No
jga_lu on at

Like (0)

Report

Same, I'm interested too

Was this reply helpful? Yes No
adilei on at

Like (1)

Report

I would raise a case with support, as First(topic.myVar.value).createdDateTime is parsed as a DateTimeNoTimeZone, and Copilot Studio does not seem to be able to convert this type to any other type.

Was this reply helpful? Yes No