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
a
(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
a
(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
a
(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
a
(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