Gallery SortByColumns, Addcolumn from related Dataverse table

[AnthonyDo]

Hello everyone,

I would like to sort my gallery with table source: Trainees by the column "cref8_remainingbudget" from the table TraineeYearlyBudget. I made a lookup field:

So i tried researching and adding code to my sort function but it is not behaving how it should behave:

!IsBlank(varSortByBudget),
        SortByColumns(
            AddColumns(
                Trainees,
                "cref8_remainingbudget",
                traineeyearlybudget.cref8_remainingbudget

            ),
            "cref8_remainingbudget",
            If(
                varSortByBudget,
                Ascending,
                Descending
            )
        )

What am i doing wrong here?

thanks in advance,

Anthony

[shavora]

I believe the name within quotations is just a random name you give the column you are adding. It is not actually referencing anything in this step: AddColumns(Table, "Name of your choice", LookUpTableName)