how to concat two values from lookup fields

[Anonymous]

Hi, I am trying to concat two lookup field values(Group number + dosimeter type) in name field, how should I do that, please advise. 

[abm]

Hi @Anonymous 

Check the run history of the flow after retrieving the record. See below here I am getting Get a rows by Id. Then look the run history to see the text something similar Display.V1.FormattedValue.  

outputs('Get_a_row_by_ID')?['body/_yourcolumnsnamehere_value@OData.Community.Display.V1.FormattedValue']

Add a compose and add the above as an expression. Do the same for the other column as well.

Finally you can use the output of both to use the concat() expression to get the text you want.

Thanks

[JPMHuls]

In the Dynamic content look for the lookup field reference ending with Value. For example for Country lookup to the Countries list, you should look for 'Country Value'. So in your case there should be a Dynamic Content reference for 'Group Value' and 'Dosimeter Type Value'.

[abm]

Hi @JPMHuls  & @Anonymous 

My answer was based on D365 lookup not SharePoint. 

Thanks

[uypham]

Hi @abm,

I tried to add two Composes for each field using your below format and return a flow checker. 

outputs('Get_a_row_by_ID')?['body/_yourcolumnsnamehere_value@OData.Community.Display.V1.FormattedValue']

[abm]

Hi @uypham 

Looks like you copied my expression. Here your trigger step you need to reference. You need to reference

@triggerOutputs()?['body/_yourcolumnsnamehere_value@OData.Community.Display.V1.FormattedValue']

You need to replace _yourcolumnnamehere with appropriate column name.

Thanks

[uypham]

Hi @abm ,

There is no error after changing two compose to @triggerOutputs()?

For the final step, I add an "Update a row" action and concat two compose field, but nothing is showing on the Name field.

[abm]

Hi @uypham 

Could you post a screenshot of your compose mapping expressions?

Thanks

[uypham]

Hi @abm 

Below is the compose expression:

- Event: triggerOutputs()?['body/_new_event_eventrole_value@OData.Community.Display.V1.FormattedValue']

- Role:   triggerOutputs()?['body/_new_eventrole_role_value@OData.Community.Display.V1.FormattedValue']

Name: concat(outputs('Event'),outputs('Role'))

[abm]

Hi @uypham 

Thanks for the screenshot. Did you checked the run history? Check each steps? Also check your email? I have sent you a request earlier.

Thanks