Announcements
Good morning all. I am having a bit of hard time trying to combine two sharepoint collections into one. My first collection is our main data table where we store user input data. The second collection is a reference table with a list of milestones that need to be completed. How can I combine this two collections into one like the image below. Any help would be greatly appreciated
@tshelly
If there is a common field in both lists, you can use it in a LookUp() function to add the columns from one list to the other. ie.
AddColumns( List1, "columnfromlist2",Lookup( list2,commoncolumn=list1commoncolumn ).somecolumnfromlist2 )
The column from the data table list corresponds to milestones in the milstone list. so for example the hck column in the data table list is tied to the hck field in the milstone list.
I should clarify a bit more. Each record in the main data table has a group of columns that correspond to several milestones. In the main data table you will see hck,hck-mod,hck-comp,hck-note (see image). Those four columns tie to the milestone list by the list-calc column. The next grouping of columns follow the same structure and are then tied to the next milestone in the milestone list
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 494
WarrenBelz 352 Most Valuable Professional
11manish 323
