Hi @KBilakanti1 ,
today i already got the solution for my problem ^^ . your approach is not what i am looking for maybe because i didnt explain correctly.
Picking your example:
Sample Collection:
Collect(ColItems,{Item:"1.0.0,2.0.0"},{Item:"2.2.2"},{Item:"1.0.0,3.0.0"});
Each item can have one or more values separated by comma. (Value example: '1.0.0')
Each value has one or more levels. (Example with value '1.0.0': Level 1 - '1' ; Level 2 - '0'; Level 3 - '0').
I wanted to be able to search in every value in specific level, so that:
- when i search for '2' in the first level only the the two first items of my collection will appear.
- If i search for '0' in the third level, only the first and last items from my collection will appear.
With this being said. Here the solution i found.
- This is inside an Or().
- "txtPesquisaAssuntos" is my input.
- I´m assuming there is no more than 10 values for each item. So i repeated this code 10 times changing only the index.
For each element of an Item im going to pick up the value of the level that i want to search with a maximum of 10 elements per item.
txtPesquisaAssuntos.Text in Last(
FirstN(
Split(
Last(
FirstN(
Split(
ThisRecord.Item,
","
),
1 //This represents the position of the value, int this case '1.0.0'
)
).Result,
"."
),
Value(ddFilterByWBSLevel.Selected.Value) //This is the DropDown that selects the level where i want to search
)
).Result
An that´s how i´ve done it!
Thanks for the time spent on trying to help me ^^
