Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Extract email addresses

Posted on 26 Nov 2024 04:27:41 by
Hello, I would like to extract only the email addresses from a string of any length input into Microsoft Forms, such as "Mr. A <aaa@aaaa.com>; Mr. B <bbb@bbbb.com>; Mr. C <ccc@cccc.com>; ...", and generate a semicolon-separated string. How should I build the flow in Power Automate?
 
Categories:
  • Chriddle Profile Picture
    Chriddle 6,991 on 26 Nov 2024 at 08:42:11
    Extract email addresses
    Do you want to do this to send an email to these addresses?
     
    If so just use the original string.
    It's a valid "To" value for emails: Mr. A <aaa@aaaa.com>; Mr. B <bbb@bbbb.com>; Mr. C <ccc@cccc.com>
     
    If you still want to do this, you can do the following:
     
    Select
    From:
    split(outputs('Compose'), ';')
    Map:
    slice(
    	item(),
    	add(
    		indexOf(
    			item(),
    			'<'
    		),
    		1
    	),
    	indexOf(
    		item(),
    		'>'
    	)
    )

     
    Compose 2
    Inputs:
    join(body('Select'), ';')
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard

Featured topics