Unanswered

Named Formulas Gallery Items Question

(0) Share

Report

Posted on by dlprentice

628

I've noticed that when I setup a named formula to filter a datasource then set a gallerie's Items to said datasource that the named formula is not invoked...

Example

NamedFormula = Sort(Filter(DataSource, Item.GUID = OtherNamedFormula.GUID, 'Created On', Ascending);

If I plug in NamedFormula to a gallery it simply "won't invoke" for a lack of a better way of saying it.

My question is, am I using named formulas incorrectly or should this work?

Categories:

Experimental features

I have the same question (0)

All responses (2)

Answers (0)

ShantanuP on at

Like (0)

Report

Does this expression work if you use it on gallery without using NamedFormula?

For example,

Gallery.Items = Sort(Filter(DataSource, Item.GUID = <OtherNamedFormulaExpression>.GUID, 'Created On', Ascending);

Was this reply helpful? Yes No
dlprentice 628 on at

Like (0)

Report

Yes, perfectly.

I did a bit of messing around and so the initial gallery items load but if I try to patch or formsubmit data then updates aren't displayed when using the named formula (even a datasource refresh doesn't work). Hopefully this makes sense, works on app load, but updates aren't reflected if using the named formula.

Think: Adding or updating records in the target datasource. When the items property of the gallery is a named formula in this case, changes to the datasource are not reflected in the gallery items output.

Was this reply helpful? Yes No