Power Query fill in template based on different tabs

I've had a business case related to fill in Excel templates from Share Point file with a lot of tabs and data.

Instead of copy / paste each line and switching between 2 tabs I linked templates and SharePoint into Power Query excel file to generate the template based on if I needed it from pages1 or pages2. It covered 80% jobs of manual interaction and only 20% left to check the accuracy and manually perform.

I created a folder with the following structure:

Main Folder:

- PowQ;

- template_pages1 (fill in data from Share Point from the tab pages1);

- template_pages2 (and fill in from the tab pages2);

To begin with I added 3 parameters to provide the following information: SharePoint path, Folder path (I think this can be also optimised if saved locally) and Drop down to choose if pages1 or pages2 data tab for preparing template and it linked to below function to pass data from parameters further into queries.

(filePathOrUrl as text, optional sheet as nullable text) as table =>

let
    FileBinary =
        if Text.StartsWith(filePathOrUrl, "http") then
            SharePoint.Files(filePathOrUrl, [ApiVersion=15]{0}[Content])
        else
            File.Contents(filePathOrUrl),


    WorkbookTables = Excel.Workbook(FileBinary, true),
    SheetTable = WorkbookTables{[Item=sheet, Kind="Sheet"]}[Data],
    PromotedHeaders = Table.PromoteHeaders(SheetTable, [PromoteAllScalars=true])


in
    PromotedHeaders

Download data for pages1 or pages2 depending on what values is selected in parameter

 Mode = parameterTab,

    TemplateFile = 
        if Mode = "pages1" then "template_pages1.xlsx"
        else if Mode = "pages2" then "template_pages2.xlsx"
        else error "No Tab Selected",

And use it whenever I need to

Source = PagesTemplates,
    Sheets = Table.SelectRows(
        Source,
        each[Kind] = "Sheet" 
            and (
                Text.StartsWith(Text.From([Item]), "pages1")
                or Text.StartsWith(Text.From([Item]), "pages2")
            )
    ),

    WithSheetName = Table.AddColumn(
        Sheets,
        "DataWithSheet",
        each
            let
                t = Record.Field(_, "Data"),
                name = Text.From(Record.Field(_, "Item"))
            in
                Table.AddColumn(
                    t,
                    "tab_name",
                    each name,
                    type text
                )
    ),

    Combined = Table.Combine(WithSheetName[DataWithSheet]),
    type_text = Table.TransformColumnTypes(Combined,{{"Column1", type text}, {"Column2", type text}}),

Also download SharePoint table once and reuse it in different places to obtain data only I need to work with

DataColumn = Table.SelectColumns(
        SharePoint,
            {"Column2"}
    )

I don't have regex method in Power Query, so I've used function to remove some lists from the text. Markers are added here manually, so I am not sure if it can be optimised for all list numeric cases and not to remove numbers somewhere in the text.

    t = if text = null then null else Text.TrimStart(text),

    markers = {
        "1. ", "2. ", "3. ", "4. ", "5. ", "6. ", "7. ", 
        "1)", "2)", "3)", "4)", "5)", "6)", "7)", 
        "i)", "ii)", "iii)",
        "i. ", "ii. ", "iii. ", 
        "I)", "II)", 
        "I. ", "II. ", 
        "•",
        "-"     
    },

    cleaned =
        List.Accumulate(
            markers,
            t,
            (state, m) =>
                if Text.StartsWith(state, m)
                then Text.Range(state, Text.Length(m))
                else state
        )

Also I don't find the method which delimits the text by lines for more than 1 column and as a result I have different row shifts due to additional line breaks in Share Point file.