
Announcements
Hi
I need you help. I have string scanned with barcode scanner: 54586/29807/18/4,5
and i need to split it and add to powerapps collection. columns is splitted by "/"
How I can make it with Match or MatchAll?
Here is one way to make a collection with the transposition of your split string.
ClearCollect(
colTest,
Split("54586/29807/18/4,5", "/");
ClearCollect(colTransposed, AddColumns(Table({}),
"OrderNo", Last(FirstN(colTest,1)).Result,
"SaleNo",Last(FirstN(colTest, 2)).Result,
"Quantity", Last(FirstN(colTest, 3)).Result,
"Weight", Last(FirstN(colTest, 4)).Result))
Regards,
Pat