Named Formulas Gallery Items Question

(0) Share

Report

Posted on by dlprentice

626

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:

Issue

All responses (2)

Answers (0)

dlprentice 626 on at

Like (0)

Report

Re: Named Formulas Gallery Items Question

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.
ShantanuP on at

Like (0)

Report

Re: Named Formulas Gallery Items Question

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);