Unanswered

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

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

Like (0)

Report

@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?

Was this reply helpful? Yes No
Murphys110 on at

Like (0)

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

Was this reply helpful? Yes No
Murphys110 on at

Like (0)

Report

@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!!

Was this reply helpful? Yes No