Hi @v-mingkz-msft,
I was able to fix the code to make it work as I intended, but now I'm having another problem, where I want to use the Filter() function, to be able to search for certain characters in a String, but I don't want to use the function search because of the "delegation warning".
In the SharePoint list, I have a column named Company_To, and I have been able to Split() the Company_To word by word into a collection that contains all the original data in the SharePoint list. However, this has produced a lot of duplicate data in the list, and I want it to show only a single data of the duplicate, but still be able to to search for the correct data in the collection list
SortByColumns(
Filter(
CourierApp,
//Delete status
('Status (Status0)'.Value = 'on-off_1'.Selected.Value Or 'on-off_1'.Selected.Value = "Status"),
//Search box
StartsWith(
CCV,
TextInput1_1.Text
) || StartsWith(
Content,
TextInput1_1.Text
) || StartsWith(
Address_to,
TextInput1_1.Text
)||
//This StartsWith() code currently does not return data
//You can ignore all the other line of code as this is the only that doesn't function
//correctly
StartsWith(
LookUp(company_list_name, Value = TextInput1_1.Text).Value,
TextInput1_1.Text
),
//Company Box
(Company_From.Value = [@Company_1].Selected.Value Or [@Company_1].Selected.Value = "Company"),
//Property Box
(Property = office_1.Selected.Value Or office_1.Selected.Value = "Office"),
// Date Range
(start_1.SelectedDate <= Created) && (Created <= DateAdd(end_1.SelectedDate,1)
)
),
"Created",
SortOrder.Descending
)
Ignore the incorrect list name for the two function 😁
This is the new code for the collection list
Clear(temp_list) ;
ForAll(CourierApp, Collect(temp_list, ForAll(Split(Company_To," ") As SplitColl,
{
Value: SplitColl.Value,
Company_To:Company_To,
Created:Created,
Id: ID,
CCV: CCV,
ID:ID
} )
));
ClearCollect(Col_StartWith, Filter(temp_list, StartsWith(Value, TextInput1_1.Text)) )
There is more column in the SharePoint list, but only taking out a few for testing purposes.
