Hello Team,
I am working on a flow that creates an MDA in-app notification when there is a new email created in Dataverse that is regarding another record. Here's the trigger:
The goal is to ensure that this flow only triggers on the creation of email records wherein the regarding column of the email contains data and the the email is regarding a record in a custom table with a schema name of rgg_dctickets.
Here's the raw output of the trigger with no filter query
{
"notifications": 0,
"_notifications_label": "None",
"isunsafe": 0,
"correlationmethod": 0,
"_correlationmethod_label": "None",
"statuscode": 1,
"_statuscode_label": "Draft",
"description": "<div></div><div style=\"direction:ltr\"><div id=\"signature\">\n\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\n\n\n<div>\n<div data-wrapper=\"true\" style=\"font-size:9pt; font-family:\" segoe=\"\" ui\",\"helvetica=\"\" neue\",sans-serif;=\"\" direction:ltr\"=\"\">\n<div>\n<p dir=\"LTR\" style=\"\" align=\"LEFT\"><font class=\"x_keyboardFocusClass\" style=\"display:inline\" size=\"2\"><span class=\"x_keyboardFocusClass\" style=\"\" lang=\"EN\">Thanks,<br>\n<br>\nfirst last<br>\n<font style=\"\" size=\"2\"><font style=\"\" size=\"2\"><font class=\"x_keyboardFocusClass\" style=\"\" size=\"2\"><span style=\"color:rgb(31,73,125)\"><b style=\"font-family:Arial\">Quotation Specialist</b></span></font></font></font><br>\n<font style=\"\" size=\"2\" color=\"#1f497d\"><font style=\"\" size=\"2\" color=\"#1f497d\"><font class=\"x_keyboardFocusClass\" style=\"\" size=\"2\" color=\"#1f497d\"><font style=\"\" face=\"Arial\"><b>Microsoft 365 | Power Platform Administrator</b></font></font></font></font></span></font><br>\n<font class=\"x_keyboardFocusClass\" style=\"display:inline\" size=\"2\"><span class=\"x_keyboardFocusClass\" style=\"\" lang=\"EN\"><font style=\"\" size=\"2\" color=\"#1f497d\"><font style=\"\" size=\"2\" color=\"#1f497d\"><font class=\"x_keyboardFocusClass\" style=\"\" size=\"2\" color=\"#1f497d\"><font style=\"font-family:Helvetica\" face=\"Tahoma, Verdana, Arial\"> </font></font></font></font><br>\n<font size=\"2\" face=\"Arial\" color=\"#6c6c6c\"><font size=\"2\" face=\"Arial\" color=\"#6c6c6c\"><font size=\"2\" face=\"Arial\" color=\"#6c6c6c\"><b>Email:</b></font></font></font><font size=\"2\" face=\"Arial\" color=\"#1f497d\"><font class=\"x_keyboardFocusClass\" size=\"2\" face=\"Arial\" color=\"#1f497d\"><font size=\"2\" face=\"Arial\" color=\"#1f497d\">\n customer.service@example.com<br>\nBusiness Hours: Monday - Wednesday (7:30am - 4:30pm)</font></font></font></span></font></p>\n<p dir=\"LTR\" style=\"\" align=\"LEFT\"><font class=\"x_keyboardFocusClass\" style=\"display:inline\" size=\"2\"><span class=\"x_keyboardFocusClass\" style=\"\" lang=\"EN\"><font style=\"\" size=\"2\" face=\"Arial\"><font style=\"\" size=\"2\" face=\"Arial\"><font style=\"\" size=\"2\" face=\"Arial\"><span style=\"\" lang=\"EN\"><a href=\"http://www.example.com/\" style=\"color:rgb(15,111,3); font-weight:bold\">www.example.com</a></span></font></font></font></span></font></p>\n</div>\n</div>\n</div>\n\n\n</div></div>",
"compressed": false,
"createdon": "2023-01-12T17:49:15Z",
"attachmentcount": 0,
"followemailuserpreference": false,
"statecode": 0,
"_statecode_label": "Open",
"isbilled": false,
"isemailfollowed": false,
"deliveryreceiptrequested": false,
"directioncode": true,
"_ownerid_value": "a5816a23-f87c-eb11-a812-000d3a3bd8f6",
"_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
"_ownerid_type": "systemusers",
"modifiedon": "2023-01-12T17:49:15Z",
"emailremindertype": 0,
"_emailremindertype_label": "If I do not receive a reply by",
"prioritycode": 1,
"_prioritycode_label": "Normal",
"_owningbusinessunit_value": "071dadad-83dc-e411-80ef-c4346bb5ebe0",
"_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "businessunit",
"_owningbusinessunit_type": "businessunits",
"isregularactivity": true,
"isemailreminderset": false,
"_modifiedby_value": "a5816a23-f87c-eb11-a812-000d3a3bd8f6",
"_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
"_modifiedby_type": "systemusers",
"readreceiptrequested": false,
"activitytypecode": "email",
"_regardingobjectid_value": "8fa286ee-1f77-ed11-81ab-00224805f697",
"_regardingobjectid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "rgg_dcticket",
"_regardingobjectid_type": "rgg_dctickets",
"sender": "first.last@example.com",
"isworkflowcreated": false,
"torecipients": "first.last@example.com;",
"deliveryprioritycode": 1,
"_deliveryprioritycode_label": "Normal",
"_createdby_value": "a5816a23-f87c-eb11-a812-000d3a3bd8f6",
"_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
"_createdby_type": "systemusers",
"emailreminderstatus": 0,
"_emailreminderstatus_label": "NotSet",
"activityid": "7d43b16c-a192-ed11-aad1-00224805f697",
"mimetype": "text/xml",
"ItemInternalId": "7d43b16c-a192-ed11-aad1-00224805f697",
So, it appears the output is returning the attribute (_regardingobjectid_type) that I'm querying against:
I've tried putting the value in single quotations, double quotations, and no quotations. But, the flow still won't trigger with this filter query. Any idea what I may be doing wrong here?
