web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Grab specific text fro...

Power Apps

Answered

Grab specific text from text input to another textinput

(0) Share

Report

Report

Posted on by Appsforourlife

67

Hi PowerApps experts,

I am trying to create my app as illustated in the attached picture from my gallary.

I really need your help with writing functions in the white colored textinput boxes to grab from the above long string "HS83582 00410040" the first on the left will grab the fisrt 6 craracters after "H" = S83582 and second text input will grab the firt 3 charactars after the the space = 004 and last one to grab the followed 4 charactars = 1004, the last charactar is not wanted.

Given by the three white colored boxes are column in a sharepoint list.

I appreciate a ot your help 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Appsforourlife,

Are the values in the TextInput controls currently hardcoded and you wish to change these to functions instead? The code below should do the trick. 😊

//Left TextInput Text property Mid( //Label1 refers to the control containing the full string value Label1.Text, //Find the index of H and add 1 to exclude H in the output Find("H",Label2.Text) + 1, //Return the next 6 characters 6 ) //Middle TextInput Text property Mid( //See comment in code block above Label1.Text, //Find the index of the first space & add 1 to exclude the space Find(" ",Label2.Text) + 1, //Return the next 3 characters 3 ) //Right TextInput Text property Mid( //See above Label1.Text, //Find the index of the middle TextInput value (change name) & skip those characters (+3) Find(MiddleTextInput.Text,Label2.Text) + 3, //Return the next 4 characters 4 )

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No
Appsforourlife 67 on at

Like (1)

Report
Copy link

Link copied!

Hi @LaurensM

Thank you for the help, It works very well, I am so happy 🙂 thank you again!

Was this reply helpful? Yes No

Join the conversation