getting error when using replace and coalesce together

(0) Share

Report

Posted on by anandm08

1,936 Super User 2024 Season 2

replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(outputs('mailTemplateCompose'), '{{EMPLOYEE_NAME}}', items('Apply_to_each')?['ToMeet/DisplayName']), '{{VISITOR_NAME}}', outputs('visitorMaster')?['body/Name']), '{{VISITOR_PHONE}}', outputs('visitorMaster')?['body/MobileNumber']), '{{VISITOR_COMPANY}}',coalesce(items('Apply_to_each')?['VisitorCompany'])), '{{VISITOR_PURPOSE}}', items('Apply_to_each')?['Purpose']), '{{MY_DEPARTMENT}}', items('Apply_to_each')?['Department']), '{{MY_FLOOR}}', items('Apply_to_each')?['Floor']), '{{VISITOR_LAPTOP}}', items('Apply_to_each')?['LaptopID']), '{{VISITOR_VEHICLE_NUMBER}}', items('Apply_to_each')?['VehcileNumber']), '{{VISITOR_ID_PROOF}}', outputs('idProof')?['body/GovtIDType/Value'])

this is my code and I don't know how what is wrong here it is working fine without coalesce but I have to use coalesce because of null value.

Categories:

General topics