<,<=,>,>= error while = and <> are ok in a text property formula of text control in power apps

(0) Share

Report

Posted on by SE-21121213-0

Hello,

I am trying to filter a table from DATAVERSE in power apps canvas.

Trying to filter Dates by using DatePicker controls SelectedDate property with Date column in the table.

>,>=,< and <= operators are giving error.

I am testing those in text control text property value somewhere on the screen and it is giving repond as you can see below screenshots.

Any one could help me to see how I can manage such a comparison operation wthout receving the same error as into text control formula area into the below screenshot?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

AndrianaO 213 Moderator on at

Like (1)

Report

Hi! Instead of comparing values as a text you can try to compare them as dates:

DatePicker_StartDate.SelectedDate > Date(2023,02,22)

Let me know if it works!

Was this reply helpful? Yes No
SE-21121213-0 6 on at

Like (0)

Report

Hii AdrianaO ,

Thanks for your your answer.

When I apply the formula inti text control it worked as hereby above. I applied the same to my table items property formula bar as hereby below;
After,I applied same principal to my table items property formula bar as;

Filter(

'DCCLogFile-Correspondances',

(cmb_Section.Selected.Title in DocNo || cmb_Section.Selected.Title = Blank())

&& (cmb_DocType.Selected.Title in DocNo || cmb_DocType.Selected.Title = Blank())

&& (cmb_FromTo.Selected.Title in DocNo || cmb_FromTo.Selected.Title = Blank())

&& (TextInput_Search.Value in Subject || TextInput_Search.Value = Blank())

&& OnDate >= DatePicker_StartDate.SelectedDate

&& OnDate <= DatePicker_EndDate.SelectedDate

)

After it hasn't give error or Delegation warning but it is not giving any data,instead it is giving waiting sign without any result as below;

My OnDate column properties as here below;

UUnfortunately, I stuck here and not able to forwarding to finalise the program. Thanks in advance.

Was this reply helpful? Yes No
SE-21121213-0 6 on at

Like (0)

Report

Hii Again Adriana0,

It has worked after I revised the items formula as;

Filter(

'DCCLogFile-Correspondances',

(cmb_Section.Selected.Title in DocNo || cmb_Section.Selected.Title = Blank())

&& (cmb_DocType.Selected.Title in DocNo || cmb_DocType.Selected.Title = Blank())

&& (cmb_FromTo.Selected.Title in DocNo || cmb_FromTo.Selected.Title = Blank())

&& (TextInput_Search.Value in Subject || TextInput_Search.Value = Blank())

&& (OnDate >= DatePicker_StartDate.SelectedDate || DatePicker_StartDate.SelectedDate = Blank())

&& (OnDate <= DatePicker_EndDate.SelectedDate || DatePicker_EndDate.SelectedDate = Blank())

)

Thanks for your advice for Date comparison problem.

Was this reply helpful? Yes No