ClearCollect(
colProcessData,
Filter(
'Assigen to',
Assign_To_Person.Value = "Assigned" &&
User().FullName = Value &&
(
!IsBlank(searchrequestid2.Text) && StartsWith(Request_ID, searchrequestid2.Text) ||
IsBlank(searchrequestid2.Text) && Request_ID <> ""
)
)
)
Code1
ClearCollect(colProcessData,Filter(CMD_NA_Trackers,
Text(Assign_To_Person)="Assigned" && User().FullName &&
( !IsBlank(searchrequestid2.Text) && StartsWith(Request_ID,searchrequestid2.Text)
|| IsBlank(searchrequestid2.Text) && Request_ID <>"")))
Code2
ClearCollect(colProcessData, Filter(CMD_NA_Trackers,
Text(Assign_To_Person) = "Assigned" && (!IsBlank(User().FullName) &&
Text(Assign_To_Person) = User().FullName) && ((!IsBlank(searchrequestid2.Text)
&& StartsWith(Request_ID, searchrequestid2.Text)) ||
(IsBlank(searchrequestid2.Text) && Request_ID <> ""))))