Accroding to some other posts it seems like I should be able to Patch null into an SQL DB. My problem is I can't find the command / syntax to do it? I tried
Patch(data,Filter(),{Column:Blank()})or
Patch(data,Filter(),{Column:null})or
Patch(data,Filter(),{Column:""})Blank() does nothing it seems, null is invalid and "" won't work since column is int not char. Can someone tell me syntax to put null in? My workaround right now is to put 0 in since my formulas won't match on that at least.