Delegation Help

[Anonymous]

in need your Help 

my code is not working 

Somehow I can't get the 2 comboboxes to filter Task and Agent.

[StalinPonnusamy]

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.

[Anonymous]

.

[Anonymous]

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)

[lcimon]

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.

[Anonymous]

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
)
);

[StalinPonnusamy]

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

[StalinPonnusamy]

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

[Anonymous]

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.

[StalinPonnusamy]

Hi @Anonymous

No Problem. We can find the issue. Please clarify few questions

1. AssignSearch is person field?
2. Share the Items property of this Combobox.