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

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 153,051 Most Valuable Professional on at

Like (1)

Report
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.

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report

Filter(FBFormSave,UserEmail=User().Email,StartsWith(CompanyColumn,TextInput1.Text))

Was this reply helpful? Yes No
gaborszollosy 71 on at

Like (0)

Report

Thank you so much!! This worked! 🙂

Was this reply helpful? Yes No
gaborszollosy 71 on at

Like (0)

Report

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.

Was this reply helpful? Yes No