Solved: Filtering gives unexpected error

Okay, so I have this custom entity, called dh_project. I also created dh_assignments to assign employees to a project. Of course dh_project is a lookup in dh_assignments.

Now, in my Canvas App I’d like to be able to select a project that I’ve been assigned to, using a dropdown. I slightly filtered the dh_assignments table in collection colAssignments. The item property of this dropdown looks like this:

Filter(Projects, (Project in ShowColumns(colAssignments, "dh_project")))

I had to use the ShowColumns because using the “in” operator it expects a one column table.

Unfortunately it returns “Can’t convert this data type. Power Apps can’t convert this Guid to a DataEntity” on the Project. Seems pretty straight forward, but I don’t seem to get why the showcolumns/collection is considered to be a “DataEntity” while “dh_project” is nothing but a Guid.

Running up and down here, anyone have an idea what I’m doing wrong (chat gpt is running in circles, so no help there).
Thanks,
Jeroen

Categories:

General Questions