Answered

Repeating Tables and Gallery Filters

(0) Share

Report

Posted on by ksullivan2

I followed along with one of Shane's videos to create an app. I've been able to customize it to meet our needs, but I need to apply a more complex filter for one of the galleries and am hoping for a little help. This is the video I used: https://www.youtube.com/watch?v=xgznk4XlPCo

First, here's what everything looks like.

Below is the first screen where users add their information and the repeating table. The top portion patches to List1 and the repeating table patches to List2. They are connected through MasterID which is a field on List2 which is populated through Patch like this - MasterID: Form1.LastSubmit.ID.

On edit, The Master Gallery on the left is what is shown, an item is clicked on in Master Gallery, the ItemGallery's correlating items from List2 become visible. When you click on an item from the ItemGallery, a small edit form appears at the bottom for editing. Save and it all is written to the list. It all works great.

The issue is, the Master Gallery Items will quickly become very long causing users to have to scroll quite a bit to find their items that need editing. I want to filter these items so that when ItemGallery has the intials and date returned filled in, I no longer want to see the items in the master gallery. Below, since the highlighted items have been returned, I no longer want them populated in the Master Gallery. The only filter applied right now is on the ItemsGallery Items Property which is below:

Filter('List2', 'Master ID'= MasterGallery.Selected.ID)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there a column that is blank until it is edited? For example, if you have a "Comments" or "Status" column that is updated with "Item Returned", you can filter out the non-blank values to get rid of them after they're edited.

Something like Filter('List2', 'Master ID'= MasterGallery.Selected.ID, IsBlank('Status'))

Was this reply helpful? Yes No
ksullivan2 84 on at

Like
a
(0)

Report
Copy link

Link copied!

@Rusk The goal would be when a user 'initials' the edit form highlighted below, that item would no longer appear in the gallery to the right and when both items have initials, the item in the gallery to the left would no longer appear. I tried the IsBlank with the initials field using this:
Filter('List2', 'Master ID'= MasterGallery.Selected.ID, IsBlank(Initialstxt)) but it didn't work at all. It wasn't mad, just didn't work. I tried various iterations of this including using ThisItem and a few others, with no luck.

Was this reply helpful? Yes No
Verified answer

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

It looks like "Initialstxt" is not in your actual Gallery, so you won't be able to use that to filter the Gallery items. Does that info get saved somewhere when you save? What is the name of the column that the Initalstxt updates?

Was this reply helpful? Yes No
ksullivan2 84 on at

Like
a
(0)

Report
Copy link

Link copied!

It points to this list (List2) and the column names are listed in the first screenshot. Initials is a single line column. The ItemsGallery (yellow highlight) itself doesn't have input fields (circled in red) and the form (circled in blue) at the bottom is where the edits occur. The form's item is "ItemGallery.Selected". Does that make sense?

Was this reply helpful? Yes No
ksullivan2 84 on at

Like
a
(1)

Report
Copy link

Link copied!

@Rusk I figured it out, your comments helped me to think about the formula conditions differently. Thanks so much.

Filter('List2', 'Master ID'= MasterGallery.Selected.ID, IsBlank(Initials))

Was this reply helpful? Yes No