Good day beautiful people,
My goal:
With textinput field I would like to be able to search for multiple words within the single string.
What I have:
I have SP list with multiple columns, e.g:
| User1 | Skill1 Skill2 Skill3 | Name1 Name2 | Lorem1 | Ipsum2 |
| User2 | Skill2 Skill4 Skill5 | Name2 Name3 | Lorem1 Lorem2 | Ipsum3 Ipsum4 |
Which was transformed to my gallery with additional column: "HelperConcatenate", which is concatenation of all above (without User).
What I tried:
I was thinking of creating a collection with a user name and all of these mentioned words, which I did with this formula:
ClearCollect(
CollectionConcatenate,
ForAll(
Gallery2.AllItems,
ForAll(
Split(ThisRecord.HelperConcatenate.Text, " "),
{
CollectionConcatenate: Value,
CollectionName: HelperName.Text
}
)
)
)
Which created multiple nested tables in my collection, e.g:
| User1 | Skill1 |
| User1 | Skill2 |
| User1 | Skill3 |
| User1 | Name1 |
| User1 | Name2 |
| User1 | Lorem1 |
| User1 | Ipsum2 |
Each user got it's own nested table, so for now I have approx. 15 items.
Where I am lost:
Now this is the part where I am stuck. I have 15 nested tables within the collection and I don't know how can I check if a word(s) appears in any of these. I know that this will be created with a button "search" because I don't think this is possible to be dynamic, but I'm fine with that. How can I search words from textinput in all nested tables in my collection and return user names where such word(s) were found?
In my scenario if someone types:
Skill2 Name2 Name3 it should show both User1 and User2 since they both have common words.
Skill1 Ipsum2 it should show just User1.
