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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

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

Like (0)

Report
Copy link

Link copied!

@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
Copy link

Link copied!
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
Copy link

Link copied!

@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