Unanswered

Help with Filters

(0) Share

Report

Posted on by Paul764467875

Hi All, total Newb, so please be gentle... I have a gallery with 3 dropdowns. When drpStatus_1 is set to "All", I wanna see ALL records EXCEPT ones marked as complete.

The below filter works to an extent, but when I change drpStatus_1 to "Complete", I don't see any records at all.

Any Advice please?

Filter(

Site_Visits2,

Prisonpicker_1.Selected.'Site/Name' = Blank() Or PrisonName = Prisonpicker_1.Selected.'Site/Name',

ppPeoplePicker_1.Selected.'Site/Name' = Blank() Or Engineer = ppPeoplePicker_1.Selected.'Site/Name',

drpStatus_1.Selected.Value = "All" Or StatusX = drpStatus_1.Selected.Value, !Not(Completed in StatusX)

)

Categories:

General Questions

All responses (7)

Answers (0)

Paul764467875 12 on at

Like (0)

Report

Re: Help with Time Conversion

Afternoon all,

I am having problems with a formula, and wondered if anyone could assist?

txt_Tuesday.Text currently has a value of 01:00 which is SUPPOSED to be 1hr.

When I run the below formula, it sees 01:00 as a TIME, so when it minuses the 7 hours, it gives me 6pm the previous day. I want it to show as -6 hrs.

Time(Hour(txt_Tuesday.Text)-7,Minute(txt_Tuesday.Text),Second(txt_Tuesday.Text))

Thanks,

Paul.
Paul764467875 12 on at

Like (0)

Report

Re: Help with Filters

Sorry for the late reply - I am afraid none of the above formulas worked for me. Thanks anyway.
Rajkumar_M 3,631 Super User 2025 Season 1 on at

Like (0)

Report
Re: Help with Filters

Try this,

Filter(
Site_Visits2,
(
IsBlank(Prisonpicker_1.Selected.'Site/Name') || PrisonName = Prisonpicker_1.Selected.'Site/Name'
) &&
(
IsBlank(ppPeoplePicker_1.Selected.'Site/Name') || Engineer = ppPeoplePicker_1.Selected.'Site/Name'
) &&
(
(drpStatus_1.Selected.Value = "All" && StatusX <> "Complete") ||
(drpStatus_1.Selected.Value = "Complete" && StatusX = "Complete") ||
(drpStatus_1.Selected.Value <> "All" && drpStatus_1.Selected.Value <> "Complete" && StatusX = drpStatus_1.Selected.Value)
)
)
Paul764467875 12 on at

Like (0)

Report

Re: Help with Filters

Same result as the 1st one I'm afraid, no errors, but I still see Completed items in my List. I only wanna see Completed Items when I select Completed from the filter. default should be Pending and Required (without Completed)

Thanks,

Paul.
Rajkumar_M 3,631 Super User 2025 Season 1 on at

Like (0)

Report
Re: Help with Filters

Try this formula,

Filter(
Site_Visits2,
(
IsBlank(Prisonpicker_1.Selected.'Site/Name') Or PrisonName = Prisonpicker_1.Selected.'Site/Name'
) &&
(
IsBlank(ppPeoplePicker_1.Selected.'Site/Name') Or Engineer = ppPeoplePicker_1.Selected.'Site/Name'
) &&
(
drpStatus_1.Selected.Value = "All" And StatusX <> "Complete" Or
drpStatus_1.Selected.Value <> "All" And StatusX = drpStatus_1.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.
Paul764467875 12 on at

Like (0)

Report

Re: Help with Filters

Hi Rajkumar_404,

Thanks for the reply. Unfortunately the formula does not work - no errors, all filters work correctly, but I still see completed when this should be omitted unless selected in the dropdown.

Thanks.

Paul.
Rajkumar_M 3,631 Super User 2025 Season 1 on at

Like (0)

Report
Re: Help with Filters

Hi @Paul764467875

Try this formula,

Filter(
Site_Visits2,
(Prisonpicker_1.Selected.'Site/Name' = Blank() Or PrisonName = Prisonpicker_1.Selected.'Site/Name'),
(ppPeoplePicker_1.Selected.'Site/Name' = Blank() Or Engineer = ppPeoplePicker_1.Selected.'Site/Name'),
If(
drpStatus_1.Selected.Value = "All",
StatusX <> "Complete",
StatusX = drpStatus_1.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.