cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Populating Multi Line Text Field With Information From Look Up Columns

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: 

PORT WORKFLOW.JPG

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

 

PORT LOOK UP COLUMNS.JPG

 

Thanks for your help!

5 REPLIES 5
Kudo Collector
Kudo Collector

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

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?

@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.

Kudo Collector
Kudo Collector

Thanks for the heads up I will ask there!

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (69,110)