Forum Discussion
Connet Multi Line Notes from One List To Another
VeeExcelLearn As it is a single text column where you are adding multiple notes, it will not match automatically with another column (lookup).
My suggestion:
While appending notes to the string variable, append the name of user who added note as well like <name of the user>: <note> ....
For example:
Ibrahim: Note text added by Ibrahim
Samer: Note text added by SamerYou have to build your string variable in this way. You can take help from Microsoft documentation: Reference guide to workflow expression functions in Power Automate
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
VeeExcelLearn This is a limitation of SharePoint lookup columns. You cannot extend multiple lines of text columns using lookup settings. You can only extend below column types:
- Single line of text
- Number
- Date and Time
- Lookup (single value)
Documentation: Create list relationships by using lookup columns
For your scenario, follow below approach:
- Create a power automate flow on item creation/update in list 2
- Get the multiple lines of text column values for selected lookup columns using get items action in power automate
- Append all values to single string variable in power automate using expressions
- Update the multiple line of text column in list 2 using variable value and update item action.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Having a little bit of trouble. It started to do an apply to each. It doesn't like to variable. I probably messed something up for sure.
VeeExcelLearn Use "Initialize variable" action before Apply to each and use "Append to string variable" action inside Apply to each.
Use this variable to update column in destination list.
Are you trying to update single item or multiple items in destination list? Why are you using second Apply to each loop?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap When I try to add the notes it puts it like this and it doesn't see the initialize variable. Its forcing me to the apply to each.
What I am trying to do is is take multi-line notes from a multi line column to another multi line column.
Parent:
Child:
This is the Child List. Recruitment Notes placeholder for input from Parent.
The flow would look up notes for Faiz and Allie and bring in both notes from parent list:
These are the parent notes: Far right column.
