Answered

Filtering Gallery disabling subtitle customization?

(0) Share

Report

Posted on by Murphys110

My exhaustive searching has so far been in vain, hoping someone here can help..

I have a gallery that is filtered using the following code in Items:

Distinct(Sort(Filter(AccountList, SALESPERSON = AELabelDD.SelectedText.Value && Prospect = TypeLabelDD.SelectedText.Value),Advertiser),Advertiser)

This works fine, but within the gallery, where normally I can customize a title or subtitle TEXT with ThisItem.Column the only thing it accepts is ThisItem.Value. In this particular case that Value is "Advertiser".

Is there a way to add the other column name into the gallery ITEMS box so it is available? Not familiar with the syntax for that.

Any help is greatly appreciated!

Categories:

General Questions

All responses (3)

Answers (1)

Murphys110 on at

Like (0)

Report

Re: Filtering Gallery disabling subtitle customization?

@Amik that worked! Thank you! I'd actually tried that previously, but the red Xs showed up and I didn't take the time to see if I could update the text field...
Thanks!!
Murphys110 on at

Like (0)

Report
Re: Filtering Gallery disabling subtitle customization?

Ah...... in this case Distinct isn't necessary... would this be the correct syntax if removing it? Thank you!
Sort(Filter(AccountList, SALESPERSON = AELabelDD.SelectedText.Value && Prospect = TypeLabelDD.SelectedText.Value),Advertiser)
Verified answer

Ami K 15,665 Super User 2024 Season 1 on at

Like (0)

Report

Re: Filtering Gallery disabling subtitle customization?

@Murphys110 - the Distinct function will return a single column table called "Value". This column only will contain distinct values of the "Advertiser" column with any duplicate values removed.

Could share more context of what you're expecting your Gallery to show?