Power Platform Community Forum Thread Details

I am trying to take data from an excel spreadsheet and copy it to a SharePoint List without writing any possible duplicates. Below is all the information that I think I can pull in here to try and get assistance. I am erroring out in the last step of my Workflow. Any help will be greatly appreciated.

List rows present in a table

PM_Workflow_List rows present in table.png
Raw Inputs

{
"host": {
"connectionReferenceName": "shared_excelonlinebusiness",
"operationId": "GetItems"
},
"parameters": {
"source": "groups/652bf5f1-4a4d-4662-937f-82d4d46ca799",
"drive": "b!rDUgmCjhR0iKtkQTlrccpfjTxtwswVlPlw4zCpMbke0It16-Sw4ZQ7C9n5NLlTz4",
"file": "01VCCF7EUVOVZ5OOFFU5C3UQACFYZWKL4Y",
"table": "{5A249D56-5312-4DAB-948D-BD1E8B7A4FB7}",
"dateTimeFormat": "ISO 8601"
}
}

Get items (Inside 'Apply to Each')

PM Workflow - Apply to each - Get Items.png

Raw inputs

{
"host": {
"connectionReferenceName": "shared_sharepointonline",
"operationId": "GetItems"
},
"parameters": {
"dataset": "https://bmwgroup.sharepoint.com/sites/TX-413Hall50ESASL",
"table": "8236daf6-fc89-46e7-9eaf-4fe19873d635",
"$filter": "Order_x0020_No_x002e_ eq '3805809'",
"view": "ae79eb71-e588-4d7b-a216-1d8addd63b11"
}
}

Raw outputs

{
"statusCode": 200,
"headers": {
"Transfer-Encoding": "chunked",
"Vary": "Origin,Accept-Encoding",
"X-SharePointHealthScore": "2",
"X-MS-SPConnector": "1",
"X-SP-SERVERSTATE": "ReadOnly=0",
"DATASERVICEVERSION": "3.0",
"SPClientServiceRequestDuration": "126",
"SPRequestGuid": "b99f8c6c-6120-437b-a639-7d371dc83ac7",
"request-id": "b99f8c6c-6120-437b-a639-7d371dc83ac7",
"MS-CV": "bIyfuSBhe0OmOX03Hcg6xw.0",
"Strict-Transport-Security": "max-age=31536000",
"X-FRAME-OPTIONS": "SAMEORIGIN",
"Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com;",
"MicrosoftSharePointTeamServices": "16.0.0.21715",
"X-Content-Type-Options": "nosniff",
"X-MS-InvokeApp": "1; RequireReadOnly",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"Cache-Control": "max-age=0, private",
"Date": "Fri, 01 Oct 2021 11:17:52 GMT",
"P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
"X-AspNet-Version": "4.0.30319",
"X-Powered-By": "ASP.NET",
"Content-Type": "application/json; charset=utf-8",
"Expires": "Thu, 16 Sep 2021 11:17:52 GMT",
"Last-Modified": "Fri, 01 Oct 2021 11:17:52 GMT",
"Content-Length": "833"
},
"body": {
"value": [
{
"@odata.etag": "\"1\"",
"ItemInternalId": "6",
"ID": 6,
"Title": "PM FOR EMS DOOR CARRIER #210",
"Order_x0020_No_x002e_": 3805809,
"OrderType": "PM01",
"StartDate": "2021-10-01",
"DueDate": "2021-10-31",
"SystemStatus": "REL NMAT PRC SETC",
"{Identifier}": "Lists%252fSAP%2bPM%2bPull%252f6_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "https://bmwgroup.sharepoint.com/sites/TX-413Hall50ESASL/_layouts/15/listform.aspx?PageType=4&ListId=8236daf6%2Dfc89%2D46e7%2D9eaf%2D4fe19873d635&ID=6&ContentTypeID=0x01006E7C846A87E71144AC0B8EB4E0A5735D00F39161D3BA8D7F4DA2182E3A66A26B49",
"{Name}": "PM FOR EMS DOOR CARRIER #210",
"{FilenameWithExtension}": "PM FOR EMS DOOR CARRIER #210",
"{Path}": "Lists/SAP PM Pull/",
"{FullPath}": "Lists/SAP PM Pull/6_.000",
"{HasAttachments}": false,
"{VersionNumber}": "1.0"
}
]
}
}

Condition

PM Workflow - Apply to each - Get Items - Condition - Create Item.png

Raw Inputs

{
"expressionResult": false
}

Condition (If No)
Create Item

Raw Inputs

{
"host": {
"connectionReferenceName": "shared_sharepointonline",
"operationId": "PostItem"
},
"parameters": {
"dataset": "https://bmwgroup.sharepoint.com/sites/TX-413Hall50ESASL",
"table": "8236daf6-fc89-46e7-9eaf-4fe19873d635",
"item/Title": "PM FOR EMS DOOR CARRIER #210",
"item/Order_x0020_No_x002e_": "3805809",
"item/OrderType": "PM01",
"item/StartDate": "44470",
"item/DueDate": "44500",
"item/SystemStatus": "REL NMAT PRC SETC"
}
}

PM_Workflow - Error.png

Error:
OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of
workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details:
Input parameter 'item/StartDate' is required to be of type 'String/date'.
The runtime value '"44470"' to be converted doesn't have the expected format 'String/date'.

Raw Inputs

Get items (Inside 'Apply to Each')
Raw inputs

Raw outputs