Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Lisa White]

This is probably a basic question, but I can’t figure it out.

I have a Power App form with a Gallery.

This is the set up:

• Data source: SharePoint list named PARS
• Input text box name: txtSearchOpp

Search by itself works fine using Gallery Items property: Search(PARS,txtSearchOpp.Text, “Title”)

I don’t want all the records to display in the Gallery before user enters search text.

I’ve tried at least 20 permutations for the Items property using If, IsBlank, variable, etc. The latest one doesn’t work, so I’m throwing in the towel.

If(IsBlank(txtSearchOpp.Text),””,Search(PARS,txtSearchOpp.Text, “Title”))
?

——————————
Lisa White
Senior IT Specialist
Herndon VA
703-709-7172
——————————

[Warren Belz]

Hi Lisa,
Try this

If(IsBlank(txtSearchOpp.Text),PARS,Search(PARS,txtSearchOpp.Text,"Title"))?
or

Filter(PARS,If(IsBlank(txtSearchOpp.Text),true,txtSearchOpp.Text in Title))

——————————
Warren Belz
Queensland Australia
——————————
——————————————-