Populating Multi Line Text Field With Information From Look Up Columns

[Jordan_Pearre]

Hello, 

I working to transition an internal order request tool from a Workflow to Power Automate. I am trying to have the accounting information populate in a multi-line text field (named Accounting Information) when a project is selected, but I don't know how to reference the look up field. How do I do this?

This is the beginning of the old workflow I am trying to recreate: 

Here are the names of the look up columns with the information : 

Thanks for your help!

[schuess3]

I would check out the Concat and Concatenate functions in Power Apps.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concatenate

[Jordan_Pearre]

I am not familiar with concat and concatenate. I will have to do some reading...

but how do I refer to the loop up columns in the function?

[KranthiTupakula]

@Jordan_Pearre 

Please look at this. 

https://powerusers.microsoft.com/t5/Building-Power-Apps/Combine-Concat-and-LookUp-in-PowerApps/td-p/...

_____________

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[schuess3]

This question might be more appropriate in the Power Automate Community Forums.

https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

[Jordan_Pearre]

Thanks for the heads up I will ask there!