Power Platform Community Forum Thread Details

Date/Time value that is empty is not being detected by the expression empty().

I am trying to update and append a table from Excel to a SharePoint list using Power Automate. During this process, I am receiving an error: Input parameter is required to be of type 'String/date.' The runtime value " " to be converted does not have the expected format 'String/date.'

Therefore, I have tried to solve this issue in a variety of ways, however none seem to be working.

Replacing empty dates with null.
1. if( empty(items('Apply_to_each')?['Pick-Up Date']), null, items('Apply_to_each')?['Pick-Up Date']) - Did not work.
2. if( equals(items('Apply_to_each')?['Pick-Up Date'], ''), null, items('Apply_to_each')?['Pick-Up Date']) - Did not work.
3. if( equals(items('Apply_to_each')?['Pick-Up Date'], ' '), null, items('Apply_to_each')?['Pick-Up Date']) - Did not work.
I have tried to troubleshoot the empty() and equals() expressions by trying to see if these come out as true in a compose action.
I keep getting that the outcome is false. The outcome is false even when the input is empty.