Extracting value from String

Like (0) Share

Report

Posted on 25 Oct 2023 17:26:32 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

I have the same question (0)

Summarized by AI

All responses (2)

Answers (1)

Verified answer

SpongYe 5,603 Super User 2025 Season 2 on 25 Oct 2023 at 18:40:48

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! 🍻

Was this reply helpful? Yes No
jody1213 56 on 25 Oct 2023 at 19:01:33

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!

Was this reply helpful? Yes No