Nested SEARCH function with DATE and TIME control giving problem

[Bradblr2020]

I am using gallery to populate Canvas app with 5 columns grid table.

Column names:  Name, Age, Customer ID, Vaccine Status, Birth date and time.

I am using nested SEARCH function to populate 5 column grid table and allowing user to search grid data based on specific column.

User can search customer record by typing customer name in NAME Textbox or User can search customer record by typing customer age in AGE Textbox,…..

Gallery Item property script:

Search(
              Search(
                             Search(
                                           Search(
                                                         Search(
                                                                       Database_Name,
                                                                        Textbox_Name.Text,
                                                                        “Name_Column”
                                                                       ),
                                                          Textbox_Age.Text,
                                                          “Age_Column”
                                                          ),
                                            Textbox_Customer_ID.Text,
                                           “Customer_ID_Column”
                                           ),
                             Textbox_Vaccine_Status.Text,
                             “Vaccine_Status_Column”
                             ),
               Textbox_Birth_Date_Time.Text,
              “Birth_Date_Time _Column”
              ),
)

Dataverse Columns & Column type includes:

Name_Column = Text

Age_Column = Text

Customer_ID_Column = Text

Vaccine_Status_Column =Text

Birth_Date_Time_Column= Date and Time

I am using textbox field to allow user to put date/time for searching specific customer record.

I tried to add DATE and TIME Control instead of textbox field however I don’t know how to capture user selected data and time from control and pass it into search script so I am using textbox field.

Error:

The function ‘Search’ has some invalid arguments.

Wrong column type. Expects text type.

I am assuming here that Date and Time column in dataverse table is not acceptable to SEARCH function. Search function is looking for text field and I am using DATE and TIME column type in database table.

Any ideas or suggestion for how to allow user to search for customer record using DATE/TIME column?

If required:

I am happy to replace textbox control to Date/Time control in gallery.
OR
Replace my script with any better alternate scripts.
OR
any other suitable solutions?

[mmbr1606]

hey @Bradblr2020 

please try this:

Filter(
  Search(
    Search(
      Search(
        Search(
          Database_Name,
          Textbox_Name.Text,
          "Name_Column"
        ),
        Textbox_Age.Text,
        "Age_Column"
      ),
      Textbox_Customer_ID.Text,
      "Customer_ID_Column"
    ),
    Textbox_Vaccine_Status.Text,
    "Vaccine_Status_Column"
  ),
  DateValue(Text(DatePicker_Birth_Date_Time.SelectedDate)) = DateValue(Text(Birth_Date_Time_Column))
)

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings