Insert text to a list dynamically from another list/table

[JustDavid]

I'd like to 2 things to my existing list.

1. Modify text in list
2. Append existing list Nth times depending on the values that's coming from another table/list (currently print screen showing as table)

From the print screen below, I'm showing you the table/list and end result

Tried a different method that can achive my end result via merging, however, it's very slow

String to AddCurrent List Desired Result

[SundarRaj]

Hello @JustDavid , here's another very quick way you can approach your query and add the approach to your arsenal. I'll share the snippet of the code used and output image for reference. Thanks

[AlienSx · Accepted solution]

let
    string_to_add = #table({"Data"}, {{"A"}, {"B"}, {"C"}}),
    list_to_add = List.Buffer(string_to_add[Data]),
    current_list = {"text | text | text", "sometext | sometext | sometext", "string | sometext | anothertext"}, 
    addition = List.TransformMany(
        current_list, 
        (x) => list_to_add, 
        (x, y) => y & " | " & x
    )
in
    addition

[jgeddes]

Here is one way it can be done...

let
    tableSource = 
    #table(
        {"Data"},
        {
            {"A"},
            {"B"},
            {"C"}
        }
    ),
    listSource = 
    {
        "text | text | text", 
        "sometext | sometext | sometext", 
        "string | sometext | anothertext"
    },
    table_to_list = 
    Table.ToList(table),
    table_row_count = 
    List.Count(table_to_list),
    modified_list = 
    List.Transform(
        List.Zip(
            {
                List.Repeat(table_to_list, table_row_count), 
                List.Repeat(list, table_row_count)
            }
        ), 
        each Text.Combine(_, " | ")
    )
in
    modified_list