Hello, my Split() has an undetermined number of records. I need to use each of those string/record from Split(), to search and find a matching record in another table, and taking the data from another column.
Here's the code in PowerApps thus far:
Set(testIDstring, "1,2,3")
Set(testID, Split(testIDs, ","))
Set(testValues, ForAll(testID, SortByColumns(Filter(testTable, id = testID))
I'm not too sure how to continue from there on.
I have a code equivalent for better understanding:
testID = [1, 2, 3];
testValues = "";
testID.map((id) => {
testValues += LookUpValue(table, column, id) + ",";
}
The LookUpValue() would be some method that looks up from the column from the table, get a matching record based on the ID, then return the data in the Value column for example.
Also, the variable `testValues` should not be a number, but rather of type string that appends every value from the matching record ID.
Over here, I'm using [1, 2, 3] or "1,2,3" as an example, but as mentioned on top, it could be 1 ID or 10 IDs.
