Unanswered

Concatenating strings from records

(0) Share

Report

Posted on by Jason Yeung

Hi,

I have a flow which imports contact information from Dynamics 365 to Salesforce. Street addresses in Dynamics 365 consists of 3 lines, but in Salesforce, there is only 1. So I would need to concatenate the 3 lines from CRM before inserting the contact to Salesforce.

I tried to use the "concat" expression, but either I get an expression error or it doesn't concatenate properly. I tried the following:

concat(items('Apply_to_each_record_from_CRM')?['address1_line1'],' ', items('Apply_to_each_record_from_CRM')?['address1_line2'],' ', items('Apply_to_each_record_from_CRM')?['address1_line3'] )

concat(triggerBody()?['address1_line1'],' ', triggerBody()?['address1_line2'],' ', triggerBody()?['address1_line3'] )

concat(parameters('address1_line1'),' ', parameters('address1_line2'),' ', parameters('address1_line3') )

concat(item()?['address1_line1'],' ', item()?['address1_line2'],' ', item()?['address1_line3'] )

concat(body('Apply_to_each_record_from_CRM')?['address1_line1'],' ', body('Apply_to_each_record_from_CRM')?['address1_line2'],' ', body('Apply_to_each_record_from_CRM')?['address1_line3'] )

Below is the screenshot of my Create record (to Salesforce). I wanted to use the expression in the Mailing Street field.

I was wondering what is the correct format of the expression should I use?

Sincerely,

Jason

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Paulie78 8,424 Moderator on at

Like (0)

Report
Copy link

Link copied!

I'm not sure of the expression you need, but you do have some syntax errors in your expressions above. To make it easier for yourself, why not simply place a compose action before "Create Record" action which contains the dynamic content from D365 without using any expressions, just put them all in to a compose, then you can use the output of that compose into your create record action.

Was this reply helpful? Yes No
Jason Yeung 53 on at

Like (0)

Report
Copy link

Link copied!

Hi @Paulie78 ,

Thanks for the information. Yeah, those lines I used had problems as I couldn't get the concat expression to function. I tried what you suggested, but it still had the concat expression.

I tried something different and it turns out I didn't need the concat expression at all. I found I could put more than 1 dynamic element in the field. If I put the 3 mailing street elements from the CRM in the mailing street element of Salesforce (and separate them by spaces), I was able to save all 3 lines in Salesforce.

Sincerely,

Jason

Was this reply helpful? Yes No
Paulie78 8,424 Moderator on at

Like (0)

Report
Copy link

Link copied!

That’s what I meant - to save you the hassle of writing the expressions. Just put them in. The extra compose was just for troubleshooting and visibility.

Was this reply helpful? Yes No