Multiple Search Input in a single gallery using With function

(0) Share

Report

Posted on by DBTS7

Hi,

I'm having this gallery in which i want to search texts based on different columns.

In gallery items, i've written this code using With function:

With(
{
records: PCT_List
// Filter(PCT_List,StartsWith(PPID,TextInput1.Text)||StartsWith('SAP Number',TextInput1_1.Text)||StartsWith('SAP Description',TextInput1_2.Text))
},
ForAll(
Sequence(CountRows(records)),
Patch(
Last(
FirstN(records,Value)),
{rowNumber: Value}
)
)
)

I'm writing this so that I'll can have different color rows in powerapps gallery.

and I also tried to use filter function with different textinputs but it is not working. (commented out that code ).

Anyone have any idea, how i can search based on different columns in this gallery with different textinputs?

Thanks

Categories:

Building Power Apps

All responses (13)

Answers (0)

Sort by

WarrenBelz 156,736 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DBTS7 ,

What exactly do you want to do here - this code (note the small suggestion at the bottom) will search those three fields using StartsWith(). Note however that the output (not the input) of a With() statment is limited by your Delegation limit.

With( { records: Filter( PCT_List, StartsWith( PPID, TextInput1.Text ) || StartsWith( 'SAP Number', TextInput1_1.Text ) || StartsWith( 'SAP Description', TextInput1_2.Text ) ) }, ForAll( Sequence(CountRows(records)), Patch( Index( records, Value ), {rowNumber: Value} ) ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps
DBTS7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz , thanks for the reply,
But this isn't working. Not sure why.
I tried writing this simple line also :
Filter(PCT_List,StartsWith(PPID,TextInput1_5.Text) || StartsWith('SAP Number',TextInput1_4.Text))
But the also it is not filtering the data. When writing only 1 StartsWith it is working but not for multiple StartsWith.
As you can see below:
With multiple startswith
With one startswith it only searches what i given in the input text
WarrenBelz 156,736 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DBTS7 ,

When you say "not working" - is it simply not filtering or do you have an error ? Also how many records in your list as you have restricted the potential output by using the With() Statement.
DBTS7 on at

Like
a
(0)

Report
Copy link

Link copied!

It is not filtering the data.
I have removed With function as it's not required now because the coloring part i'm doing on label fill as
If(
Mod(ThisItem.ID,2) = 0,
RGBA(60, 60, 60,1),
RGBA(90, 90, 90,1)
)

Now I just need to filter the gallery data without using With function. Like i showed in previous comments.
For now there are max. 10 records in the sharepoint list.
WarrenBelz 156,736 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@DBTS7 ,

If you have under your Delegation limit (well under in your case), the With() statement will not affect this. If you set the Default of each of the search boxes to "" (empty string), it should work with the code you have (which I updated in my first post).
DBTS7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz , Yes i tried the code you send using With function but it is not working with multiple startswith function.
Default is also having "" empty string.

I saw many sites using same approach when doing multiple searches using multiple StartsWith. Not sure why it is not working. Also i'm not getting any delegation warning.

Any other approach that i can use to filter out data on different columns?

Thanks
WarrenBelz 156,736 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@DBTS7 ,

What is your data source ?
DBTS7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
It's a sharepoint list which is having around 15 columns and 10 rows.
WarrenBelz 156,736 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@DBTS7 ,

I was trying to eliminate things suspecting you were using Excel, which can be problematic on more complex filters, but SharePoint should handle this in a Delegable manner (so record numbers do not matter), however PPID, 'SAP Number' and 'SAP Description' all need to be Single Line of Text fields (StartsWith does not work with numbers or delegably with complext field types such as Choice or Lookup)

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.

MVP (Business Applications) Visit my blog Practical Power Apps
DBTS7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
All 3 columns are single text in sharepoint list. also I tried with this simple formula with collection, but it is also not working with multiple cases.....
Thanks