Answered

Combining Filter and Search Functions

(0) Share

Report

Posted on by QuoteOnQuote

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
QuoteOnQuote 37 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No