removing contact information from text (phone numbers, emails...)
I have a need to remove contact information from a string. We need to allow people to communicate within our system but not outside of it. So, I need to search for and remove contact information from strings. For example remove text with the pattern of a phone number or email. If the powerapps "Match" function was available in power automate flows maybe it would be simple with regular expressions. But it's not available. I'm imagining lots of conditions with indexofs and lastindexofs and substrings.
I thought I'd ask before I dig into it to see if anyone had any solutions out there.
Thanks for your response. I used that plumsail connector but found it would have been prohibitively expensive (per transaction) when the free trial ran out. Although I enjoyed learning to use regular expressions I found a way replace the plumsail connector with a few functions and conditions in flow. That problem was a little simpler than the one I've posed in this thread.
Also, I've worked with teams using .NET but not directly myself.
Power Apps have access to the Match function which takes regular expressions. I've failed to find a way to write a power app function though and call it from a power automate flow. Do you think that's possible?
Otherwise I'll likely create a in a child flow with lots of conditions, splits, indexofs and substrings.