Answered

Filter Gallery on Combobox Lookup Field

(0) Share

Report

Posted on by ttaylor4125

I'm looking for some advice. I have two SharePoint lists: Employees and WeeklyReports.

I want an employee to choose their name (ComboBox1) and then be able to see all the reports they have submitted. The gallery would only show dates from the ReportDate column from WeeklyReports sharepoint list. (ReportDate is date and time column; default day set to "today")

In Employees list, I have a text column named "TeamMember."

In my WeeklyReports I have a lookup field that gets the TeamMember column from Employees sharepoint list.

Everything is working great except when I try to filter data in a new gallery. I have a Combobox1 with Items=Sort('Employees',TeamMember). Works great - I can see all the employees.

On gallery - Items=Filter('WeeklyUpdates',ComboBox1.Selected.Name). There are no errors. However, no information is being populated.

I hope all this makes sense. Thank you!!

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Filter('WeeklyUpdates',ColumName = ComboBox1.Selected.Name)
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ttaylor4125,

Have you solved your problem?

Do you want to filter the LookUp column based on a ComboBox selected?

I think there is something syntax wrong with your Filter() function, you should assign the aimed LookUp column name within the Filter().

Modify your formula as below:

Filter('WeeklyUpdates',LookUpColumnName.Value=ComboBox1.Selected.TeamMember)

Note that you should add ".Value" when you refer to the LookUp column.