Answered

Adding 2 (unrelated) formulas to a Gallery

(0) Share

Report

Posted on by sweetpickleduck

Hi, I've got a gallery set up which has 6 columns and about 100 rows. I want it to do 2 things: Every other row should have a background colour so it's easier to distinguish, and I want to place filters on it.

For the background colour thing I'm using the following formula:

ForAll(Sequence(CountRows('SharePoint File')), Patch(Last(FirstN('SharePoint File', Value)), {rowNumber:Value}))))

It gives each row a number, then in TemplateFill I use an if statement to give even numbers a different background colour.

For the filter I use the following formula:

Filter('SharePoint File', Country.Value = DropdownCountry.Selected.Value || DropdownCountry.Selected.Value = Blank(),
 Sector.Value = DropdownSector.Selected.Value || DropdownSector.Selected.Value = Blank())

When I use each of these formulas alone there's no problem, it works. But if I try to combine them with a semicolon in between, the whole DataGallery goes away. Can anyone explain to me how (if) I can use both of these unrelated formulas so that I can have the layout I want plus the filters?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @sweetpickleduck,

You would use the Filter() statement as your datasource / input in the Row Number code. To avoid code repetition I would suggest using a With() function to store the Filter output in a function variable and reference that variable as the datasource. Inline comments are added to the code to further explain the functionality. 😊

With( { //Save the Filter output to the function variable 'wFilter' wFilter: Filter( 'SharePoint File', Country.Value = DropdownCountry.Selected.Value || DropdownCountry.Selected.Value = Blank(), Sector.Value = DropdownSector.Selected.Value || DropdownSector.Selected.Value = Blank() ) }, //Add row numbers for alternating TemplateFill colors ForAll( Sequence( //wFilter servers as the input CountRows(wFilter) ), Patch( //wFilter servers as the input - Index is preferred over Last(FirstN()) Index(wFilter, Value), {rowNumber:Value} ) ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
sweetpickleduck 21 on at

Like
a
(0)

Report
Copy link

Link copied!

It worked! Thank you so much!

Was this reply helpful? Yes No