Power Platform Community Forum Thread Details

Hello,

I am using Dataverse tables 'Tasks' and 'Tasks Assignments'. In 'Task Assignment' table with 'Assigned To', 'Assigned Date' there is a lookup column 'Task ID" from 'Tasks' table.

In PowerApp, I am displaying all 'Tasks' in gallery. I want to show 'Assigned To'(in a label) column from 'Task Assignment'. My query gives following error.

My query is: LookUp('Task Assignment','Task ID'=ThisItem.''Task ID','Assigned To')

I understand, 'Task Id' is getting as Record. However, not sure how to filter it.

Thanks

Categories:

Building Power Apps

Sounds like you have something like this:

Again even if the two tables are not officially in a relationship the fact that Task Assignments has a lookup to Tasks means that there is an implied many to one between the two. In other words many task assignments can be associated with a single row in Tasks. So when you use lookup in a gallery that is based on the Tasks table your lookup will only show the first record in Task Assignments that is associated with it. If you are fine with this what you are looking for is:

LookUp('Task Assignment','Task ID'.'Task ID'=ThisItem.'Task ID').'Assigned To'

This should work if the case is that the 'Task Assignment' lookup column for 'Tasks' is named 'Task ID.' I am gathering that you named a lookup column after the primary name column of the Tasks table. As a result the contents of the column are a record and you have to dot crawl to that record's pertinent column.

Alternatively if you DON'T want to show only the first Assigned To value and instead want to display all the people assigned to task assignments related to that tasks you could do:

Concat(Filter('Task Assignment','Task ID'.'Task ID'=ThisItem.'Task ID'),'Assigned To',Char(10))

Which will give you every assignee with a line separator (or whatever separator you want). Hope that helps!