I have a custom object (Customer Documentation Checklist) which is the detail in a Master-Detail Relationship with the Opportunity (Opportunity__c). I have created a process-launched flow which is intended to find the CDC record where the Most_Recent_CDC__c record is TRUE. Most_Recent_CDC__c is a formula field checkbox which compares the Created Date on the CDC with a Rollup Summary field on the Opportunity that pulls in the MAX Created Date on all related CDC's. If they match, the result is TRUE, otherwise the result is FALSE. I want to pull the vallue from the Master_Approval_Status__c field (on the CDC) from that CDC into a text field on the Opportunity. If the variable is NULL it places that in the text field. So far, "NULL" is the only value I get regardless if whether CDC with a Most_Recent_CDC__c of TRUE exists or not.
The {!OpportunityID.Id
} is pulled in by the Process from the triggering Opportunity. {!MostRecentCDCAppStat} is an Sobject Variable. Master_Approval_Status__c is a formula text field. I appreciate your assistance.
