Filter not working as expected

(0) Share

Report

Posted on by rickydg

107

Hi,

I'm building a multiscreen app and trying to filter a form using a text control from a previous form control within the app and a drop down box that is populated from a choices column in SharePoint. I can get LookUp to find records based on a a single criterion, but Filter just wont work.

Here's what I'm trying

Filter('Annual Reviews','Employee Number'=DataCardValue42.Text,'Review Period'=Dropdown2.Selected.Value)

Annual Reviews is the SP List

Employee Number is a text column in the SP list

Review Period is a choice column in the SP list

This works fine;

LookUp('Annual Reviews','Employee Number'=DataCardValue42.Text)

This does not;

LookUp('Annual Reviews','Review Period'=Dropdown2.Selected.Value)

Nor does;

LookUp('Annual Reviews','Review Period'=Dropdown2.Selected)

Replacing LookUp with Filter also errors.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Try this

Filter( 'Annual Reviews',
'Employee Number' = DataCardValue42.Text,
'Review Period'.Value = Dropdown2.Selected.Value )

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
rickydg 107 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately this doesn't work - gives 'Expected Record value' error.

Was this reply helpful? Yes No
Verified answer

rickydg 107 on at

Like
a
(0)

Report
Copy link

Link copied!
I don't think I was clear enough in my original post. My intention was to filter to a single result in the table to show in a form, therefore was placing this code in the Items property of the form control.
It appears that as the Filter was only returning a single result, it was not a table as such and causes an error.
The solution is to use a double LookUp;
LookUp('Annual Reviews','Review Period'.Value=Dropdown2.Selected.Value && 'Employee Number'=DataCardValue42.Text)
Hopefully this is useful to some.

Was this reply helpful? Yes No