Another great example, perfectly explained. After stumbling upon your channel I have learned so much! I have another related use case with accented characters or needing to select based upon ASCII range of permitted characters. Would it be as simple as entering all the accented characters? What if I wanted to do more of a replace so the output still made sense, just that accented letters are replaced by a non-accented equivalent letter?
Cheers Andy, I reckon you could swap them out with something a bit like this. Drop me a dm and I can share the idea and if it works I can do a video for everyone else 👍
I have been unable to get the string that we started with back into an array! MS Forms automatically put in string forms with odd characters like '/' separating commas. Tried to get rid of the /, but it just showed back up in the final product and seems to have stayed a string when I would like for it to become an array of separate strings.
Congratulations on your excellent work. I've observed your frequent use of the new editor and was wondering if you've encountered any challenges with it. In my experience, I've noticed expressions randomly disappearing within the Outlook connector, which raises concerns about its reliability for professional use. What are your insights on this matter?
Thank you very much. Ultimately I took the plunge with the new designer as it’s here to stay but agree there are still teething problems. My advice is to feedback your findings. If you can document on a forum post or use the direct feedback in Power Automate. I’ve fed back many as a result of my deep dives and even highlighted a few in my videos. Today I had the compose adopt the name of the previously inserted compose which caused an error but I removed it from the video.
Great video. I have this same thing in a flow. What if you wanted to replace specific text instead of a blank. For instance, double quote symbol " gets replaced with the text double quotes. Is there a way to map the symbols to what you want to replace with?
Hey Damien, Thanks for the amazing video (as usual 😊) I have a use case where I need to extract the ID from an email subject which is always going to be in the following format: ITxxxxx where x is an integer. any thoughts?
@@DamoBird365 yes, we have a database that needs to refresh in the evening and I was hoping to have power automate automatically run it at a specific time each night.
Thanks for many good video's. I tried to use chatgpt analysis the content/body of an email when it arrives. I am struggling with the issue that the body of the email contains not only the new message replied by the sender, but also old email conversation. could you please advice or make a video on how one can just capture the current email message body?
Love this type of flow construction!
@@rengiesbrecht6670 it was good fun! I wanted to demo how to substitute values too like accents but it seems like a low interest subject 😭
Love these efficient flows Damien. 👍
Thank you James 👍
Wow, this video is incredibly useful and informative!
Thanks Mounika 🙏
Excellent tip
Another great example, perfectly explained. After stumbling upon your channel I have learned so much!
I have another related use case with accented characters or needing to select based upon ASCII range of permitted characters. Would it be as simple as entering all the accented characters? What if I wanted to do more of a replace so the output still made sense, just that accented letters are replaced by a non-accented equivalent letter?
Cheers Andy, I reckon you could swap them out with something a bit like this. Drop me a dm and I can share the idea and if it works I can do a video for everyone else 👍
Thanks for the amazing video🤩🤩
Thank you Sowmiya 👍🤩
I have been unable to get the string that we started with back into an array! MS Forms automatically put in string forms with odd characters like '/' separating commas. Tried to get rid of the /, but it just showed back up in the final product and seems to have stayed a string when I would like for it to become an array of separate strings.
Multi choice? www.damobird365.com/easily-address-escaped-characters-in-forms-response/
Congratulations on your excellent work. I've observed your frequent use of the new editor and was wondering if you've encountered any challenges with it. In my experience, I've noticed expressions randomly disappearing within the Outlook connector, which raises concerns about its reliability for professional use. What are your insights on this matter?
Thank you very much. Ultimately I took the plunge with the new designer as it’s here to stay but agree there are still teething problems. My advice is to feedback your findings. If you can document on a forum post or use the direct feedback in Power Automate. I’ve fed back many as a result of my deep dives and even highlighted a few in my videos. Today I had the compose adopt the name of the previously inserted compose which caused an error but I removed it from the video.
Great video. I have this same thing in a flow. What if you wanted to replace specific text instead of a blank. For instance, double quote symbol " gets replaced with the text double quotes. Is there a way to map the symbols to what you want to replace with?
Like an accent on an a ? á = a ? I did build a demo but never recorded. You can create an object and use the key to replace individual characters.
@@DamoBird365 still a list of characters, but each character could be replaced by something else that is not a symbol.
@kylerayner1103 a single character for a single character? It’s all down to chunking the string into an array.
Hey Damien, Thanks for the amazing video (as usual 😊)
I have a use case where I need to extract the ID from an email subject which is always going to be in the following format:
ITxxxxx where x is an integer. any thoughts?
You could definitely give this a go on isint() for the subject, as I demo in the video. Let me know how you get on.
Yes I thought so, IsInt would tackle the integer issue, but there is prefix ‘IT’ as well, any thoughts on that?🙂
You could either concat IT back onto it or maybe if the ID is always in the same place, try a different technique and split on a space.
Good stuff!! Is there a way to use Power Automate to run Power Quary in the evening? Is that a simple automate? 😊
A recurrence trigger? And refresh dataflow action? Would that work.
@@DamoBird365 yes, we have a database that needs to refresh in the evening and I was hoping to have power automate automatically run it at a specific time each night.
Thanks for many good video's. I tried to use chatgpt analysis the content/body of an email when it arrives. I am struggling with the issue that the body of the email contains not only the new message replied by the sender, but also old email conversation. could you please advice or make a video on how one can just capture the current email message body?
I could have done with that yesterday to get 1000 out of $1000 - Silver Level to then use the 1000 as an integer.
That would have been a pretty nice test for it 👍
If only regex would be added😢
Now that’s an interesting challenge, office scripts or custom connector using c# are the current options that I know of other than 3rd party.