Thank you, Shane. I have built a bunch of flows with parsing out strings and I have always (painfully) figured out the length. I was blown away that omitting the length gives you the rest of the string... pause... I love how flippant you were when you said, "flow actually figured it out" and "it was optional"!! Thanks again!!
Excellent video Shane!! Compose and labels are my comfort blankets...it just makes things easier to see at dev/testing stages. Keep up the great work 👍 👏
12:05 - "Flow was smart enough to do something" 😂 18:00 - fight with keyboard 😂 I'm not sure if I watch your vids for the amount of fun or useful content! But seriously, this is awesome and lots of awesome tips in the Compose box to use here! Thank you 😊
Thank you, Shane. Sometimes we're in a rush and we forget using the Compose action to 'probe' into our data and results. I always watch your videos, so many good tips to improve my flow skills... Please, make a video about how to upload and download data massively to Oakdale PowerApps, I've been working with Ms. Flow to do that but I still find it difficult... If only Oakdale had the same interfaces as CDS... I guess we can't get everything included in the basic license :(
Hey Shane, I'm trying to export data from a SharePoint List to a csv file using the create csv table action. The data in the csv table currently looks like this: 140697, 2022, 046, WK3, 20, 1-500 Below is what I want the data to look like: "140697", "2022", "046", "WK3", 20, "1-500" All of the columns should have double quotes around them except for the 2nd to last column
Hey Shane, That is a great session, thank you! I have a question, how to replace the name positions? For example Chewy Young to Young, Chewy (adding comma) Thank you! :)
Is replace new? Discovered it recently and used it to inject data into an html template that I used to generate PDF reports/coversheets for a ticketing system I built. Couple that with the media conversion service in the sharepoint api and you can build some fancy looking stuff!
Hi Shane, Your videos are really awesome and helped me alot. I'm wondering if you could give me a quick answer to this. If I have a string (that's meant to be a date) eg 04/04/2022 How do I find the MM value dynamically? How do I find the YYYY value dynamically? I've worked out how to find the index for both of the "/" but I don't know how to get values I want. My issue is also that sometimes my "date" string varies, eg it might be 4/4/22 next time and everything breaks! Hope that makes sense.
Hello Shane, first I want to thank you for your content which has served me a lot, since it is very clear, didactic and fun.;). I have a question where I hope you can guide me. In Power Automate, you can run a flow that "detects the files you select" in one sharepoint library and copies them to another. Again thank you and stay tuned for your genius...;)
Hey Robert. I think this is possible but I haven’t done it before. In flow you can get file content and you can creat file so seems good. How would the user select which files though? Maybe like this? ua-cam.com/video/QcWjAt7QVn4/v-deo.html
Hello Shane, how do you remove double quotes in a string? For example, if the string is this: Then he stated, "We don't need any of this". How would I remove the quotes in this statement. Thanks for your help.
Tristan I would think you would Replace(' "YOur string" ', '"', '') Replace(' "YOur string" ',singlequote double quote single quote, single quote single quote)
Hello, I am looking to manipulate excel data files using a flow- For example- Flow to pick the file in SharePoint > manipulate the data in the file (remove columns, filtering) and load the cleanse data into a new file? Is this possible and if so do you have video that you done on this?
I have done all of that but this will at least get you as far as I have been. Microsoft Flow Excel Online Connector - Dynamic files 😮, odata, pagination and more ua-cam.com/video/QcWjAt7QVn4/v-deo.html dynamic tablea
Hi Shane, Suppose I've a string, in which there are a lot of words "and" and I want to replace all of them with the symbol "&". Which function do I need to use and how? eg, Old String - "The sun was shining, and the birds were singing, and the flowers bloomed, and the world seemed full of life." New String - "The sun was shining, & the birds were singing, & the flowers bloomed, & the world seemed full of life." Could you please help me.
I am trying to learn how to deal with a null value being written to a dataverse column that is date/time. My flow works when a date is supplied, but if it is null, the write step fails because I am trying to write a null to a date/time field. How can I conditionally update a column/field when I am adding the row?
Nice tutorial Shane, kindly help me with this I have set up a flow that from my outlook the .csv attachment will be saved to my onedrive I end up having multiple attachments with the same report. now, how can I make a flow that every time my outlook save the attachment to my onedrive it will rename the file and replace the existing one.
Hi Shane, Great video… Can you advise. I am trying to remove a line, that contains yy , it could be on different lines in other files. I can replace yy with ‘’ but it leaves a CR LF , ideally I would just like to remove the line completely
yy
from my filecontent, but there are line above and below that i want to keep Any help would be great
Hi Shane, Thanks for nice video(s), just wondering how to replace the arrey value on [{"System":"OPS"},{"System":"OS"},{"System":"Win"}] on Approval action, when I user HTML table it shows data nicely when I added them to approve action it looks like above format. Should I use replace to remove [{ }:",] ? thanks
Your videos are great...please do one on adding list items inside a folder using power automate. I can't get it to work to save my life. I've trying to create an onboarding flow, where each new employee has their own folder and can't see any other employees folder content. I need to create a checklist in each new folder. Please help.
I have a question: Is it possible to remove comma from a number value and convert that decimal number to whole number in power automate platform. For example: I want to convert 1,27.89 to 128. Here I want to remove comma after 1,2XXX and covert the decimal number 127.89 to 128. Please help
Nice video! Can i to do an expression for to get the id of te user at e-mail body and to do parsing to my sharepoint list? example: b8te98 is Paul Olivier.
Hello Shane. I am struggling with Date values. I am importing data values from Excel to Sharepoint. I get an error that Date field has to be a String type but in excel it is a Date type. How do I do it in Flow to convert the Date to String
Hi Shane...pls help us out if there is any function in powerautomate to display the data with or display in new line ' '...we had a requirement of displaying SharePoint column data in email body of ms flow,. It is multi line text field and the data will is in semicolon separated..same need to display in new lines or line break after semicolon
How do you parse a response from a MS Form that is entered like this? •Sunday •Monday •Tuesday •Wednesday The flow sends an email and looks like this: •Sunday •Monday •Tuesday •Wednesday How do we format in flow to look like this in the email? •Sunday •Monday •Tuesday •Wednesday
Is there a way to remove whitespace from inside a string? I have a string that contains "lastname, firstname", but I need to remove the space after the comma to use the Office365 Users action in flow. Otherwise, the user cannot be found.
howdy Neighbour! i cant believe our " Mr. Solution to everything Power Apps" lives next door! if it was possible to get a similar video on how to convert SharePoint list to text file. i created an App to collect covid survey data and we need this data to be attached to our Scheduling software (legacy systems - of cause) through middleware - i need SharePoint list in txt format. is it possible without million steps like this?
Thank you, Shane. I have built a bunch of flows with parsing out strings and I have always (painfully) figured out the length. I was blown away that omitting the length gives you the rest of the string... pause... I love how flippant you were when you said, "flow actually figured it out" and "it was optional"!! Thanks again!!
Flow exhausts me sometimes 😀
You are just awesome.. I have learned so much from you, clear concise, and fun! Thanks for doing what you do!!
You are welcome Andrew! Have a great day. 🐶
Great Shane BOY you are THE GUY!
Thanks!
Excellent video Shane!!
Compose and labels are my comfort blankets...it just makes things easier to see at dev/testing stages.
Keep up the great work 👍 👏
Well said! Loves those two also. 😍
You are awesome. Explained the functions very clearly
This helped me so much.
Thank you.
Glad to help. 😀
Great video Shane.
Thank you. :)
12:05 - "Flow was smart enough to do something" 😂
18:00 - fight with keyboard 😂
I'm not sure if I watch your vids for the amount of fun or useful content!
But seriously, this is awesome and lots of awesome tips in the Compose box to use here! Thank you 😊
Flow and i’s relationship is complicated 😂
Hi Shane, next time you face the pop-up help, you could try using the Esc-key.
Thanks for the tip. It just drives me bonkers. 😳
Thank you, Shane. Sometimes we're in a rush and we forget using the Compose action to 'probe' into our data and results. I always watch your videos, so many good tips to improve my flow skills... Please, make a video about how to upload and download data massively to Oakdale PowerApps, I've been working with Ms. Flow to do that but I still find it difficult... If only Oakdale had the same interfaces as CDS... I guess we can't get everything included in the basic license :(
Fernando I still think we will see more data import capabilities when Oakdale leaves preview. 😀
One year old video, but still relevant 👌👌👌
Thanks. Yeah I don’t think any of this has changed. 😎
Thanks' to you, Shane - I'll look like a genius 🏆
You are a genius Grant. 🤩
Hey Shane,
I'm trying to export data from a SharePoint List to a csv file using the create csv table action.
The data in the csv table currently looks like this:
140697, 2022, 046, WK3, 20, 1-500
Below is what I want the data to look like:
"140697", "2022", "046", "WK3", 20, "1-500"
All of the columns should have double quotes around them except for the 2nd to last column
I haven't done that one. Sorry. I am sure it is possible, I just don't have a quick answer.
@@ShanesCows Thanks, I used the Replace Function and it works perfectly
Amazing, thanks!
Hey Shane, That is a great session, thank you! I have a question, how to replace the name positions? For example Chewy Young to Young, Chewy (adding comma)
Thank you! :)
Your are awesome. As practice makes a man perfect ☺️☺️
Thanks 🙏
Is replace new? Discovered it recently and used it to inject data into an html template that I used to generate PDF reports/coversheets for a ticketing system I built. Couple that with the media conversion service in the sharepoint api and you can build some fancy looking stuff!
Not sure Perry. I hadn’t used it before that I can recall. I don’t have all the flow expressions memorized unlike Power Apps
Hi Shane,
Your videos are really awesome and helped me alot.
I'm wondering if you could give me a quick answer to this.
If I have a string (that's meant to be a date) eg 04/04/2022
How do I find the MM value dynamically?
How do I find the YYYY value dynamically?
I've worked out how to find the index for both of the "/" but I don't know how to get values I want.
My issue is also that sometimes my "date" string varies, eg it might be 4/4/22 next time and everything breaks!
Hope that makes sense.
Turn the Date string into a date. Look at the ParseDateTime expression in flow. I think it does what you want though I have never used it.
Hello Shane, first I want to thank you for your content which has served me a lot, since it is very clear, didactic and fun.;). I have a question where I hope you can guide me. In Power Automate, you can run a flow that "detects the files you select" in one sharepoint library and copies them to another. Again thank you and stay tuned for your genius...;)
Hey Robert. I think this is possible but I haven’t done it before. In flow you can get file content and you can creat file so seems good. How would the user select which files though? Maybe like this? ua-cam.com/video/QcWjAt7QVn4/v-deo.html
Replace , with line break command?
Hello Shane, how do you remove double quotes in a string? For example, if the string is this:
Then he stated, "We don't need any of this". How would I remove the quotes in this statement. Thanks for your help.
Tristan I would think you would Replace(' "YOur string" ', '"', '') Replace(' "YOur string" ',singlequote double quote single quote, single quote single quote)
Hello,
I am looking to manipulate excel data files using a flow-
For example- Flow to pick the file in SharePoint > manipulate the data in the file (remove columns, filtering) and load the cleanse data into a new file?
Is this possible and if so do you have video that you done on this?
I have done all of that but this will at least get you as far as I have been. Microsoft Flow Excel Online Connector - Dynamic files 😮, odata, pagination and more
ua-cam.com/video/QcWjAt7QVn4/v-deo.html dynamic tablea
Hi Shane,
Suppose I've a string, in which there are a lot of words "and" and I want to replace all of them with the symbol "&".
Which function do I need to use and how?
eg,
Old String - "The sun was shining, and the birds were singing, and the flowers bloomed, and the world seemed full of life."
New String - "The sun was shining, & the birds were singing, & the flowers bloomed, & the world seemed full of life."
Could you please help me.
I am trying to learn how to deal with a null value being written to a dataverse column that is date/time. My flow works when a date is supplied, but if it is null, the write step fails because I am trying to write a null to a date/time field. How can I conditionally update a column/field when I am adding the row?
Thank you soooo much!
Nice tutorial Shane, kindly help me with this I have set up a flow that from my outlook the .csv attachment will be saved to my onedrive I end up having multiple attachments with the same report. now, how can I make a flow that every time my outlook save the attachment to my onedrive it will rename the file and replace the existing one.
Is it possible to use a SharePoint Lists to Create a Filtered Drop Down (Input.ChoiceSet) in adaptive cards?
Interesting... It wouldn't be easy but you might be able to build that part of the string dynamically...🤔 I do think maybe.
Hi Shane,
Great video…
Can you advise. I am trying to remove a line, that contains yy , it could be on different lines in other files.
I can replace yy with ‘’ but it leaves a CR LF
, ideally I would just like to remove the line completely
yy
from my filecontent, but there are line above and below that i want to keep
Any help would be great
Hi Shane,
Thanks for nice video(s), just wondering how to replace the arrey value on [{"System":"OPS"},{"System":"OS"},{"System":"Win"}] on Approval action, when I user HTML table it shows data nicely when I added them to approve action it looks like above format.
Should I use replace to remove [{ }:",] ? thanks
Thanks Shane
Glad it helped you.
Your videos are great...please do one on adding list items inside a folder using power automate. I can't get it to work to save my life. I've trying to create an onboarding flow, where each new employee has their own folder and can't see any other employees folder content. I need to create a checklist in each new folder. Please help.
I covered this in my latest video where I answer comments and yours was one of them. 😀 ua-cam.com/video/8eoaSsXnh6Q/v-deo.html
I have a question: Is it possible to remove comma from a number value and convert that decimal number to whole number in power automate platform. For example: I want to convert 1,27.89 to 128. Here I want to remove comma after 1,2XXX and covert the decimal number 127.89 to 128. Please help
Nice video! Can i to do an expression for to get the id of te user at e-mail body and to do parsing to my sharepoint list? example: b8te98 is Paul Olivier.
Hello Shane. I am struggling with Date values. I am importing data values from Excel to Sharepoint. I get an error that Date field has to be a String type but in excel it is a Date type. How do I do it in Flow to convert the Date to String
I cover that problem in this video ua-cam.com/video/QcWjAt7QVn4/v-deo.html
Hi Shane...pls help us out if there is any function in powerautomate to display the data with or display in new line '
'...we had a requirement of displaying SharePoint column data in email body of ms flow,. It is multi line text field and the data will is in semicolon separated..same need to display in new lines or line break after semicolon
You will need to find the characters and replace them with html. Sorry I don’t have a video on this
How do you parse a response from a MS Form that is entered like this?
•Sunday
•Monday
•Tuesday
•Wednesday
The flow sends an email and looks like this: •Sunday •Monday •Tuesday •Wednesday
How do we format in flow to look like this in the email?
•Sunday
•Monday
•Tuesday
•Wednesday
You would find the • and insert a in front of it is my first idea. 😎
Is there a way to remove whitespace from inside a string? I have a string that contains "lastname, firstname", but I need to remove the space after the comma to use the Office365 Users action in flow. Otherwise, the user cannot be found.
Use the Replace expression to replace the ' ' with '' 😀
Thanks
No problem
howdy Neighbour! i cant believe our " Mr. Solution to everything Power Apps" lives next door! if it was possible to get a similar video on how to convert SharePoint list to text file. i created an App to collect covid survey data and we need this data to be attached to our Scheduling software (legacy systems - of cause) through middleware - i need SharePoint list in txt format. is it possible without million steps like this?
Hey Lana. 😀 The SharePoint Create File action will accept plain text as input. There shouldn't be any fancy tricks required.
Ah! The 0 got me, thanks!!!
Awesome 😎
PA needs string interpolation
Concat(Replace(Trump,?),2020) is my syntax correct.😷
😶 🙂
Please rename your compose blocks. It's so confusing!!
Noted.