How to sort data in gallery by dropdown list data and datepicker

[Anonymous]

Now I sort data in gallery by "MaterialTitle" [singer line text] 

I need to sort data by date range between Effective date and Valid date.

I add 2 datepicker on app [ start and end of range date] 

How I create the code.??

I type to mix Filter(InternalMemoRegister,DateValue(Text(Effect Date),"en")>=(DateValue(Text(DatePicker1.SelectedDate),"en")&& DateValue(Text(Valid Date),"en")<=DateValue(Text(DatePicker2.SelectedDate),"en")) with the current code, but it not work. T^T

I set column type of Effective date and Valid date in SP as Date and Time.

[RezaDorrani]

Hi @Anonymous 

Check this vlog

https://www.youtube.com/watch?v=eCMuXPI1Qok

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[v-monli-msft]

Hi @Anonymous ,

Try with below formula instead:

SortByColumns(Filter(InternalMemoRegister,StartsWith(MaterialTitle,Dropdown2.Selected.Value),DateValue(Text(Effect Date),"en")>=(DateValue(Text(DatePicker1.SelectedDate),"en")&& DateValue(Text(Valid Date),"en")<=DateValue(Text(DatePicker2.SelectedDate),"en")),"MaterialTitle",If(SortDescending1,Descending,Ascending))

Regards,

Mona

[Anonymous]

Today, I will test and inform you again.

[Anonymous]

It still error, I test change Dropdown 2 to .value and .Result, It still aboth error.

[v-monli-msft]

Hi @Anonymous ,

Please copy and paste the whole formula here.

Regards,

Mona