Power Platform Community Forum Thread Details

I have 2 apps and the same formula seems to be working for my old app but not the new one.

Please can some one help with the right functions? In the app i the date is underlines red. I need help with the below functions

Sort(
Filter(
'Housing Packet',
(StartsWith(Title, TextInput2.Text)
|| StartsWith(LastName, TextInput2.Text)
|| StartsWith(CityFHEPS, TextInput2.Text)
|| StartsWith(EHV, TextInput2.Text)
|| StartsWith("2010E", TextInput2.Text))

&& (IsBlank(DropDown11.Selected.Value)
|| CityFHEPS = DropDown11.Selected.Value)

&& DateValue(Date) >= DatePicker11.SelectedDate
&& DateValue(Date) <= DatePicker12.SelectedDate

&& (IsBlank(DropDown12.Selected.Value)
|| EHV = DropDown12.Selected.Value)

&& DateValue(Date) >= DatePicker11.SelectedDate
&& DateValue(Date) <= DatePicker12.SelectedDate

&& Status.Value = Dropdown55.Selected.Value
),
"ID",
SortOrder.Descending

)

Screen Shot 2023-06-26 at 6.56.50 AM.png

Categories:

Building Power Apps

In the formula you provided, the issue seems to be with the Date functions causing the dates to be highlighted in red. To resolve this, you can modify the formula as follows:

Sort(
 Filter(
 'Housing Packet',
 (StartsWith(Title, TextInput2.Text)
 || StartsWith(LastName, TextInput2.Text)
 || StartsWith(CityFHEPS, TextInput2.Text)
 || StartsWith(EHV, TextInput2.Text)
 || StartsWith("2010E", TextInput2.Text))
 && (IsBlank(DropDown11.Selected.Value)
 || CityFHEPS = DropDown11.Selected.Value)
 && Date >= DatePicker11.SelectedDate
 && Date <= DatePicker12.SelectedDate
 && (IsBlank(DropDown12.Selected.Value)
 || EHV = DropDown12.Selected.Value)
 && Date >= DatePicker11.SelectedDate
 && Date <= DatePicker12.SelectedDate
 && Status.Value = Dropdown55.Selected.Value
 ),
 "ID",
 SortOrder.Descending
)

In the modified formula, I removed the unnecessary DateValue functions and updated the conditions involving the Date column. The Date column is now directly compared with the selected dates from DatePicker11 and DatePicker12.

Make sure to replace "Date" with the actual column name from your 'Housing Packet' table that contains the date values.

By making these changes, the red underline error should be resolved, and the formula should function correctly in your new app.

Mark as solution if this solves your problem. Let me know if you need further assistance