How to use Disambiguation operator (@) on AddColumns value

[virakones]

Hi,

I have an issue in a galleries Items property, where I need to use a disambiguation operator to reference an id that is outside of a lookup scope but within that add columns formula.

The formula looks something like

AddColumns(
    //Ungroup below based on unique Job ids
    Ungroup(
        //add columns to our collection called Job Id, it is a lookup to that record
        AddColumns(
            colOrder,
            "Job Id",
            Filter('Dataverse Jobs','Order No.'=varOrder).'Dataverse Job'
            ),
            "Job Id"
        ),
        "Job Type",
        //Lookup the datasource, with the recently created Job Id above, to find additional details
        LookUp('Dataverse Jobs', 'Dataverse Job' = creaa_dataversejobid).JobType
)

In the above, I have a collection that I am adding a column called Job Id filtered by some values already in the collection.

I want to use this newly created Job Id to Add an additional column to get more details. The other criteria to get the Job Id originally is not exact enough to get the right details (Job Type, in this example) for this specific record. But referencing this Job Id returns an error in the monitor "The right side of the equal needs to be a constant value".

I believe this is because the id I need to reference is within that modified collection formula, but I don't have a specific source to reference with an @ because if I put the above into 2 collections and use the disambiguation operator (@) to reference a named source, it works as expected.

ClearCollect(
    colWithJobId,
    AddColumns(
        colOrder,
            "Job Id",
            Filter('Dataverse Jobs','Order No.'=varOrder).'Dataverse Job'
            ),
            "Job Id"
        )
);
ClearCollect(
    colWithJobType,
    AddColumns(
        colWithJobId,
        "Job Type",
        //notice the @ disambiguation below, with the collection name
        LookUp('Dataverse Jobs', 'Dataverse Job' = colWithJobId[@creaa_dataversejobid]).JobType
)

I want to avoid creating excessive collections, and would like to simply display the above in the Items property of the gallery. 

How to I use a disambiguation within an AddColumns formula where the source I need to disambiguate is only generated within that AddColumns? 

[virakones · Accepted solution]

So obviously as I hit enter on the post, I resolved my issue...

Using the As operator to change the datasource name on the fly helped solve my disambiguation issue. The below fixed formula:

AddColumns(
    //Ungroup below based on unique Job ids
    Ungroup(
        //add columns to our collection called Job Id, it is a lookup to that record
        AddColumns(
            colOrder,
            "Job Id",
            Filter('Dataverse Jobs','Order No.'=varOrder).'Dataverse Job'
            ),
            "Job Id"
        //Here I am using the 'As' operator to renamed this modifed collection
        ) As UngroupedIds,
        "Job Type",
        //Now I can properly reference the right id to continue with the lookup
        LookUp('Dataverse Jobs', 'Dataverse Job' = UngroupedIds[@creaa_dataversejobid]).JobType
)