Answered

Adding a RowNo to an already complicated Items property

(1) Share

Report

Posted on by DCHammer

714 Moderator

@WarrenBelz Since it was your initial brilliance that provided this beautiful logic, I return to you once again for guidance. :D

I made one change to the last version you provided since it was returning an empty row at the top of the gallery occasionally. I added a !IsBlank to the Question and Answer and the gallery is clean now.

Now, for purely asthetic reasons, I'd like to add a RowNo to the Items so I can affect visual elements inside the gallery.

You've helped me do that in the past and I thought maybe I could modify the below to add the sequence and then update the list but can't.

If(
   Len(txtFrmQuestion.Text) > 4,
   With(
      {
         _Items: Filter(
            Split(txtFrmQuestion.Text, " "),
            Len(Value) > 4
         )
      },
      Filter(
         DropColumns(
            GroupBy(
               Ungroup(
                  ForAll(
                     _Items As _I,
                     Filter(
                        colFAQ,
                        _I.Value in Text(Question) || _I.Value in Text(Answer)
                     )
                  ),
                  Value
               ),
               Question,
               Answer,
               Grouped
            ),
            Grouped
         ),
         !IsBlank(Question) && !IsBlank(Answer)
      )
   )
)

Categories:

Using Apps Using Formulas

General Questions

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

MarkRahn 1,125 Super User 2025 Season 2 on at

Like (1)

Report
Adding a RowNo to an already complicated Items property

Hi @DCHammer,

@WarrenBelz helped me out with learning the "With" statement recently. I think this would work:

With( { _Items: Filter( Split( txtFrmQuestion.Text, " " ), Len(Value) > 4 ) }, With( { _FilteredItems: Filter( DropColumns( GroupBy( Ungroup( ForAll( _Items As _I, Filter( colFAQ, _I.Value in Text(Question) || _I.Value in Text(Answer) ) ), Value ), Question, Answer, Grouped ), Grouped ), !IsBlank(Question) && !IsBlank(Answer) ) }, ForAll( Sequence(CountRows(_FilteredItems)), Patch( Last( FirstN( _FilteredItems, Value ) ), {RowNo: Value} ) ) ) )

It is a technique I used in the past that I found on this website:

https://powerapps.co.nz/auckland/index.php/our-blog/41-add-alternating-row-colours-to-power-apps-gallery

If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a Like.

Thanks
-Mark

Was this reply helpful? Yes No
DCHammer 714 Moderator on at

Like (1)

Report

Adding a RowNo to an already complicated Items property

Thank you Mark. That fixed it. I did need to add ID into the GroupBy clause so I had it later but this works and I can show/hide things based on their RowNo.

I had a With statement that did it but the inside of that With was far less complicated than what I had here and couldn't figure out how to modify.

Thank you again.

Darren

Was this reply helpful? Yes No
Verified answer

WarrenBelz 151,881 Most Valuable Professional on at

Like (0)

Report
Adding a RowNo to an already complicated Items property

Hi @DCHammer

Responding as you tagged me - firstly @MarkRahn is correct. The blue bit below will save you a few lines of code ( I wrote a blog on this a few years ago)

If( Len(txtFrmQuestion.Text) > 4, With( { _Items: Filter( Split(txtFrmQuestion.Text, " "), Len(Value) > 4 ) }, With( { _Data: Filter( DropColumns( GroupBy( Ungroup( ForAll( _Items As _I, Filter( colFAQ, _I.Value in Text(Question) || _I.Value in Text(Answer) ) ), Value ), Question, Answer, Grouped ), Grouped ), !IsBlank(Question) && !IsBlank(Answer) ) }, ForAll( Sequence(CountRows(_Data)), Patch( Index( _Data, Value ), {RowNo: Value} ) ) ) ) )

Was this reply helpful? Yes No