Answered

Extracting value from String

(0) Share

Report

Posted on by jody1213

Hello,

In PowerApps, I am trying to extract values from a single line of text column.

The text column holds values similar to:

ABC^100,CDE^90,FGHIJK^85

My goal is, given a Text input variable for example: "CDE"
return the value "90"

Not all values in the column will have the same character length.

Any help would be greatly appreciated.

Thanks

All responses (2)

Answers (1)

jody1213 56 on at

Like (1)

Report
Re: Extracting value from String

@SpongYe

Thanks for the response! Your solution worked! The only issue I had was that the Index Function throws a warning if the table I am using the formula in, is empty.

However, I was able to use this formula below to get it to work without the warning messages:

First(Split(Last(Split(ColumnValues,TextInput.Text&"^")).Value,",")).Value)

Thanks again!
Verified answer

SpongYe 5,580 Super User 2025 Season 1 on at

Like (0)

Report
Re: Extracting value from String

Hi @jody1213

I got it working for you:

Index( Split( LookUp( Split(Label1.Text, ","), // split string with comma StartsWith(Value, varText) // search for a variable text in Split table ).Value, "^" // split the found text in to 2 records ), 2 // select the second row in the table ).Value

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻