Friday Functions | String manipulation: split(), indexOf(), and substring()

Excellent

Great video! I found it looking for instructions to change 10-digit number to phone number format like (###)-###-####. Do you have a video that has any such instructions to format the number with an expression? 😀

This is easily the best job of explaining this I've heard ANYWHERE online, full stop. Fantastic video, Audrie - I followed along and made a couple of these that I'm actively using. What I need to learn next is how to parse multiple bits of text from an email. Unsure if it's a matter of repeating a few actions in series or nesting expressions within one another. More tinkering! :)

very helpful

The good book says seek and ye shall find. I found a sister teaching what I need help with 👌🏾

I've learned more about flows from this video, than hours of Power Users cases. Simply awesome!

Great Video
I have a question about if im using code to grab a date time how can i trim off what i need if i dont know the exact number as all months are different and the chars i need will change based on the date coming in. Here is what i am using now. substring(triggerBody()?['body'],add(indexOf(triggerBody()?['body'],'Follow Up Time:'),21),25). This will work for September but not October I need to be dynamic and get rid of Chars after the am or pm.
Any help is much appreciated.

Hi I'd like to add all array values in separated rows of an excel table, could yo please advise how to achieve this?

What if the variable you are trying to get is never a specified amount? How would you get that? For instance I am receiving a email with a
"Title: Example Title
URL: exampleURL"
I just want to get the actual title and URL.
Thanks in advance!

The level of clarity on this lady explanation is SAVAGE.

What if you didn't know the length you just wanted to get all the text to the last " in a line. How would you put that in the substring?

OMG Thank you so much for this video! I was looking for this explanation about how to split using whitespaces separator. On the internet anyone could help me. So thank you, you are the best!

Excellent. Clear examples, just what i was looking for. Thanks

Thank you for this. Super helpful!

@Audrie.... please make part two. We need you!

This was soooooo helpful. I have question for you. I havea Microsoft Form with a very long list of questions(approx 20 questions. Some questions are yes/no and others are text based. Because of its length I would like to exclude any questions that are answered with no or left blank. Could please provide some direction?

absolutely the best video i have come across! I could build a very complex flow within a day because of your tutorial. Thank you so so much Audrie :)

Hi Audrie,  I'm having an issue with using the split, it returns an extra empty value. I'm gettiing my data from a multiple person field. I'm trying to isolate each person.

Hello Audrie, tricky principals explained with great clarity. Thank you. Have a great weekend.

Hi Audrie, my que is on PowerApss. how to filter Power apps gallery using two multiselect combobox?
here SharePoint list column is multiselect lookups at backend.