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