web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Extract email address ...

Power Automate

Unanswered

Extract email address from MS Form result

(0) Share

Report

Report

Posted on by MRuberto

7

Hi

I've currently got a form that has data in the format in multiple dropdown boxes:

Position (mobile no) <first.last@work.com>

Is it possible to easily extract just the email address from the form results for use in sending emails

I've tried a few things including:

Find Text Position then putting it into a substring but the best I can get is <first.last@work.com>

I need it without the <>

Playing with variables - but haven't had much luck

Cheers,

Mruberto

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (1)

Report

Hi @MRuberto ,

apart of you formulas before your can add these two easy formulas to cut off the first and last character:
First character
substring(variables('Mail'),1,sub(length(variables('Mail')),1))
Last character
substring(variables('firstCharacter'),0,sub(length(variables('firstCharacter')),1))

Was this reply helpful? Yes No
Heartholme 1,278 Super User 2024 Season 1 on at

Like (1)

Report

Hi @MRuberto,

This should give you the desired result;

Put this in a compose action for example.

replace(replace(variables('NAME OF VARIABLE WITH EMAMIL'),'<',''),'>','')

If this solves you issue, please consider marking my post as Solved ✔.

Best Regards
Heartholme

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report
Try this:

Expression in the second action (which is a compose) is:

slice(outputs('FormResult'), add(indexOf(outputs('FormResult'), '<'),1), indexOf(outputs('FormResult'), '>'))

Produces the output:

first.last@work.com

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No
MRuberto 7 on at

Like (1)

Report

Thanks all for your suggestions - @Paulie78 your solution was simplest (for me at least)...

Cheers,
Mark

Was this reply helpful? Yes No

Join the conversation