Answered

Help with Match function please

(0) Share

Report

Posted on by ChrisChong

A grand day to you all.

Please, may I trouble you for some help to use the Match function to extract email addresses. Here is my code I cannot seem to get working:
ClearCollect(collMatch, Match( "From: Sad Sack <sad@sack.org>", Match.Email).FullMatch)

I am just trying to get the email as text into a label, like this: sad@sack.org

I would really prefer not to have to wrap the Match function in an intermediate Collection only to extract it later, but there may be no other way?

Any suggestion would be greatly appreciated.

Thanks so muchely.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

If your text will always be in the same format as this: "From: Sad Sack <sad@sack.org>"

Then you can use something like this:

First(Split(Last(Split( "From: Sad Sack <sad@sack.org>", "<")), ">"))

This is definitely not the only way, and isnt probably the best way but is something I have used in the past so wanted to share something quick with you. Will share a better way in sometime.

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com
ChrisChong on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. I was rather hoping do find a solution using the Match function. I have a sense that the Match function may be more efficient, I could e wrong.
Chris
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What happens when you use just this?

Match( "From: Sad Sack <sad@sack.org>", Match.Email).FullMatch

Why do you need to use a collection?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com
Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ChrisChong

Try this:
Match( "From: Sad Sack <sad@sack.org>", "<(?<email>" & Match.Email & ")>").email

This should work.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.
Thanks!
Hardit Bhatia
https://thepoweraddict.com
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com