Unanswered

reset date filter disables all records

(0) Share

Report

Posted on by vannemki71290

Hi,

I have a power app where i get data from a sharepoint table. there are filters on the app like BU,CP and date. in the gallery when i open the powerapp i see all the BU and CP lists irrespective of the date selected all the records are being displayed. but when i select certain date it filters out the records for that date which is good. I created a reset button which resets to current day and when I click the button it resets the date filter to today's date and all the records from previous date vanish, I want to see all the records irrespective of the reset button.

please suggest a method for this issue.

thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @vannemki71290

Can you post the code in the Items property of your Gallery if not sensitive?

Was this reply helpful? Yes No
vannemki71290 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Search(
If(
// this is for all Business Units and all Counterparties
ddBusinessUnit_2.Selected.Value = "All" && ddCounterparty_2.Selected.Value = "All",
Filter(
'Scorecard Comments 2',
YourDateColumn = ddDate.Selected.Value
),
// this is for all Business Units and selected Counterparty
If(
ddBusinessUnit_2.Selected.Value = "All" && ddCounterparty_2.Selected.Value <> "All",
Filter(
'Scorecard Comments 2',
Counterparty = ddCounterparty_2.Selected.Value &&
YourDateColumn = ddDate.Selected.Value
),
// this is for selected Business Units and all Counterparties
If(
ddBusinessUnit_2.Selected.Value <> "All" && ddCounterparty_2.Selected.Value = "All",
Filter(
'Scorecard Comments 2',
'Business Unit' = ddBusinessUnit_2.Selected.Value &&
YourDateColumn = ddDate.Selected.Value
),
// this is for selected Business Units and selected Counterparty
If(
ddBusinessUnit_2.Selected.Value <> "All" && ddCounterparty_2.Selected.Value <> "All",
Filter(
'Scorecard Comments 2',
'Business Unit' = ddBusinessUnit_2.Selected.Value &&
Counterparty = ddCounterparty_2.Selected.Value &&
YourDateColumn = ddDate.Selected.Value
)
)
)
)
),
SearchInput1_3.Text,
"BusinessUnit",
"Comment",
"Counterparty"
)

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

So when you click on the Reset Button to reset the date, I'm assuming that the only code behind the Button is Reset(DateControl)?

You said when you open the app everything is displayed regardless of what is in the date field.
- Is there anything in the date field when you open the app?
- You want the app to filter by the date selected (you mentioned that it's filtering correctly), but when you hit the reset button and the date returns to Today(), there are no results in the gallery.
What if there is no data in the app that match the criteria of Today()?

I need a bit more info on what you expect the app to do when you reset the date to Today() because the date control is considered as part of the query to filter the gallery.

(PS - I'm going to have some dinner but will be back later)

Was this reply helpful? Yes No