in need your Help
my code is not working
Somehow I can't get the 2 comboboxes to filter Task and Agent.
Hi @Anonymous
Please update to below
ClearCollect(colGridDate,With({_Item: Taskboard}, Filter(_Item, IsBlank(....
) //With Ends
) //ClearCollect Ends
Not fully typed your code.. Please send me your current code, I will update it if any help.
.
Hi again so far I have it now . only one error I still have in the search of my employees somehow he does not want this code ... (highlighted in yellow in the picture)
Hi @Anonymous,
AssignSearch.SelectedItems is an array of record (event if you selected one person).
You can try something like : First(AssignSearch.SelectedItems).DisplayName
By the way, if you have the opportunity to filter on email instead of DisplayName it would be better, as DisplayName can be format differently accros the system. And Email is unique for sure.
Hi thx but is not working
ClearCollect(
colGridData,
Filter(
Taskboardapp,
StartsWith(
Title,
TextInput12.Text
)
&& ( 'Assigned to'.DisplayName = First(AssignSearch.SelectedItems).DisplayName || AssignSearch.Selected = Blank() )
&& ( 'Sub Info'.Value = Priosearch.Selected.Value|| Priosearch.Selected.Value = Blank() )
&& ( Category.Value = Categorysearch.Selected.Value || Categorysearch.Selected.Value = Blank() )
,
'Start date' >= DatePicker1.SelectedDate && 'Start date' <= DatePicker1_1.SelectedDate
)
);
Hi @Anonymous
Try this
ClearCollect(
colGridData,
With(
{taskboard: Taskboardapp},
Filter(
taskboard,
(StartsWith(Title,TextInput12.Text))
&& ( IsEmpty(AssignSearch.SelectedItems) || 'Assigned to'.Email in AssignSearch.SelectedItems.Email)
&& ( IsBlank(Priosearch.Selected) || 'Sub Info'.Value = Priosearch.Selected.Value)
&& ( IsBlank(Categorysearch.Selected) || Category.Value = Categorysearch.Selected.Value)
&& (IsBlank(DatePicker1.SelectedDate) || 'Start date' >=DatePicker1.SelectedDate)
&& (IsBlank(DatePicker1_1.SelectedDate) || 'Start date' <= DatePicker1_1.SelectedDate)
) //Filter ends
) //with ends
) //Collect ends
Hi @Anonymous
My Assumption is
AssignSearch - Person field (ComboBox)
Priosearch - Choice (Dropdown)
Categorysearch - Choice (Dropdown)
'Start date' - Date
We can change the code if anything changes
Many thanks first
Unfortunately it won't run with this code either.
&& ( IsEmpty(AssignSearch.SelectedItems) || 'Assigned to'.Email in AssignSearch.SelectedItems.Email)
if I take this out everything works fine but the filter function for this column does not work. I have tried everything with email /name ect. but nothing works.
Hi @Anonymous
No Problem. We can find the issue. Please clarify few questions
User | Count |
---|---|
251 | |
102 | |
94 | |
48 | |
37 |