The result output has two records in the JSON file - one for each list I believe. Now what I need to do is to flatten that data into ONE record. Or select the field from the file. In testing, I used the Select connector and from there I was able to create those values in the body of an email, however, the test sent TWO emails (one for each record in the JSON file). I just need it to send one email.
[
{
"@odata.etag": "\"1\"",
"ItemInternalId": "1",
"ID": 1,
"Title": "6043e266-6550-400d-9e38-432b9ea9a67a",
"KARE": false,
"MSDynamics": false,
"OtherApps": "Power Apps, Power BI, SharePoint Admin",
"KAREEmailAlerts": false,
"KAREUnreadMessages": false,
"KARESupervisorSign": false,
"DeleteKARE": true,
"DeleteGP": false,
"Modified": "2023-02-28T20:06:42Z",
"Created": "2023-02-28T20:06:42Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|XXX",
"DisplayName": "Allison",
"Email": "XXX",
"Picture": "XXX",
"Department": "Information Technology Services",
"JobTitle": "Software Developer"
},
"Author#Claims": "i:0#.f|membership|XXX",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|ballison@iskzoo.org",
"DisplayName": "Allison",
"Email": "XXX",
"Picture": "XXX",
"Department": "Information Technology Services",
"JobTitle": "Software Developer"
},
"Editor#Claims": "i:0#.f|membership|XXX",
"{Identifier}": "Lists%252fEURAppAccess%252f1_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "XXX",
"{Name}": "6043e266-6550-400d-9e38-432b9ea9a67a",
"{FilenameWithExtension}": "6043e266-6550-400d-9e38-432b9ea9a67a",
"{Path}": "Lists/EURAppAccess/",
"{FullPath}": "Lists/EURAppAccess/1_.000",
"{HasAttachments}": false,
"{VersionNumber}": "1.0"
},
{
"@odata.etag": "\"1\"",
"ItemInternalId": "1",
"ID": 1,
"Title": "6043e266-6550-400d-9e38-432b9ea9a67a",
"MonitorMailbox": true,
"MailboxMonitorDuration": 30,
"AdditionalComments": "This is a test",
"PersonsToMonitor": "Josh Dale",
"Modified": "2023-02-28T20:06:42Z",
"Created": "2023-02-28T20:06:42Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|XXX",
"DisplayName": "Allison",
"Email": "XXX",
"Picture": "XXX",
"Department": "Information Technology Services",
"JobTitle": "Software Developer"
},
"Author#Claims": "i:0#.f|membership|XXX",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|XXX",
"DisplayName": "Allison",
"Email": "XXX",
"Picture": "XXX",
"Department": "Information Technology Services",
"JobTitle": "Software Developer"
},
"Editor#Claims": "i:0#.f|membership|XXX",
"{Identifier}": "Lists%252fEUROther%252f1_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "XXX",
"{Name}": "6043e266-6550-400d-9e38-432b9ea9a67a",
"{FilenameWithExtension}": "6043e266-6550-400d-9e38-432b9ea9a67a",
"{Path}": "Lists/EUROther/",
"{FullPath}": "Lists/EUROther/1_.000",
"{HasAttachments}": false,
"{VersionNumber}": "1.0"
}
]
This is the JSON with some elements obfuscated (XXX). The actual elements needed from this example would be DeleteKARE, DeleteGP, OtherApps, MonitorMailbox, MonitorMailboxDuration, PersonsToMonitor, AdditonalComments. It did seem like the Select works, but for some reason I cannot refer to those select elements in the email body.
