Delegation errors

[Incident-Manage]

Hello,

I am currently trying to add a gallery into my canvas app, I want the gallery to have newer calls at the top of the list, and then I want users to be able to do a search by either an Incident Title or a start date The parameters I am adding are below but I am getting a delegation error and the it seems like it should all delegatable. 

SortByColumns(Filter([@'Major Incident Dashboard'], StartsWith('Incident Call Start Date', TextSearchBox3)), "Title", If(SortDescending3, Descending, Ascending))

[RandyHayes]

@Incident-Manage 

StartsWith works for Text columns.  You are indicating that 'Incident Call Start Date' is a date column.

Your formula would need to be corrected to:

SortByColumns(
    Filter('Major Incident Dashboard', 
        'Incident Call Start Date' = DateValue(TextSearchBox3.Text)
    ), 
    "Title", 
    If(SortDescending3, Descending, Ascending)
)

I hope this is helpful for you.

[Incident-Manage]

So I tried as indicated above but now my gallery isn't loading anything.

[RandyHayes]

@Incident-Manage 

Most likely because your dates don't match.  A date column and comparison really includes the Time as well.  A date with no time has a time value of "00:00:00"  But, then localization plays a factor as your Date gets offset by the time zone.

Start with this formula to account for it:

SortByColumns(
    Filter('Major Incident Dashboard', 
        'Incident Call Start Date' >= DateValue(TextSearchBox3.Text),
        'Incident Call Start Date' <= DateAdd(DateValue(TextSearchBox3.Text), 1, Days)
    ), 
    "Title", 
    If(SortDescending3, Descending, Ascending)
)

This is not necessarily the final formula, but this is to test to see if the time factor in the dates is the issue you are encountering.

[Incident-Manage]

So this works partially my gallery is blank but only if I don't have anything loaded into the search box, once I add a date to the search box it pulls all the calls for the selected date.

[RandyHayes]

@Incident-Manage 

Okay...you can account for that in the Formula:

SortByColumns(
    Filter('Major Incident Dashboard', 
        IsBlank(TextSearchBox3.Text),
        'Incident Call Start Date' >= DateValue(TextSearchBox3.Text),
        'Incident Call Start Date' <= DateAdd(DateValue(TextSearchBox3.Text), 1, Days)
    ), 
    "Title", 
    If(SortDescending3, Descending, Ascending)
)

[Incident-Manage]

This gives me nothing, even if try searching a date in the search field. I have attached screenshots showing the behavior.

[RandyHayes]

@Incident-Manage 

Okay, you have never validated if Incident Call Start Date is a date column or a text column.  Which is it?

[Incident-Manage]

@RandyHayes Incident Call Start Date is a date column the table pulls from my SharePoint List and in its setting I set it to date only.

[RandyHayes]

@Incident-Manage 

Sorry, I see I had a typo in the formula I provided you.

It should be:

SortByColumns(
    Filter('Major Incident Dashboard', 
        IsBlank(TextSearchBox3.Text) ||
        ('Incident Call Start Date' >= DateValue(TextSearchBox3.Text) &&
        'Incident Call Start Date' <= DateAdd(DateValue(TextSearchBox3.Text), 1, Days))
    ), 
    "Title", 
    If(SortDescending3, Descending, Ascending)
)

If it's a Date Column, then the formula should be providing what you need.