Power Platform Community Forum Thread Details

Hi,

I am trying to get a GUID from a related table in Dataverse and store in a collection.

In the example below, I am trying to get the GUID of the lookup column 'Competitive parameter Id'. However, when I enter it like below, it just returns a question mark. I guest this is because it's returning the record and not the GUID.

ClearCollect(
    colOppCompetitiveParams,
    ShowColumns(
        Filter(
            'Opportunity competitive parameters',
            'Opportunity Id'.Opportunity = GUID(opportunityGUID)
        ),'Competitive parameter Id' <== this is where I want to go a level deeper and get the GUID. 
    )
);

Intellisense is really not helping me here. I would expect I could use dot notation (just like I do in the filter above), and navigate to the primary column of the related record and get the GUID - but I haven't been able to do this.

I've also tried using logical names and schema names but I haven't found a working solution.

Any help is appreciated.

Categories:

Building Power Apps