Filter Gallery on ComboBox Lookup Field and Dropdown List

(0) Share

Report

Posted on by ttaylor4125

I have two Sharepoint Lists:

1. Employees - text column (Name) that lists all employees

2. Weekly Updates - has a lookup column (NameLookup) that gets information from the Name column in the Employees list

I have a ComboBox so employees can choose their name from the Employees list. I also have a dropdown box so once an employee chooses their name from the ComboBox, they can select a date from the dropdown based on the Submission Date column from the Weekly Updates list. Here's what I have:

ComboBox

Items = Sort('Employees',Name)

DropDown

Items = Sort('Weekly Updates', 'Submission Date')

Gallery Filter

I've tried several scenarios and nothing has worked. What should this look like that will populate the gallery fields - which are four columns of multiline text from the Weekly Updates (column names Accomplishments, Projects, Problems, Inform) based on the Submission Date from the Weekly Updates chosen in the dropdown?

Thank you!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (1)

mgrachii 206 on at

Like (0)

Report
Copy link

Link copied!

hi there, is submission date field a "date" fieldor a text field?

Was this reply helpful? Yes No
ttaylor4125 83 on at

Like (0)

Report
Copy link

Link copied!

It's a date field. Sorry I didn't clarify earlier.

Was this reply helpful? Yes No
mgrachii 206 on at

Like (0)

Report
Copy link

Link copied!

Have you considered using a date picker control instead of a dropdown?

Was this reply helpful? Yes No
ttaylor4125 83 on at

Like (0)

Report
Copy link

Link copied!

I was using the dropdown to show the employees all the reports they submitted by date so they could choose which past report they wanted to view.

Was this reply helpful? Yes No
mgrachii 206 on at

Like (0)

Report
Copy link

Link copied!

got it, have you tried something like this:

Filter('Referrals Data',[ColumnName] = DateValue({DropdownControlName}.SelectedText.Value) )

Was this reply helpful? Yes No
ttaylor4125 83 on at

Like (0)

Report
Copy link

Link copied!

Sorry, that didn't work.

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@mgrachii is on the right track. Also please specify what "does not work" (error/no result/wrong result).

Filter( AddColumns( 'Weekly Updates', "EmpName", NameLookup.Value ), 'Submission Date' = DateValue(DropdownDateName.Selected.'Submission Date') && EmpName = DropDownEmployeeName.Selected.Name )

You may have to replace some of the names if they are not exactly what you have.
Two pieces of advice - throw away the Lookup column - you do not need them in Power Apps (this blog of mine may be useful to you) and Name is a bad title for a field.
Also none of that is Delegable and will not work on lists over your (500-2,000) Delegation limit.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
ttaylor4125 83 on at

Like (0)

Report
Copy link

Link copied!
Thank you! Your blog was VERY helpful. I couldn't figure out a better way with hundreds of employees.

I just tried your suggestion on for filtering the gallery. It doesn't like the '.Submission Date' after selected: "...Selected.'Submission Date". Do you know why?
'Submission Date' = DateValue(DropdownDateName.Selected.'Submission Date') && EmpName = DropDownEmployeeName.Selected.Name

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@ttaylor4125 ,

If the Items of the drop-down are

Sort('Weekly Updates', 'Submission Date')

then that code should be valid - can you check this? Also what format does the date display in?

Was this reply helpful? Yes No
ttaylor4125 83 on at

Like (0)

Report
Copy link

Link copied!

Items is Sort('Weekly Updates', 'Submission Date'). And the list column is a Date and Time, Date Only, Standard Format, Default Value is Today's date.

Thanks for getting back with me so quickly and for all your help. I really appreciate it.

Was this reply helpful? Yes No