Unanswered

Filter a table with a text AND date field

(0) Share

Report

Posted on by apadill4

Hi,

I am trying to filter a large data set using cascading dropdowns. The large data set is displayed in a table in powerapps, so that I am able to see all the columns.

I think the problem might be that the first dropdown is a text field and the second dropdown is a date field.

In the first dropdown I have "Distinct('RCF Processing Detailed PM Table',FacilityID_SystemName)" in the items field.

In the second dropdown I have "Distinct(Filter('RCF Processing Detailed PM Table',FacilityID_SystemName=Dropdown2.Selected.Result),ReviewDate)" in the items field.

I am able to see all the relevant dates in the second dropdown when I select an item from the first dropdown. The table also populates to show the relevant records when an item from the first dropdown is selected. The problem occurs when I select a date from the second dropdown. The table goes blank and I get an error.

Here is the formula I have in the items field for my table:

If(
IsBlank(Dropdown1_2.Selected.Result),
Filter(
'RCF Processing Detailed PM Table',
FacilityID_SystemName = ComboBox2_3.Selected.Result
),
!IsBlank(Dropdown1_2.Selected.Result),
Filter(
'RCF Processing Detailed PM Table',
FacilityID_SystemName = ComboBox2_3.Selected.Result,
ReviewDate = Dropdown1_2.Selected.Result
)
)

I have attached an image of the error I am getting. Please let me know if you need any more information from me.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@apadill4

Could there be a data type mismatch in this section of your code?

ReviewDate = Dropdown1_2.Selected.Result

I would suspect that ReviewDate is a Date type but maybe Dropdown1_2.Selected.Result is a Text type or something else.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
SeanHenderson 1,104 on at

Like
a
(1)

Report
Copy link

Link copied!

I think @mdevaney is right I just did a test and it works if you convert both types to text with Text(ReviewDate) = Text(Dropdown1_2.Selected.Result)

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @apadill4

Can you try to use the expression:

If(
IsBlank(Dropdown1_2.Selected.Result),
Filter(
'RCF Processing Detailed PM Table',
FacilityID_SystemName = ComboBox2_3.Selected.Result
),
Filter(
'RCF Processing Detailed PM Table',
FacilityID_SystemName = ComboBox2_3.Selected.Result,
ReviewDate = DateValue(Dropdown1_2.Selected.Result)
)
)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No