Power Platform Community Forum Thread Details

Hi All,

Have a relatively simple one that seems to be harder than I think it should be:

I've got a canvas app that accepts a "SurveyInstance" parameter, which I expect to match the unique identifier for my SurveyInstance CDS entity:

The general idea here is that I'd like to tie the survey instance to a specific employee and a specific survey. If the survey instance is not provided, I want to take the current user, and through a few lookups, find their existing record. I've run into the limitation on traversing multiple levels of many to one relationships several times in this effort, so I've created some intermediate variables to store values as I go through the lookup process. I'm able to get to the point where I have the GUID returned and stored in varSurveyInstanceID, however, next I'd like to create a variable containing that record so I can avoid having multiple nested lookups throughout the application.

I've tried a few approaches that seemed to work in other areas of the application, but for whatever reason in my OnStart rule I cannot lookup the record by ID:

Set(varSurveyInstance,

Lookup(SurveyInstances, SurveyInstance = varSurveyInstanceID));

Gives an error on comparing a record to a GUID

Set(varSurveyInstance,

Lookup(SurveyInstances, SurveyInstance.SurveyInstance = varSurveyInstanceID));

Gives an error on invalid use of the '.' operator

Set(varSurveyInstance,

Lookup(SurveyInstances, crad7_surveyinstanceid = varSurveyInstanceID));

Gives an error stating it's unable to find the column crad7_surveyinstanceid

Having a bit of a struggle believing looking up a record based on it's ID value is so difficult, is there perhaps something I missed in my table setup or in the syntax here?

Categories:

Microsoft Dataverse with Power Apps