//Need to get the mid point of array. Use Floor because we always want to round down. $mid = floor($count/2); //If there are an even amount of elements... if (($count ...

Once PowerApps receives the text string, all that remains is to parse the string back into an array using the Split() function and AddColumns ... you may still do so from SMSS or your SQL manager of ...