Hello,
I am using Power Automate and ive created a trigger on Activity.
What the trigger is?: So when a user creates a Activty on another user, the owner of the activity should get a notifications.
Problem: It works, but for some reason on this one user it does not work, and i cant figure it out. First i noticed the User it fails on has the name "Stig-André" And i thought it was becasue of the special charachter, but i removed with with a replace function, but still the same error.
I would really appreciate if someone could help me debug this.
The error always points to the "add_a_new_row" node:
Here is the data jsonstring:
{
"body": "@{triggerOutputs()?['body/description']}\n\n\n\n Opprettet av: **@{replace(outputs('Get_a_row_by_ID')?['body/fullname'], 'é', 'e')}**\n\n\n\n Forfaller: **@{formatDateTime(parseDateTime(coalesce(triggerOutputs()?['body/scheduledend'], '2000-01-01T00:00:00Z')), 'dd.MM.yyyy', 'nb-NO')}** \n\n\n\n Angående: **@{outputs('Get_a_row_by_ID_2')?['body/name']}** \n\n\n\n Emne: **@{triggerOutputs()?['body/subject']}**",
"actions": [
{
"title": "Åpne avtale",
"data": {
"url": "main.aspx?appid=3000c89f-8a89-4959-98a3-b60491334745&pagetype=entityrecord&etn=task&id=@{triggerOutputs()?['body/activityid']}"
}
}
]
}
Here is the error:
Data field of the notification is not a valid JSON string. Please verify and try again. Newtonsoft.Json.JsonReaderException: After parsing a value an unexpected character was encountered: t. Path 'body', line 2, position 28.
at Newtonsoft.Json.JsonTextReader.ParsePostValue(Boolean ignoreComments)
at Newtonsoft.Json.JsonTextReader.Read()
at Newtonsoft.Json.Linq.JContainer.ReadContentFrom(JsonReader r, JsonLoadSettings settings)
at Newtonsoft.Json.Linq.JContainer.ReadTokenFrom(JsonReader reader, JsonLoadSettings options)
at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader, JsonLoadSettings settings)
at Newtonsoft.Json.Linq.JObject.Parse(String json, JsonLoadSettings settings)
at Microsoft.CDS.AppNotifications.Plugins.CommonHelper.ValidateDataField(String data, IServiceProvider serviceProvider, ILogger logger)
And here is the error image:
Input data:
{
"body": "<div data-wrapper="true" dir="ltr" style="font-size:9pt;font-family:'Segoe UI','Helvetica Neue',sans-serif;"><div>test2</div></div>\n\n\n\n Opprettet av: **Stig-Andre Rosseland**\n\n\n\n Forfaller: **30.06.2023** \n\n\n\n Angående: **7fjell Entreprenør AS** \n\n\n\n Emne: **Avtale test fredag 2**",
"actions": [
{
"title": "Åpne avtale",
"data": {
"url": "main.aspx?appid=3000c89f-8a89-4959-98a3-b60491334745&pagetype=entityrecord&etn=task&id=50d94bc2-1117-ee11-8f6d-000d3aba348e"
}
}
]
}
And Here is the Output data that tells me the error:
{
"error": {
"code": "0x80048d0b",
"message": "Data field of the notification is not a valid JSON string. Please verify and try again. Newtonsoft.Json.JsonReaderException: After parsing a value an unexpected character was encountered: t. Path 'body', line 2, position 28.\r\n at Newtonsoft.Json.JsonTextReader.ParsePostValue(Boolean ignoreComments)\r\n at Newtonsoft.Json.JsonTextReader.Read()\r\n at Newtonsoft.Json.Linq.JContainer.ReadContentFrom(JsonReader r, JsonLoadSettings settings)\r\n at Newtonsoft.Json.Linq.JContainer.ReadTokenFrom(JsonReader reader, JsonLoadSettings options)\r\n at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader, JsonLoadSettings settings)\r\n at Newtonsoft.Json.Linq.JObject.Parse(String json, JsonLoadSettings settings)\r\n at Microsoft.CDS.AppNotifications.Plugins.CommonHelper.ValidateDataField(String data, IServiceProvider serviceProvider, ILogger logger)",
"@Microsoft.PowerApps.CDS.ErrorDetails.OperationStatus": "0",
"@Microsoft.PowerApps.CDS.ErrorDetails.SubErrorCode": "-2146233088",
"@Microsoft.PowerApps.CDS.ErrorDetails.Plugin.ExceptionFromPluginExecute": "Microsoft.CDS.AppNotifications.Plugins.CreateAppNotificationPlugin",
"@Microsoft.PowerApps.CDS.ErrorDetails.Plugin.ExceptionRetriable": "False",
"@Microsoft.PowerApps.CDS.ErrorDetails.Plugin.ExceptionSource": "PluginExecution",
"@Microsoft.PowerApps.CDS.ErrorDetails.Plugin.OriginalException": "PluginExecution",
"@Microsoft.PowerApps.CDS.ErrorDetails.Plugin.PluginTrace": "",
"@Microsoft.PowerApps.CDS.TraceText": "\r\n[Microsoft.CDS.AppNotifications.Plugins: Microsoft.CDS.AppNotifications.Plugins.CreateAppNotificationPlugin]\r\n[c02c2298-6e96-463a-b751-c1918507f615: Microsoft.CDS.AppNotifications.Plugins.CreateAppNotificationPlugin: Create of app Notification]\r\n\r\n",
"@Microsoft.PowerApps.CDS.InnerError.Message": "Data field of the notification is not a valid JSON string. Please verify and try again. Newtonsoft.Json.JsonReaderException: After parsing a value an unexpected character was encountered: t. Path 'body', line 2, position 28.\r\n at Newtonsoft.Json.JsonTextReader.ParsePostValue(Boolean ignoreComments)\r\n at Newtonsoft.Json.JsonTextReader.Read()\r\n at Newtonsoft.Json.Linq.JContainer.ReadContentFrom(JsonReader r, JsonLoadSettings settings)\r\n at Newtonsoft.Json.Linq.JContainer.ReadTokenFrom(JsonReader reader, JsonLoadSettings options)\r\n at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader, JsonLoadSettings settings)\r\n at Newtonsoft.Json.Linq.JObject.Parse(String json, JsonLoadSettings settings)\r\n at Microsoft.CDS.AppNotifications.Plugins.CommonHelper.ValidateDataField(String data, IServiceProvider serviceProvider, ILogger logger)"
}
}
