Description: HeehawBaws stuff, musings, discoveries and interests.
solutions (14560) help (5512) share (3284) hobbies (714) interests (130) heehawbaws (1) heehaw (1) baws (1)
I integrated two third party vendor systems using Power Automate. A flow GETs data from one API and inserts these as new employee details via another API. These new employees' first act upon securing their position is usually to try to sabotage my integration by inserting strange characters into phone numbers, National Insurance numbers and all manner of other places that cause my POST action to be rejected. Sometimes I can't even find these weird glyphs on my keyboard and have to ctrl-c and ctrl-v them int
If you've had the same problem, you'll know there isn't a function for bulk cleansing or replacing of characters in Power Automate. This is how I did it.
Read more ...