Hi,
I'm experiencing inconsistency in a gallery filter results, really frustrating.
in the picture above you can see set of tabs and filters that all work perfectly fine, except one combination!!
if the tab selected is Opened and the My Items checkbox is true, the gallery returns blank results, for any other tab the My Item filter works as expected.
each tab should reflect a subset of list of items according to specific statuses and other criteria. the My Items checkbox is obviously to filter the items assigned to me.
i know that the results shouldn't be empty, but it is still the case.
there is no formula on the Check/ Uncheck properties.
the formula on the open tab:
Set(varItemContext,"Opened");
gallery items property (i highlighted the relevant part):
If(!_varAll,
Search(
SortByColumns(
Filter(
colSelectedColumns,
If(
varItemContext="Review",Status.Value="Unwatched"&&IsEmpty(Assignedto)||RecheckedIndicator||Preassigned,
varItemContext="Opened",Status.Value="Unwatched"||Status.Value="In progress"||Status.Value="Consider communication"||Status.Value="On-Hold"||Status.Value="Ready for deployment"||Status.Value="Recheck",
varItemContext="Start",Text(Rollout_Start_Date, DateTimeFormat.ShortDate) = Text(_dateSelected, DateTimeFormat.ShortDate)||Text(Rollout_End_Date, DateTimeFormat.ShortDate) = Text(_dateSelected, DateTimeFormat.ShortDate),
varItemContext="Comm",Status.Value="Communicated"||Status.Value="Consider communication",
varItemContext="All",!IsBlankOrError(ComboboxStatus),
varItemContext="Active",
If(
_minDate=_firstDayOfMonth,
Active=true,
Rollout_Start_Date<=_lastDayOfMonth,
Rollout_End_Date>=_firstDayOfMonth,
Rollout_Start_Date>=_firstDayOfMonth&&Rollout_Start_Date<=_lastDayOfMonth,
Rollout_End_Date>=_firstDayOfMonth
)
),
!Checkbox1.Value || varCurrentUserUPN in ChainedUPNs, //||varCurrentUserUPN in ChainedManagerUPNs,
!ToggleMajor.Value||MajorUpdate = ToggleMajor.Value,
!ToggleUser.Value||'User Impact'= ToggleUser.Value,
!ToggleMgt.Value||IT_MNG_Approval= ToggleMgt.Value,
!ToggleE5.Value||E5_License= ToggleE5.Value,
!ToggleBlock.Value||Blocked= ToggleBlock.Value,
IsBlankOrError(ComboboxService.SelectedItems)||IsEmpty(ComboboxService.SelectedItems) ||Service.Value in ComboboxService.SelectedItems.Value,
IsBlankOrError(ComboboxUnit.SelectedItems)||IsEmpty(ComboboxUnit.SelectedItems) ||'Group owner'.Value in ComboboxUnit.SelectedItems.Value,
IsBlankOrError(ComboboxPriority.SelectedItems)||IsEmpty(ComboboxPriority.SelectedItems) ||Priority.Value in ComboboxPriority.SelectedItems.Value,
IsBlankOrError(ComboboxStatus.SelectedItems)||IsEmpty(ComboboxStatus.SelectedItems) ||Status.Value in ComboboxStatus.SelectedItems.Value
),
"ID",
SortOrder.Descending),
SearchInput1.Text,
ID_Text,
'True-Title',
MC_Text,
Description,
'Comments?'
),
Search(
SortByColumns(
Filter(
colSelectedColumnsArchived,
varItemContext="All",!IsBlankOrError(ComboboxStatus),
!Checkbox1.Value || varCurrentUserUPN in ChainedUPNs,
!ToggleMajor.Value||MajorUpdate = ToggleMajor.Value,
!ToggleUser.Value||User_x0020_Impact= ToggleUser.Value,
!ToggleMgt.Value||IT_MNG_Approval= ToggleMgt.Value,
!ToggleE5.Value||E5_License= ToggleE5.Value,
!ToggleBlock.Value||Blocked= ToggleBlock.Value,
IsBlankOrError(ComboboxService.SelectedItems)||IsEmpty(ComboboxService.SelectedItems) ||O365_x0020_Service.Value in ComboboxService.SelectedItems.Value,
IsBlankOrError(ComboboxUnit.SelectedItems)||IsEmpty(ComboboxUnit.SelectedItems) ||Groupowner.Value in ComboboxUnit.SelectedItems.Value,
IsBlankOrError(ComboboxPriority.SelectedItems)||IsEmpty(ComboboxPriority.SelectedItems) ||Priority.Value in ComboboxPriority.SelectedItems.Value,
IsBlankOrError(ComboboxStatus.SelectedItems)||IsEmpty(ComboboxStatus.SelectedItems) ||Status.Value in ComboboxStatus.SelectedItems.Value
),
"ID",
SortOrder.Descending),
SearchInput1.Text,
ID_Text,
True_x002d_Title,
MC_Text,
Description,
Cooments_x003f_
)
)
will appreciate any direction.
thanks,
Eyal
