@apeawakening ,
I was looking for something that would explain the non-refreshing, but you have a Delegable Filter - I have improved it a bit and mode the syntax consistent, but I do not believe the answer lies here.
SortByColumns(
Filter(
'Mobile SIM Request',
(
StartsWith(
EmployeeName.DisplayName,
Employeenametext_1.Text
) ||
IsBlank(Employeenametext_1.Text)
) &&
(
RequestStatus.Value = Requestdropdown_1.Selected.Value ||
IsBlank(Requestdropdown_1.Selected.Value)
) &&
(
'Created By'.Email = User().Email ||
EmployeeName.Email = User().Email
)
),
"Modified",
SortOrder.Descending
)
Your issue seems to be that you are relying on the refreshing / recalculating of a couple of things - firstly the Default of the checkbox in the gallery
Self.Text in Concat(
ThisItem.MobileOrSIM,
Value & ","
)
so my first question to simplify this is why bother with Concat (although again, this may not be the issue)
Self.Text in ThisItem.MobileOrSIM
and further is the Text property also a formula (so is Self.Text a static value or not)
You then have another formula on the Visible - which can be shortened to
MobileCheck.Value && vartabselect = 1
So depending on your response to the Text question, you have two or three chained calculations after the gallery refresh that need to do their job in order. My experience with this structure is that it is often inconsistent.
