Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Combining Filter and Search Functions

(0) ShareShare
ReportReport
Posted on by 37

In my current Power Apps project, I am currently filtering the data so that when users login to the app, they will only see orders connected to their account. That is currently working, but I would also like to implement a search function so they can search for specific orders based on keywords in the 'Title' column.

I am currently using Filter([@'SharepointList'],(Concat(Requestor,Email) = User().Email)) to filter by the user.

And using Search([@'SharepointList'], TextInputSearch.Text, "Title") to search by the keywords.

However, when I try to combine the two, or try to use a semi-colon to have both lines, I keep getting errors. Does anyone know how to combine these functions together properly, or is there another more efficient way of going about this?

  • QuoteOnQuote Profile Picture
    QuoteOnQuote 37 on at
    Re: Combining Filter and Search Functions

    I need to use concat to access the requestor's email correctly (something about the way the list is set up causes errors any other way), but thank you so much, that worked!

  • Verified answer
    Drrickryp Profile Picture
    Drrickryp on at
    Re: Combining Filter and Search Functions

    @QuoteOnQuote 

    Assuming that the filter and the search are correct:

     

    With({splist: Filter(
     [@'SharepointList'],(Concat(Requestor,Email) = User().Email)
     )
     },
     Search(
     splist, TextInputSearch.Text, "Title"
     )
    )

    I am not sure why you have included Concat(... inside parentheses. 

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard