I have a SharePoint list with several couple of DateTime columns. I am using a Power Automate flow to perform some actions and at a certain point I need to zero out the values in those columns, StartDateofNextReview and DueDateofNextReview. I find I can't do it. I've tried setting the field to "null" and also empty strings. I'm not sure what else to try.
Here's the code snippet
"inputs": {
"parameters": {
"dataset": "https://secoit.sharepoint.com/teams/OITEnterpriseArchitecture",
"table": "a6c22f5b-e010-4abb-b6a8-437beafeec7b",
"id": "@items('For_each')?['ID']",
"item/Title": "@items('For_each')?['Title']",
"item/FileToBeReviewed": "@items('For_each')?['FileToBeReviewed']",
"item/FrequencyofReview/Value": "@items('For_each')?['FrequencyofReview']?['Value']",
"item/DateofLastReview": "@items('For_each')?['DateofLastReview']",
"item/StartDateofNextReview": "@{null}",
"item/DueDateofNextReview": "@{null}",
"item/ReviewTaskURL": "https://tasks.office.com/nosuchagency.gov/Home/Task@{outputs('Create_Review_Task')?['body/id']}",
"item/ReviewInProgress": true,
"item/ReviewTaskID": "@outputs('Create_Review_Task')?['body/id']"
}When I set them to null, I get this error:
OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_Review_Item' of
type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/DatetoStartNextReview' is required to be
of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.
When I leave those fields blank, the fields populate with existing values.
fwiw here is the screen shot from power automate that's producing the error
I'm new to microsoft development, so if there are nuances here, I have no idea what they are.
