Refresh Gallery after Collection updates

[rolm]

Howdy.

I'm trying to refresh my gallery to see the latest updates of my local collection (not the datasource directly but a local collection) but doesn't refresh...

So I have a gallery that I fed with my local collection (in Items property). And in that gallery I have my controls like icons and text inputs to add new records or edit the existing ones of the collection.

So for example, when I click on an icon (OnSelect property), it adds new record - using Collect(locCollection, {col1: "name"}).

And when I use OnChange property from a text input - using Patch() or UpdateIf() it edits an existing record. I checked in  Variables > Collection section in power apps, and locCollection updates perfectly everytime!

However I don't see these updates in the gallery (locCollection is set in Items). Now I'm aware of the Refresh(locCollection) but doesn't work nor does Reset(myGallery).

I saw in other topics that you could use ClearCollect. But it means I have to make another copy of my locCollection? So that I could perform ClearCollect (locCollectionCopy, locCollection) and apply a boolean logic on Items to switch them alternately?

In any case I don't like this tricky method, is there a proper, smarter approach to accomplish this please?

Thank you!

[WarrenBelz]

Hi @rolm ,

There seems to be something fundamentally wrong here - if the Items of your Gallery is locCollection and you update the data in that collection, this would be immediately reflected in the Gallery (assuming of course that the affected record/s are in the viewable (non-scrolling) portion. Please check this as I use patched galleries extensively based on both collections and data sources directly and have never had any issues with seeing changes immediately.

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

[rolm]

Hi @WarrenBelz .

Thank you for your reply. You're right, I haven't pointed out that it actually affects my nested gallery (thought it wasn't important). And I just checked: it actually only affects the nested one (not the 1st root gallery). 

Here's the galleries structure:

In the ROOT flexible height gallery, in the Items, I have my colProductTestingsByCategory collection grouped by 'Category' column like follows:

ClearCollect(
    colProductTestingsByCategory,
    GroupBy(
        AddColumns(
            ProductsTesting,
            "Status",
            "",
            "Selected",
            false
        ),
        "Category",
        "Products"
    )
);

By clicking on + category (in blue), a new record is created in colProductTestingsByCategory by using collect() - works!

And appears in the ROOT gallery.

By clicking on + product (in red), in colProductTestingsByCategory > 1st record > column 'Products' nested table, a record is created by using collect() - works (checked in powerapps variables)!

But doesn't appear in the 1st NESTED gallery...

[WarrenBelz]

@rolm ,

What is the Items property of the nested gallery ?

[rolm]

It's 

ThisItem.Products

for the nested gallery.

And

colProductTestingsByCategory 

for the root gallery

[WarrenBelz]

@rolm ,

OK - that it what I expected (but does not explain the issue). What you are saying is creating a new record in the collection does not show the record in the nested gallery ? What exactly are you doing on the Red + Product icon (code in  Text please)

[rolm]

@WarrenBelz , thank you for your help so far.

So in my colProductTestingsByCategory collection, I have 2 columns: | Category (text type) | Products (table type) |

In the 1st Row, initially, within the Products table (where Category = "Microsoft SQL Server"), I have I have 3 records:

Then I click on the + red icon with this code (OnSelect):

UpdateContext( {varSelectedCategoryProducts: LookUp(colProductTestingsByCategory, Category = "Microsoft SQL Server").Products} );

Collect(
    varSelectedCategoryProducts,
    {
        Title: "New Product 2",
        EOL: Today(),
        EOSL: Today(),
        Notes: "A short Note (" & nfProductNotesCharactersMaxLength & " characters max)",
        Status: "toAdd"
    }
);

Now when I check again the state of colProductTestingsByCategory, I can see a new record is created:

However, nothing changes in the nested gallery (not updated):

[WarrenBelz]

@rolm ,

Before I go any further here, what is your data source ?

[rolm]

Oh yeah forgot to mention that one. It's sharepoint list. I have a table called ProductsTesting

And here's is how I'm collecting colProductTestingsByCategory:

ClearCollect(
    colProductTestingsByCategory,
    GroupBy(
        AddColumns(
            ProductsTesting,
            "Status",
            "",
            "Selected",
            false
        ),
        "Category",
        "Products"
    )
);

[WarrenBelz]

@rolm ,

OK - my questions to date were to eliminate things that might explain what you are seeing and none of your responses do this. What you are saying is that you can definitely see the new grouped data the collection, but the sub-gallery is not refreshing ? If so, I am a bit out of ideas as it should do this.