Forum Discussion
Connet Multi Line Notes from One List To Another
I have 2 lists, I would like to connect the notes from one lists to another list. The source list has a list of names with corresponding notes. The second list has column which is connected to this list and is selectin the names from this list. I would like to have some sort of a lookup that would take the notes from list one and copy it into list 2. The problem is that list 2 has field that can select multiple names in this column so its not an easy lookup.
List 1:
List 2: I have to blind the names but you can see that there can be 2 names in this Update columns. So it would have to look up the 2 names in this columns and bring in the notes from list one. The problem is how do I append the notes related to these 2 people and bring it to one column. Please help. First I would like to copy the notes and then as we add items I want to have this done automatically
Maybe if someone can get me started I can slowly see if I can get it to work.
Please and thank you.
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.
10 Replies
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.
