I have a SharePoint list for which i want a button to be visibility only when
1. all required fields are not empty
2. the approval status column value is equal to Draft.
I can get it to work when all of the required fields are not empty, I can get it to work when the the approval status column value is equal to Draft, but I cannot get it to work when all required fields are not empty AND the approval status column value is equal to Draft.
These are the two JSON formatting i tried unsuccessfully
1.
"visibility": "=if([$Lead_x0020_counsel] == '' || [$Approval_Type]=='' || [Bill_x0020_date] == '' || [Billing_x0020_period] == '' || [$Bill_x0020_Approval_x0020_Status] == 'Pending' || [$Bill_x0020_Approval_x0020_Status] == 'Interim Approved' || [$Bill_x0020_Approval_x0020_Status] == 'Final Approved' || [$Bill_x0020_Approval_x0020_Status] == 'Approved' || [$Bill_x0020_Approval_x0020_Status] == 'Fraction','hidden','visible')"
2.
"visibility": "=if([$Lead_x0020_counsel] == '' || [$Approval_Type]=='' || [Bill_x0020_date] == '' || [Billing_x0020_period] == '' || [$Bill_x0020_Approval_x0020_Status] != 'Draft','hidden','visible')"
Anything you can do to help would be greatly appreciated