Unanswered

How to use a Named Formula to refresh a Collection?

(0) Share

Report

Posted on by BEJONES

I've got a Collection that is currently created in OnStart, but that can be refreshed by the user clicking a button or a refresh icon. So I've currently got the ClearCollect() formula populated in 3 different places, and it's gotten a bit complex as it uses Filter() and AddColumns() and some other logic.

I'd like to NOT need to maintain this same logic behind 3 different controls (App.OnStart, Button.OnSelect, and Icon.OnSelect). I was hoping that Named Formulas would work for me. I've enabled the feature, put the logic into there as

RefreshTestCollection = <copied logic>;
RefreshProdCollection = <copied logic>

But now I cannot for the life of me figure out how to execute those formules in OnStart and behind the button/icon controls. Any help is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@BEJONES

For other users, who want to use Named Formulas, they have to be activated in the Settings as it is not on by default.

Then it will appear in the Apps dropdown on the left side of the screen.

Your formulas don't require an imperative like OnSelect any more. They are declarative and you can just use the alias in your app. They recalculate like formulas in Excel.

Was this reply helpful? Yes No
BEJONES 15 on at

Like (0)

Report

Yes, I've done that. I've got the Named Formula property visible and put in the formulas.

Now I can't figure out the syntax to execute those formulas as they're just ClearCollect() functions - they don't return any result aside from the populated Collection

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@BEJONES

Please see the changes I made above and take a look at this blog post. Basically you use the formulas instead of global variables and collections.

https://michelcarlo.com/2022/09/22/how-to-use-power-apps-named-formulas-experimental-feature/

Was this reply helpful? Yes No
BEJONES 15 on at

Like (0)

Report
Yeah. Read that blog.

Basically in Formulas I have something like this (more complex, but same idea):

RefreshProdCollection = ClearCollect(prodCollection,Filter(productionDataTable,Status=Status.productionDataTable.Active))

Now in my Refresh icon, I want to do something like

RefreshProdCollection; or RefreshProdCollection();

and have it execute that ClearCollect in the named Formula.

Was this reply helpful? Yes No
leonsig93 229 on at

Like (2)

Report
I've been using them quite a lot, really helps cut down on how many ClearCollects you need to add around your app.
Just need to remove the ClearCollect piece, so:
YourNamedFormulaName = Filter( productionDataTable, Status=Status.productionDataTable.Active )
Then your refresh button's OnSelect just becomes:
Refresh(productionDataTable).

Hope that helps!

Was this reply helpful? Yes No
TB-13091842-0 140 on at

Like (0)

Report

I'm fairly new to named formulas, but my understanding is that they're for, in essence, constants. I wouldn't name one to the string to be used in a Refresh button; instead, I think you can just write the collection definition in all its complexity once. The normal function would be:

ClearCollect(Collection, [criteria])

where the criteria part has all your Filter() and AddColumns() statements. So just write your formula as:

Collection = [criteria]

Now, whenever the data on which the Collection is based changes, the Collection changes, automatically and without the need for a Refresh action.

Was this reply helpful? Yes No
leonsig93 229 on at

Like (0)

Report

Have you tested that out? I thought collections would always be static with that approach since you are never running the actual Collect part of that function more than once. That's why I used the refresh version thinking the collection would never update otherwise.

Misread your reply. We currently use them in that fashion, the issue seems to be that the formula's won't auto update unless actions are taken within that user's session. For example, if I submit a new item via a form, User #2 doesn't see it in their "Today's Submissions" gallery. So we added the manual refresh button to make sure the users could have a way of forcing the refresh.

Was this reply helpful? Yes No
TB-13091842-0 140 on at

Like (0)

Report

Yes. I already had a collection based on underlying data. I made a TestCollection whose criteria statement was just ShowColumns(MainCollection, "ColumnName"). A gallery showed the TestCollection, and when I changed the underlying data and the TestCollection changed appropriately. It's the definition of the collection in App.Formulas that's static, not the content. (But, again, I'm speaking as an amateur. I don't guarantee this, but would love to hear if further testing doesn't bear it out.)

Was this reply helpful? Yes No
TB-13091842-0 140 on at

Like (0)

Report

Ah, yes, I see your issue. And yes, I see how that case would need the refresh.

Was this reply helpful? Yes No
Toltekrom on at

Like (1)

Report

This topic was not "SOLVED" correct? I am having trouble just using formulas at all. I set the formula to replace a collection of distinct records, but the formula is empty when I add a listbox.
Also, I cannot Refresh(Formula)

Was this reply helpful? Yes No