Display Collection into Gallery and then Filter by textbox

(0) Share

Report

Posted on by venka91

1,119

Hi there,

I have a data column, two drop down boxes and a Filter button. OnSelect of filter button, galleryitem shows the collection data.

However, i want to put one more textbox to filter the value within the item shown on gallery. Is this doable... if i use Search on Filter button, since my textbox is empty it does not pull the data. How do i refine this results with the way i required.

On Filter Icon Select :

ClearCollect(TempGal1, Filter(SAL_DAILY, class = ddclass_demo.SelectedText.Value && campus = ddcampus_demo.SelectedText.Value && Attendance_date = adate_demo.SelectedDate));

Gallery Item set to : TempGal1

Now what ever results displayed in Gallery, I want to place an another text box and search within this results.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@venka91 ,

It depends on whether you want it to be Delegable

ClearCollect( TempGal1, Filter( SAL_DAILY, class = ddclass_demo.Selected.Value && campus = ddcampus_demo.Selected.Value && Attendance_date = adate_demo.SelectedDate && ( IsBlank(YourTextBox.Text) || StartsWith( YourSearchField, YourTextBox.Text ) ) ) )

The in Filter or Search() are not Delegable.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
venka91 1,119 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren,

Thank you for looking into this. But this formula, gives me no result. More over when i click the Filter Button, i do not enter text there in my textbox.
Once the collection is generated with the Filter icon click, this displays collection records into the gallery.
Since the gallery items are more than 50 records, i would like to search specific result from the gallery using textbox.
So the result that comes in gallery based on the textbox, i will edit and submit it. This is where i am struck.

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@venka91 ,

Can you please post in Text the exact formula you are using. The syntax is valid and should produce a result providing your values are valid.

Was this reply helpful? Yes No
venka91 1,119 on at

Like (0)

Report
Copy link

Link copied!

ClearCollect(TempGal1, Filter(SAL_DAILY, class = ddclass_demo.SelectedText.Value && campus = ddcampus_demo.SelectedText.Value && Attendance_date = adate_demo.SelectedDate && (IsBlank(txtsrch.Text || StartsWith(student_name,txtsrch.Text)))));

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@venka91 ,

Your brackets are incorrect

ClearCollect( TempGal1, Filter( SAL_DAILY, class = ddclass_demo.SelectedText.Value && campus = ddcampus_demo.SelectedText.Value && Attendance_date = adate_demo.SelectedDate && ( IsBlank(txtsrch.Text) || StartsWith(student_name,txtsrch.Text) ) ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
venka91 1,119 on at

Like (0)

Report
Copy link

Link copied!

i did validate the brackets, they are matching and closing as per the order. But i do not get any errors. But when i click on Filter i do not see any results in Gallery.

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@venka91 ,

The ones you posted were not matching - the syntax is valid providing your values are.

Was this reply helpful? Yes No
venka91 1,119 on at

Like (0)

Report
Copy link

Link copied!

That was may be a typo.
But i am wondering why i am not able use multiple filters.

Was this reply helpful? Yes No
venka91 1,119 on at

Like (0)

Report
Copy link

Link copied!

I am suspecting an issue. Please let me know if this is the correct ways.

When I click filter icon, the collection is created is filters. This collection is what I am displaying in gallery.

Since my collection holds many records again I need to filter this result based on the text box input.

I am not sure how do I combine in item property or narrow down further

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@venka91 ,

Make the Items of the Gallery

Filter( SAL_DAILY, class = ddclass_demo.SelectedText.Value && campus = ddcampus_demo.SelectedText.Value && Attendance_date = adate_demo.SelectedDate && ( IsBlank(txtsrch.Text) || StartsWith(student_name,txtsrch.Text) ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No