Weird Collection update behavior. Data not populating in collection.

I am trying to populate this collection based on the below formula. For some reason, a57_ceoflow comes back as blank whereas a57_ceo comes back with a displayname. Why would this not populate the a57_ceoflow column? Other fields are working fine, but for some weird reason a57_ceoflow comes back blank.

ClearCollect( collect_ExistingRecord,
Table({   
            a57_amd_doc_id: recordID.AMDDOCID,
            a57_taxapprover: First(Filter('Environment Variable Values', 'Schema Name' = "a57_env_var_tax_approvers").Value).Value,

            a57_businessunitcontroller: ComboBox_BusinessUnitController.Selected.'Display Name',
            a57_businessunitcontrollerflow: ComboBox_BusinessUnitController.Selected.Mail,

            a57_businessunitcontrollerrec: ComboBox_RecBusinessUnitController.Selected.'Display Name',
            a57_businessunitcontrollerrecflow: ComboBox_RecBusinessUnitController.Selected.Mail,

            a57_costcentermanager: ComboBox_CostCenterManager.Selected.'Display Name',
            a57_costcentermanagerflow: ComboBox_CostCenterManager.Selected.Mail,

            a57_costcentermanagerrec: ComboBox_RecCostCenterManager.Selected.'Display Name',
            a57_costcentermanagerrecflow: ComboBox_RecCostCenterManager.Selected.Mail,

            a57_director: ComboBox_Director.Selected.'Display Name',
            a57_directorflow: ComboBox_Director.Selected.Mail,

            a57_generalmanager: ComboBox_GeneralManager.Selected.'Display Name',
            a57_generalmanagerflow: ComboBox_GeneralManager.Selected.Mail,

            a57_businessop: ComboBox_BusinessOp.Selected.'Display Name',
            a57_businessopflow: ComboBox_BusinessOp.Selected.Mail,

            a57_ceo: ComboBox_CEO.Selected.'Display Name',
            a57_ceoflow: ComboBox_CEO.Selected.Mail,

            a57_scrapapprover:  recordID.'Created By'.'Primary Email',

            a57_assetaccountingreviewer: First(Filter('Environment Variable Values', 'Schema Name' = "a57_env_var_asset_acct_reviewers").Value).Value,
            a57_assetaccountingsignoff: First(Filter('Environment Variable Values', 'Schema Name' = "a57_env_var_asset_acct_signoff").Value).Value,
            a57_serviceaccount: First(Filter('Environment Variable Values', 'Schema Name' = "a57_env_var_service_acct").Value).Value
            
        }))

Categories:

Using Apps Using Formulas