Create multi search page

(0) Share

Report

Posted on by vranjan22

Hi,

I have created an app for collecting sales lead in PowerApp. The database is SQL Server Express Edition.

I want to create a page where any user can search by inputing multiple items. I am using the following formula on Item of the galary:

Filter(
       Filter(
          Filter('[dbo].[LeadTable]',
                StartsWith(Follow_Up_Date,srchFolloupDate.SelectedDate)
                 ),
          StartsWith(Lead_Owner,srchLeadOwner.Text)
           ),
       StartsWith(Lead_Status, srchLeadStatus.Selected.Value)
   )

where: '[dbo].[LeadTable]' = Sales Lead data table

,srchFolloupDate = Power App date picker

,srchLeadOwner = input box for lead owner

,srchLeadStatus = drop down for lead status

The app is not accepting the formula. Please help.

Thanks,

Vivek

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

bdodu 399 on at

Like (0)

Report
Copy link

Link copied!
The line:

StartsWith(Follow_Up_Date,srchFolloupDate.SelectedDate)
is not correct as StartsWith expects text and you provided a Date value (selectedDate)
you have to format it as Text with
StartsWith(Follow_Up_Date,Text(srchFolloupDate.SelectedDate, <<format>>))

where <<format>> is more detailed here: Date To Text

Was this reply helpful? Yes No
vranjan22 37 on at

Like (0)

Report
Copy link

Link copied!

Hi @bdodu

Thank you for your response.

I applied your suggestion, but it still giving me the error.

Filter(
       Filter(
          Filter('[dbo].[LeadTable]',
                StartsWith(Follow_Up_Date,Text(srchFolloupDate.SelectedDate,"[$-en-US]dd/mm/yyyy"))
                 ),
          StartsWith(Lead_Owner,srchLeadOwner.Text)
           ),
       StartsWith(Lead_Status, srchLeadStatus.Selected.Value)
   )

Please advise.

Was this reply helpful? Yes No
bdodu 399 on at

Like (0)

Report
Copy link

Link copied!

ok what is the error or what words are red underlined by PA?

Was this reply helpful? Yes No
vranjan22 37 on at

Like (0)

Report
Copy link

Link copied!

@bdodu

The error is on date filter:

The function 'StartsWith' has some invalid argument
Invalid argument (DateTime). Expecting a Text value instead

Was this reply helpful? Yes No