I am trying to split the contents of a text input field using the following formula: Split(TextInput2.Text,"-"). This is generating an "Expected Text Value" error. I have tried multiple way to attempt to convert the table value to text to no avail. Any help anyone can provide would be much appreciated!
Solved! Go to Solution.
The result of a Split() is a Table. Are you trying to display this split in a label or some other type of textbox? If so you need to get the first or last value like this:
First(Split(TextInput2.Text,"-")) or Last(Split(TextInput2.Text,"-"))
Is this what you want to show?
OK. We're making progress! Thanks so much for the help. Using this formula (Concat(Split(Text(TextInput2_1.Text),"-"), Result & Char(13))) I am able to split the text POE-DGI and getting both values in the text label as:
Now I need to get the last value.
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.