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)

Sort by

adilei Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Can you paste the JSON payload here as text?

Was this reply helpful? Yes No
Tobias_Brouwer 8 on at

Like (0)

Report
Copy link

Link copied!

{ "@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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

{
"@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
Copy link

Link copied!

Working on the same issue, any movement?

Was this reply helpful? Yes No
jga_lu on at

Like (0)

Report
Copy link

Link copied!

Same, I'm interested too

Was this reply helpful? Yes No
adilei Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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