Good Morning
My flow works on a dataset from a filtered SP list. Ideally, I would filter out anything that doesn't contain a Calibration Due date but that keeps failing. Looking at my dataset, some of the items don't show the column. Why would that be??
The original source for my data is an external database which I download via api to Sharepoint. Assets are assigned a category and also a field set which includes the calibration dates (so not all items will have a calibration date).
But they all end up in the same list so that list should have an empty Calibration Due date column when it doesn't come through.
This is a set that's causing me issues:
"@odata.etag": "\"1943\"",
"ItemInternalId": "631",
"ID": 631,
"Title": "CT dollies new - Single source - Set 1",
"SnipeAsset": "00631",
"Status": "1 Ready to Deploy",
"SerialNumber": "2441-03",
"CalibrationFrequencyMonth": 12,
"DefaultLocation": "Warehouse - Auckland",
"Owner": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|xxx@xxx.com",
"DisplayName": "xxx",
"Email": "xxx@siemens-healthineers.com",
"JobTitle": "Project Manager External"
},
"Owner#Claims": "i:0#.f|membership|xxx@siemens-healthineers.com",
"ToolCategory": "Project Tools",
"CalibrationFlag": false,
"RiskAssessmentFlag": false,
"SnipeID": "632",
"SnipeStatusID": "2",
"SnipeStatusType": "deployable",
"calStatusType": "Active",
"{Identifier}": "Lists%252fNZTools%252f631_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Name}": "CT dollies new - Single source - Set 1",
"{FilenameWithExtension}": "CT dollies new - Single source - Set 1",
"{Path}": "Lists/NZTools/",
"{FullPath}": "Lists/NZTools/631_.000",
"{HasAttachments}": false,
"{VersionNumber}": "1943.0"
},
Entry with Calibration Due date:
"@odata.etag": "\"1841\"",
"ItemInternalId": "635",
"ID": 635,
"Title": "Electrical Safety Analyser Fluke ESA612",
"SnipeAsset": "00635",
"Status": "1 Ready to Deploy",
"SerialNumber": "5606625",
"SAPEquipmentNumber": "8900000009988",
"DateCalibrated": "2023-08-15",
"CalibrationDue": "2024-08-15",
"CalibrationFrequencyMonth": 12,
"DefaultLocation": "Warehouse - Auckland",
"Owner": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|xxx@xxx.com",
"DisplayName": "xxx",
"Email": "xxx@xxx.com",
"JobTitle": "Service Engineer"
},
"ToolCategory": "Calibrated Tools",
"CalibrationFlag": false,
"RiskAssessmentFlag": false,
"SnipeID": "636",
"SnipeStatusID": "2",
"SnipeStatusType": "deployable",
"calStatusType": "Active",
"{Identifier}": "Lists%252fNZTools%252f635_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Name}": "Electrical Safety Analyser Fluke ESA612",
"{FilenameWithExtension}": "Electrical Safety Analyser Fluke ESA612",
"{Path}": "Lists/NZTools/",
"{FullPath}": "Lists/NZTools/635_.000",
"{HasAttachments}": false,
"{VersionNumber}": "1841.0"
},
I don't understand why the CalibrationDue column doesn't come through as an empty column.
I need to filter items that have a Calibration Due date but if that info doesn't exist for some of the entries, how can I achieve that?
Any ideas?
Thanks,
Christine