web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Extracting value from ...

Power Apps

Answered

Extracting value from String

(0) Share

Report

Report

Posted on by jody1213

56

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

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
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 at

Like
a
(1)

Report
Copy link

Link copied!
@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

Join the conversation