This is working for me see below, I know their must be a better way to do this
OverView:
Process
Step 1:
User inputs search criteria in textinput
on select search button:
ClearCollect(MyValues2, Split(TextInput2.Text, Char(10)));
UpdateContext({TimerStartCol:true});
UpdateContext({selfdisable:DisplayMode.Disabled})
-------------------------------------------------------------------------------------------------
step 2: (Hidden)
stores in collection with row number (index)
Gallery Item:
With(
{
RowCollection: MyValues2 // Ensure data is properly assigned
},
ForAll(
Sequence(CountRows(RowCollection)),
Patch(
Last(FirstN(RowCollection, Value)),
{ rowIDNumber: Value }
)
)
)
----------------------------------------------------------------------------------------------------
Step 3: (Hidden)
Look up gallery row number for each individual text label
Text Label1:
LookUp(MultiNHnumber.AllItems, rowIDNumber = 1).Value
Text Label 2:
LookUp(MultiNHnumber.AllItems, rowIDNumber = 2).Value
etc etc.....
side note(i want to avoid this or else have to create many labels)
--------------------------------------------------------------------------------------------------
Step 4 (Hidden)
Filter datasource based off step 3
SP list 1
gallery Item:
Filter(
NETHAllocation,
StartsWith(NHSnumber, Coalesce(NHnum1.Text)) ||
StartsWith(NHSnumber, Coalesce(NHnum2.Text)) ||
StartsWith(NHSnumber, Coalesce(NHnum3.Text))
)
SP List 2
gallery item
Filter(
SWTHAllocation,
StartsWith(NHSnumber, Coalesce(NHnum1.Text)) ||
StartsWith(NHSnumber, Coalesce(NHnum2.Text)) ||
StartsWith(NHSnumber, Coalesce(NHnum3.Text))
)
etc etc.......
------------------------------------------------------------------------------------------------
Side Step: (Hidden)
Timer End:
ClearCollect(colNEgallery, Gallery9.AllItems);
ClearCollect(colSWgallery, Gallery9_1.AllItems);
ClearCollect(colAllGallery, colNEgallery, colSWgallery);
-------------------------------------------------------------------------------------------------
Result
gallery Item:
Thank you 😊