Dear Power Apps Community,
I think I have a quite common issue, I already searched for answers (also found a few) but somehow I am still completely stuck and would appreciate your help. I am trying to access the QuestionCategory from the DbSaResponse table.
I have the following quite straightforward DataVerse Schema:
I have a Gallery with my DbSaResponses as main source. I want to Display the Question, the Question Category and the different Answer Choices per Question which looks right now like this:
As you can see I am able to access the QuestionText and Type simple via ThisItem.SpotAsessmentQuestionID.questiontext
For the AnswerChoices I manged to build a filter:
Filter(DbSaQuestionAnswersChoices, SpotAsessmentQuestionID.SpotAsessmentQuestionID = ThisItem.SpotAsessmentQuestionID.cr100_spotasessmentquestionid).QuestionAnswerPossibility
However I am somehow unable to create a Filter or LookUp function to access the CategoryName since ThisItem.SpotAsessmentQuestionID.QuestionCategory.CategoryName is not supported and every time to try to build a LookUpFunction I get Error Messages such as: These types cant be compared: Guid, Record or Table,Record:
LookUp(DbSaQuestionCategories, DbSaQuestionCategories.CategoryName = ThisItem.SpotAsessmentQuestionID.QuestionCategory)
Is there an Issue the way I set up my Data, or am I just simply missing something in my Function?
Thank you in advance.
