Sharepoint list upload with no date error

[Nathan_Betters1 (Nathan Betters)]

Hello, I have an automation that uploads commission reports to a sharepoint list, this works fine, except sometimes theres no dates for the “effective date” column, and sharepoint kicks back an attempt to pass only " " if there is no date established. I also tried to pass a “nothing” function.

In theory I could create multiple if statements or switches to determine if any date fields are empty, but my list has many date columns so this is not a good practice. Is there a different way to pass an “empty” value to sharepoint (or not pass a value at all?)