PowerApps Tutorial - PowerApps String Functions for Text Manipulation
HTML-код
- Опубликовано: 2 авг 2024
- In this PowerApps Tutorial, you will learn about the PowerApps String Functions. Often you find yourself needing to manipulate text with PowerApps and this is how you do it. Functions include:
Left, Right, Mid, Find, Replace, Upper, Lower, Proper, StartsWith, EndsWith, and more.
To learn more about PowerApps check out www.PowerApps911.com 
Наука
I love it when your classes bring this level of complexity ... You teach the basics of the function and add with something complex I love it !!
Thank you Shane!
Glad you enjoy it!
Thank you! Just the first few minutes of this helped me solve a knotty issue and saved me from insanity! Really though, this is awesome stuff.
Glad it helped!
Hey Shane! Just want to say thank you for doing these videos! They have been instrumental, especially the ones dealing with complex SharePoint integration or scenarios.
Happy to help. What other SharePoint PowerApps topics could I cover to help you?
@@ShanesCows Oh yeah, one other possible area to cover and still haunts me to this day was patching multiple lists simultaneously via button onselect and including an If statement on whether or not to patch some of the lists (e.g., 3 lists in total) based on specific values. Then customizing the ShowError function to display the results. Thanks again!!
Wow. That would be a lot to juggle. 😀
What a fantastic tutorial Shane.... Many thanks for sharing :)
My pleasure!
Hahahaha, glad I'm not the only one screwing Find syntax over and over again. Cheers for making me feel better.
Thank you for the video. By the way, I'm very interested in hearing about your experience with three halves wholes 15:42 :))
Got to keep you guessing. 😎
Hi Shane, your videos are very good. congratulations.
I hope you can help me with this case, I have a form in power apps, you must enter the texts of personal data of a person in uppercase, always in uppercase, regardless of whether the keyboard is activated this key. Thanks for your answer.
Hey Shane! Love your videos, along with the humour you bring to each one !!! I have a question about Substitute()... I have a simple dropdown with text and that text is the name of a screen. So let's say in the dropdown the labels are Template 1, Template 2, etc. I have screens that are named Template1, Template2, etc. (notice the lack of a space). So, change the dropdown and then navigate to that screen. I have...
Navigate(Substitute(dropDownLabel.SelectedText.Value, " ", ""), BorderStyle.None), but it doesn't recognize the substitute part as a screen. Why doesn't this work?
Gotta love working on something that gives no errors but doesn't work. Would really appreciate any explanation. Thank you so much !!!!!
thank you Shane
Happy to help. Have a great day. 🐶
thankyou Shane! you make everything easy! one question (I always have one!) if I need extract information to create a collection from an html text?? any idea?
This doesn’t ring a bell. Html is just text at the end of the day. So you could split it?
Twenties in love, classic!
😎😍🤩😂
Thanks so much for this video. Is it possible to manipulate text within dropdown selections?
Nope.
Awesome! Do you have a video that shows how to remove the spaces from a text input before patching to a sharepoint.
I don’t. If I had to do that I would probably use substitute but not sure I have had to do this before.
This is AWESOMESAUCE!!! One of the problems that I have run into is that sometimes PowerApps returns data in the wrong format. For instance, if I concatenate a STRING and an INTEGER, it returns a date (12/31/1969 4:00PM), when what I am really expect is "# 15". If I copy the field, it displays correctly. In other cases, it concatenates the second half of my formula, but ignores the first part. Again, if I copy the field, it displays correctly. My users are frustrated and I am out of things to try (Visible, DisplayMode, republishing the app).
What if you wrap the integer in the Text function?
Great Video ,but then everything you produce is very helpful. My issue is that I need to save the number value as a number in the Sharepoint list not Text, is there a way to change the text to a number value in the collection?
Yes use the Value function. Value(“12”) would make the number 12 from the text 12.
hi Shane! nice video. A have a question regarding text and labels: how do you handle carriage return on a label? in the past Char(10) or Char(13) worked but not anymore. And adding a Shift+Enter doesn't always make the trick either, so how do you handle multiple lines of text on a label to be properly displayed?
In a Label Shift + Enter works for me inside the double quotes.
@@ShanesCows you're right on a simple label it works like this, as well as the Char(13) trick. My problem is when I pass the multiline text to a component and use it in a label inside the component.
The only workaround I found is replacing labels with html text inside the component and passing a to have the CR in the multiline text.
Hi Shane, Thanks for sharing such amazing videos.
I want to compare a CDS column (text type) with a String value (e.g. "ABC"). How to do that. When I am trying to filter records based on such scenarios it showing me Delegation warning. How to overcome that?
That should work. Not sure why that would show delegation 🤔
@@ShanesCows I am getting delagation warning in this syntax -
Filter('Registrations', 'Session Id'= RegisteredUserGallery.Selected.Id, Text('Status') Text("Cancelled"))
I am just curious when I try to use text function to assembly my file name with extension.
e.g I claim the code
Set(varFileName, Text(Left(varName, 5) & ".pdf"));
varName is another variable I stored the people name. and I only need first 5 characters of the name.
But the problem is when the output of the VarFileName will become like "Peter.P657" instead of "Peter.pdf" Do you know why? and how to fix it?
Do you have a complex function to deal with case for names like MacDonald, McCafferty, O'Neill, Stith-Jones, de Bordello etc. I sorted the first 4 but then suddenly got presented with the 5th name which I think is near impossible to do in conjunction with the rest
I haven’t ran into this before what is it doing vs what you expect?
@@ShanesCows It is based User error on input. They will spell names in lower or in upper or take names like MacDonalds and do Macdonalds. I tried to look at code to manage this and basically achieved a great deal until I then got names like de'Oleveveri or Macfarland which does not change. Becamm too much for me so put the onus now back on the user
Hi shane, can you make a video on the ismatch function
I'm struggling to verify data that is collected on the app to a multi line text field that was pre filled on sharepoint.
For example. If this item in the gallery collection exists somewhere in the string of the selected dropdown item display Green check, otherwise display red warning sign.
I cant figure it out. there's only about 2 videos in the entire internet on the ismatch function. But they only cover predetermined text like if( ismatch("hello"), green,red)
Can you make a video on how match each 10 character string in a collection to only a piece of a 300 character string from sharepoint? I can't figure it out.
Try out the in operator. That is the key here. 😀
excellent video. Excuse me, is there any way to send a file generated in powerapps directly to print?
There isn’t today. Sorry.
I want to do infinite concatenate the string
how can we achieve that?
Hi! I have a cuestión, which function in PowerApps, can I use to get the system information from an user that it creates an item, like the IP address, operative system, etc. And show them in a label or a gallery. Can you help me with that function ?
Hey Christian. Sorry to say there is not one. Best I can offer is User() to get name and email.
Hi Shane, I’m trying to extract just numbers from a string that contains all kinds of characters. Any suggestions?
Look at the Match functions. Pretty sure they can help you get there or at least that is my best guess.
Shane, Love your videos! I'm a subscriber on powerapps911... I'm looking for format a phone number. Text(ThisItem.PrimaryPhone, "[$-en-US](###) ###-####") isn't working. Do you have a video about this?
Is primary phone a number or text? If it is text then you have to wrap it in the Value(ThisItem.PrimaryPhone)
@@ShanesCows Text. Thank you! You're great!
hi, what's the string for linebreak for Multiline lines textbox? I tried & already
Depends on where you are storing the data sometimes it is Char(13) the ascii code. Other times it can be and sometimes shift+enter works.
You mentioned that you don’t use this for single column tables much. Why?
My scenario has split a barcode.value into a data table. But I’m struggling to get those split values into seperate text inputs to then submit to SharePoint.
Any hints ?
I might adopt your find tutorial if I can figure this one out.
Thanks
Not sure Sam. Hope you got it since I am slow to reply.
@@ShanesCows I got this one sorted with lookups I think :)
Why does powerapps sometimes loses the data saved with savedata even if they have been saved within the same hour?
Never seen it lose data. I would check your code and see if there is a scenario or set of steps that is causing this.
Proper on input people's names ?
Not sure what you mean?
@@ShanesCowsJust as a example for the use of the Proper command. When you are expecting a person's name to be entered into a form. Just my OCD lol