Answered

Trying to use multiple filters on data table (user email and search textbox)

(0) Share

Report

Posted on by gaborszollosy

Hey!

I'm trying to create a loading screen where the people using the app would be able to see the saves made by them. The data source (FBFormSave) has a column (UserEmail), I want to pre-filter the table results based on this column, and then use another filter or search that checks for the company name (edt_cegnev) column, to see if there are any results after applying both parameters.

I tried using filters, filter+search, and every time I get the error message below:

Can you please tell me what I'm doing wrong?

I appreciate your time and help!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @gaborszollosy ,

There is nothing wrong with your code (the message makes no sense to me), but assuming you want to find if the company name contains any string from that text box and also avoid Delegation warnings, you can try this, though be aware that the top filter needs to return record numbers under your Delegation limit.

With( { wList: Filter( FBFormSave, UserEmail = User().Email ) }, Search( wList, edt_betoltes_keroso.Text, "edt_cegnev" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Filter(FBFormSave,UserEmail=User().Email,StartsWith(CompanyColumn,TextInput1.Text))
gaborszollosy 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much!! This worked! 🙂
gaborszollosy 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your time, and assistance. Unfortunately, the Filter you wrote gave me the same error when updating with the actual CompanyColumn, and TextInput.