Search multiple conditions from Sharepoint with output to Gallery

[RyoIshi731]

Hi 

I would like to implement search function.

The specification is like this.

I put 2 items to search.  TextInput1_1 and StatusFlag(Toggle Button).

Data is in "MaintenanceReport" in SharepointList and having columns

 "CustomerName",

 "EngineerName",

 "Status"

 "CustomerName" and  "EngineerName" should be searched by TextInput1_1  (Or Condition)

 "Status" should be matched by StatusFlag

 TextInput1_1 and StatusFlag is And condition for searching.

I write like this for Gallery item. However it doesn't work.

Many error happens in all gallery items.

Filter(
 MaintenanceReport,
 TextInput1_1.Text in Engineer.DisplayName || TextInput1_1.Text in CustomerName.Value And Status.Value="1.Open"
  ),Filter(
  MaintenanceReport,
  TextInput1_1.Text in Engineer.DisplayName || TextInput1_1.Text in CustomerName.Value

)

Error messages

I would really appreicate you if you could help me solve this.

[CNT]

@RyoIshi731 What are the datatypes of the following columns in the SP list?

 "CustomerName",

 "EngineerName",

 "Status"

[RyoIshi731]

Hi @CNT    Thank you for contact.

 "CustomerName": Choice

 "EngineerName" : M365User

 "Status": Choice

Regards

[CNT · Accepted solution]

@RyoIshi731 Try this,

Filter(
 MaintenanceReport,
 (TextInput1_1.Text in Engineer.DisplayName || TextInput1_1.Text in CustomerName.Value) && Status.Value="1.Open"
  )

[RyoIshi731]

@CNT 

Thank you so much.

Your code works.  And I modified like this.

If(
StatusFlag.Value = true,
Filter(
MaintenanceReport,
(TextInput1_1.Text in KDDI_Engineer.DisplayName || TextInput1_1.Text in CustomerName.Value) && Status.Value = "1.Open"
),
Filter(
MaintenanceReport,
TextInput1_1.Text in KDDI_Engineer.DisplayName || TextInput1_1.Text in CustomerName.Value
)
)

[CNT]

@RyoIshi731 Glad to help!