Display Lookup field value in Gallery

(0) Share

Report

Posted on by Vandalus

I've seen some previous posts on this but still having trouble getting my head around the process.

Using data verse tables I have:

Employerss

Employees

On one of my screens, I have a gallery showing employees. One of the fields I wanted to display is the Employer, a lookup field in Employees table that points to the relevant Employer field in the Employerss table. These are linked in a One-to-Many relationship.

It does not display this and instead throws up the following error:

I've seen various potential work-arounds but still not been able to get anything to work.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report

After the dot name of the field that you want to display. I have created the same scenarion on my side. It works.

Was this reply helpful? Yes No
Vandalus 28 on at

Like (0)

Report

Thank you.

I think I tried this a while back with no luck so had mostly given up. Has there been an update this year that has since supported Many to one instances like this?

I am still having an issue in another table though.

In one gallery, I have it setup to filter based on the following:

'Gallery of Courses'.Selected.'Employees Courses (cr406_cr406_employees_courses_CourseAttended_cr)'

And it displays the company name correctly using the above as you stated: ThisItem.Employee.Employer.Employer

However in another screen, using the same code above but having the table filtered instead by a combo box, (Filter('Employees Courses', ComboBox1.Selected.Employer in Employee.Employer.Employer))

I get the following error instead again and it will not display the employers name.

Is there something obvious I am missing or does this not support filtering using combo boxes?

Was this reply helpful? Yes No