web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Large Excel Data Table...

Power Apps

Unanswered

Large Excel Data Table Filter

(0) Share

Report

Report

Posted on by Balla999

2

I have 35K+ data in my table1 connected in Excel Online, now I want to filter and search my data based on my inputted data in Input Text and search them either by the column of Name and Email , I am new to this platform

I tried AND,OR function by its giving me a delegation warning

here my formula only working for column of Email

SortByColums(Filter('table1',Startswith('Email',tb1.text) ), " ELID" ,SortOrder. Ascending )

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Balla999 ,

If you have multiple conditions, please try to use with function.

With({temp:Filter(Table1_1,"B" in Title)},Filter(temp,"2" in ID))

Best Regards,

Wearsky

Was this reply helpful? Yes No
Balla999 2 on at

Like
a
(0)

Report
Copy link

Link copied!
With({temp:Filter(Table1_1,"B" in Title)},Filter(temp,"2" in ID))

I modify this code there's no delegation warning but i cant filter my inputted data in input text heres my code

With({temp:Filter(Table1,tb.Text in Name)},Filter(temp, tb.Text in Email))

Was this reply helpful? Yes No

Join the conversation