Filter Logic

(0) Share

Report

Posted on by RJF61

1,265

I have a Power App that I want to Filter. When the Power App is opened I want the following...

1. When first opened, see All records (no Filter applied) OR

2. Apply a Filter where only records with a specific Status are displayed (includes All AssignedTo and DaysOld) OR

3. Apply a Filter where only records AssignedTo a specific individual are displayed (includes All Status and DaysOld) OR

4. Apply a Filter where only records that are > a certain number of DaysOld (includes All Status and All AssignedTo)

My issue appears to be relative to the Drop Down for the AssignedTo. AssignedTo is from a SP List Choice Column with values similar to (for the SP default value, I have left the field blank)...

---

Adams, John

Burns, Robert

Smith, John

How do I make the default value of the Drop Down (AssignTo) Blank or No value? I believe this would be required to see all records solely based on the Slider DaysOld selection. I have set the Drop Down default to "" with no success.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@RJF61

Sorry I didn't get a chance to respond yet to our last interactive post...

So, you had this formula there:

Filter('Safety Good Catch Items', Status.Value = Radio2.Selected.Value || IsBlank(Radio2.Selected.Value) || AssignedTo.Value = DrpdwnAssign.Selected.Result || DrpdwnAssign.Selected.Result="---" )

Where does that fit into where you are now and what problem you are having?

Was this reply helpful? Yes No
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes Thanks for the response. Currently I have...
Filter('Safety Good Catch Items',
Status.Value = Radio2.Selected.Value ||
(IsBlank(Radio2.Selected.Value) && AssignedTo.Value = DrpdwnAssign.Selected.Result) ||
(IsBlank(Radio2.Selected.Value) && DrpdwnAssign.Selected.Result="---" && DaysOld >= DaysOldSlide) ||
(IsBlank(Radio2.Selected.Value) && DrpdwnAssign.Selected.Result="---")
)

The results I see are as follows...
For "Status.Value = Radio2.Selected.Value" I see the expected results
For "(IsBlank(Radio2.Selected.Value) && AssignedTo.Value = DrpdwnAssign.Selected.Result)" I see the expected results with names; however, for "---" I see all records. I have the Power Apps DrpdwnAssign Data default = ""
For "(IsBlank(Radio2.Selected.Value) && DrpdwnAssign.Selected.Result="---" && DaysOld >= DaysOldSlide)" I see all records regardless of slide setting (location)

Thanks

Was this reply helpful? Yes No