I have a string 2,3.14 and I can split it and then do a lookup and then concat it to get the labels from each value based on a Lookup. I have done it as a 3 step process. I need to combine this into a single step and plan to do this for each row in a collection. This example is just starting with a singular string for ease of demonstration.
The initial input default text is
"2,3,14,"
The Split button on select does this...creating a collection
ClearCollect(Test,Filter(Split(TextInput2.Text,",").Result,!IsBlank(Result)))
The GetLookUp Button adds the Label for each row...and creates a local var of the concatenated Label
ClearCollect(
Test2,
AddColumns(
Test,
"Label",
LookUp(
ListDictionary,
ID = Value(Result),
Title
)
)
);
UpdateContext({Final: Concat(Test2,Label&", ")})
Where the label text value is simply
Final
rendering the output desired of ...Active, Passed, Failed,
Brilliant...
But how do I do this with the least amount of code when trying to do this with all the rows in a collection...as you can see here the region and the countries have these types of strings that all need to be "translated". The gallery is using a collection that is being created on the "onVisible" property for the page.
