cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Djanan
Level: Powered On

Search field gallery

I have a search field that is not working correctly. i ahve no clue what the problem is, can someone help me?

 

finance.jpgsearchfield2.0.jpg

7 REPLIES 7
iiBzY
Level: Powered On

Re: Search field gallery

Change Filter() to Search()?

Djanan
Level: Powered On

Re: Search field gallery

Dear @iiBzY ,

I want to keep Filter for the dropdown1_10 and Finance in Trackname. But can I do as below?

If(
!IsEmpty(InitialCollection),
InitialCollection,
Filter(Tickets, Status = Dropdown1_10.Selected.Result && "Finance" in Trackname); && Search(Tickets,TextInput3_9.Text in ID || TextInput3_9.Text in Type|| TextInput3_9.Text in Trackname || TextInput3_9.Text in Statusdevops || TextInput3_9.Text in AssignedTo || TextInput3_9.Text in Status)
)

 

search5.0.jpg

iiBzY
Level: Powered On

Re: Search field gallery

Try this, haven't had time to test it but think it should work

If(

!IsEmpty(InitialCollection),
InitialCollection,
Filter(Search(Tickets,TextInput3_9.Text in ID || TextInput3_9.Text in Type || TextInput3_9.Text in Trackname || TextInput3_9.Text in Statusdevops || TextInput3_9.Text in AssignedTo || TextInput3_9.Text in Status), Tickets, Status = Dropdown1_10.Selected.Result && "Finance" in Trackname))

Community Support Team
Community Support Team

Re: Search field gallery

Hi @Djanan ,

 

I assume that Status is choice column, then the formula should be:

If(
!IsEmpty(InitialCollection),
InitialCollection,
Search(Filter(Tickets, Status.Value = Dropdown1_10.Selected.Result,"Finance" in Trackname),TextInput3_9.Text,"ID","Type","Trackname","Status"devops","AssignedTo","Status
))

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Djanan
Level: Powered On

Re: Search field gallery

@iiBzY unfortunately I get following warnings message

searchwarning.jpgsearch warning2.jpg

Djanan
Level: Powered On

Re: Search field gallery

@v-monli-msft unfortunately I get following warnings message

searchwarning3.0.jpgsearchwarning4.jpg

Community Support Team
Community Support Team

Re: Search field gallery

Hi @Djanan ,

 

It seems that there are some mistakes in your formula, you have added an additional " to the column name Statusdevops and forget to add a ' for Status column.

Capture.JPG

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 175 members 5,146 guests
Please welcome our newest community members: