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?
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!
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.