Yes - you are missing a closing bracket - the
Filter needs to be indented one more step. You have also defined
_Limit and then not used it (I have added as per previous post)
With(
{
_prefiltered_data:
With(
{
_Limit:
DateAdd(
Today(),
-3,
TimeUnit.Months
)
},
Filter(
'eCom Intake',
Status.Value = "Resolved",
Len(Dropdown4.Selected.Value) = 0 || LOB.Value = Dropdown4.Selected.Value,
Len(Dropdown4_1.Selected.Value) = 0 || 'Issue Type'.Value = Dropdown4_1.Selected.Value,
!Checkbox1.Value || 'Created By'.Email = User().Email,
Created >= _Limit
)
)
},
With(
{
_transformed_data:
AddColumns(
_prefiltered_data,
TextID,
Text(ID),
CreatedByDisplayName,
'Created By'.DisplayName,
AssignedToDisplayName,
AssignedTo.DisplayName,
ChoiceString,
'NeedMoreInfoOPS - Current'.Value
)
},
With(
{
_filtered_by_names:
Search(
_transformed_data,
SearchInput_tb.Text,
Title,
CreatedByDisplayName,
AssignedToDisplayName
),
_filtered_by_id:
Search(
_transformed_data,
SearchInput_tb.Text,
TextID
)
},
With(
{
_finaltable:
If(
!SearchID_tg.Checked && !SearchRequestor_tg.Checked,
_filtered_by_names,
_filtered_by_id
)
},
SortByColumns(
_finaltable,
"ChoiceString",
SortOrder.Descending,
"ID",
SortOrder.Descending
)
)
)
)
)
Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
