PowerApps String Manipulation

[@Foss3]

Thanks Shane, I can always count on you

[@ShanesCows]

Any time!

[@abberantgeck0]

I know this video has been around a long time, but it's great! Way to go Shane!

[@borisayissi2945]

Thank you greatly Sir. It was of a great help to me. Keep the good job up

[@dildgemckenzie8597]

Another great informative video. Thanks for sharing Shane.

[@ShanesCows]

You are welcome. This is a great set of skills to develop.

[@olabodeoluwagbemiga8661]

Very helpful. Thank you.

[@ShanesCows]

You are welcome, this was one of my favorite videos. 😎😎

[@TheMKTube]

This is amazing thank you. How about extracting just numbers from a string that contains all kinds of characters? Is there a function to get just numbers

[@ShanesCows]

I had never done it before but I was curious. I think this does what you want. :) Concat(MatchAll("T1M23333ex1212","\d"), FullMatch) T1M23333ex1212 is my string I was pulling from. :) It returned only the numbers.

[@TheMKTube]

@@ShanesCows Thanks Shane! 🙏You rock

[@jesus.moreno]

Thank you Shane ... I really appreciate all your videos ... I'm learning a lot ... regards from PERU

[@ShanesCows]

Awesome. Thank you!

[@jesus.moreno]

Shane Goog Evening ... I sent you en email ... I'm stock in a small issue. After a lot of hours I can;t get it right ... on my first Powerapp. My email is [e-mail] ..I hope you can help me .... Thank you!!!!!!!!!

[@JamesGuarin]

gracias muy buenos videos

[@ShanesCows]

Thanks 😊

[@gerardosalazar2351]

Awesome as always!

[@ShanesCows]

THANKS!

[@tausifjamkhandi1597]

Was eagerly waiting for ur new vdo, and as always this was very informative and helpful, thank you so much shane

[@ShanesCows]

You are welcome. Sorry for the delay. Been super busy.

[@bertoso]

Você é o melhor, valeu Shane! (you are the best, thank you very much)

[@ShanesCows]

Very kind of you. Thanks!

[@ambujaable]

Thanks Shane :) very informative !

[@ShanesCows]

You are welcome

[@GioraMeisler]

Hi Shane, thanks once more for a great tutorial. Is there a way to reverse words order in a string, without reversing the letters order within the words themselfs?

[@ShanesCows]

Probably. You would have to crate the logic but should be possible. Think about breaking on the space and building string from the letters between the spaces.

[@carlilelance]

split() on the space character, put it in a table, create another table, pull the table values out in reverse order and put them into the second table (this is the hardest part), concat() back to single string.

[@threewiseman1]

Hi Shane, I'm wondering if I could use any combination of these to create a word count for a multiple lines text field? The obvious way to do this would be to "find all spaces" and count them, but I can't see any way to "Find All" in the documentation, it seems I can only find the first match from a location - as in this tutorial video. The Substitute function is awesome, btw, and will solve a different problem I was having.

[@ShanesCows]

Try it another way. Split the string on the space. This will create a table and you can count the rows for your word count

[@threewiseman1]

@@ShanesCows Thanks Shane! I actually figured this one out by co-opting an excel formula I found in a post way back when! Len(InsertMultilineDataCard.Text)-Len(Substitute(InsertMultilineDataCard.Text, " ", ""))+1 This formula subtracts the full string of text without spaces (The part where is substitutes " " for ""), from the full string of text with spaces. The difference between the two numbers gives you the word count...almost. I needed to add +1 because there is always one more word than there is spaces. Pretty nifty!

[@danieljakobsen2861]

Hey Shane. This may be off topic, but i was wondering if it's possible to place a countdown timer in a gallery - and starting the countdown timer without affecting the different rows in the gallery? Been having difficulty activating one specific timer countdown in the gallery independently from the rest of the gallery timers. Hope you can help!

[@ShanesCows]

I don’t exactly follow what you are trying to do?

[@viceilho5247]

Hi Shane thanks for the tips! But this formula only works with text right? As I’ve tried to convert to value then the result returns as blank with no formula error. I’m pulling my hair now...

[@viceilho5247]

Silly me! I didn’t define the expectation for false value!

[@ShanesCows]

Glad you got it working. 🤩

[@jwvicho]

Hi Shane Young, I’m finding values for 3 different calculated fields which has 2 decimals My formula is Right(field1.Text, Find(“.”, field1)) The Right & Find functions are working for field1 & field2 which return 2 digits numbers But not working for field3. field3 returns “.78” instead of just 2 digits numbers. How come behaviours are different?

[@RachaelTheBlonde]

Hello Shane. I was wondering if you would be able to help with an issue unrelated to strings. My company is using the newest version of the Common Data Service as our database to build PowerApps from. We would love to use the custom themes feature, but when we look at the system themes they are all in read-only. I cannot create a new theme, and when I copy a system theme it does show up as a new custom theme but still it is read-only. None of the fields can be edited. I know this is a rather new feature, but do you have any suggestions? At this point we are opening a ticket with Microsoft.

[@ShanesCows]

Hi Rachael - I haven’t used that feature yet. Sorry. Please let me know what you find out.

[@kogzera]

Hi Shane nice work. is there any way I can do this in a Radio? For example where it would take each item in a Sharepoint field and read each item up to the ";" so it would stay in each radio field until it found a ";" and go to the next field ?

[@rosshill5314]

Great video thanks Shane - is there a way to replace a string using something similar to wildcards. The string I want to manipulate appears multiple times in the overall text. It always starts/ends with the same text and is always the same length, but the Mid varies. Using Mid only seems to replace the first occurrence.

[@ShanesCows]

Ross I am not sure. I guess you could nest them? I haven't done this before.

[@rosshill5314]

@@ShanesCows Nesting works and a little creative HTML to 'hide' parts I don't want to appear in the final text - thanks!

[@vineetarai2088]

Hi Shan, it's very informative video,when I am using share point list and I have store the value of month and year(concatenate) in one single line text field .When trying to use Left(monthyear,find(" ",Month year)) and show on default property of drop down list .So it's not give the result and on drop down list, I have used calender.monthlong().Please suggest.

[@ShanesCows]

That is tough. Use addcolumn function to create a new column with the output of your string function

[@vineetarai2088]

@@ShanesCows Thanku so much Shane.

[@bradhunnings5428]

Hi Shane! Is there a way to use a technique similar to this to use formatting (bold, underline, font color, etc) in parts of strings? Example: Have a search text box and change the font color of a string only where the text matches what's in the search text box...

[@ShanesCows]

You would have to use the HTML control if you want to format the text like that

[@sivajibandaru]

Hi Shane, Is there any way to convert to string(36). Thanks in advance Sivaji

[@ShanesCows]

Not that I know of

[@ersulaigori9177]

Hi Shane. I was watching this video in hopes to gain insight into how to manipulate strings in Microsoft flow. Flow only has the split and replace function but I can’t get it to work and there’s not much information out there to help. Can you do a video on how to use split and replace in Flow? Flow doesn’t have Left, Mid and Right functions. I am trying to take an email with appointment meeting details and extract the date/time out of the email’s message body. Then, with the date/time in a string, create a calendar invite in outlook. :)

[@williamsneddon6937]

Hi Shane, Fantastic video, is there a way to use the replace or other option to remove all spaces, this would be for creating an Email Alias, i.e. Test Mailbox One to TestMailBoxOne

[@ShanesCows]

The substitute fucntion does just this docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-replace-substitute

[@BorisBrenner]

Hello Shane, once again a very interesting and practical video. Regarding your problem, wouldn't this be an alternative? (In this example I extract the second sentence, and because the "." is stripped out, I added it again) Last(FirstN(Split(TextInput3.Text; "."); 2)).Result & "."

[@ShanesCows]

I like it. 😎

[@Thorkyn]

Hi Shane, thanks a lot for your videos, it help me really. But i have a problem! I have a gallery with sql for data. I need to concatenate this gallery to a string. I have tried Forall(...;set(string; string & columns)), but i can't... Help! :)

[@ShanesCows]

This video talks more about Concat which is probably your best bet. kzbin.info/www/bejne/d5-og5l9fqprndk

[@whoodiniiam]

shane is there sucha thing like powerapp macros i have to move from infopath and it willsuck

[@ShanesCows]

Can you give me an example of what the macro did in InfoPath?

[@whoodiniiam]

naaah no i didnt have a macro there but as i was making my infopath forms i was thinking it would be nice if i could be spared a lot work by use of macros maybe its successor....I would also see it come in handy coz i have big form with a lot of text boxes that i would like to do them all manually

[@daFrimpster]

How would you apply these functions to a global variable value?

[@nandocalix23]

Uppercase?

[@ShanesCows]

Upper function

[@Bence24Videos]

PowerApps is pretty nice, but seeing this makes me cringe. You could do any of these operations with a few lines of code in any programming language. Also, if you can wrap your head around this, then you can wrap your head around a for loop..

[@ShanesCows]

I would take the opposite point of view. Why would you write C# or some other code if you can do all of this with Excel like formulas and prebuilt controls? To each their own but I like PowerApps.

[@Bence24Videos]

​@@ShanesCows That is fair. It's probably just that I'm used to programming, using variables and trying to produce neat looking code. Also, thank you for these tutorial videos! You deserve more subscribers.

[@FullNappy]

It is unbelievably cumbersome to have to do this technique. If you have hundreds of sentences, this approach just isn't useful. I am amazed there isn't a more succinct way of doing this.