Extract email address from MS Form result

Like (0) Share

Report

Posted on 1 May 2022 13:34:51 by MRuberto

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

All responses (4)

Answers (1)

MRuberto 7 on 02 May 2022 at 04:06:02

Like (1)

Report

Re: Extract email address from MS Form result

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

Cheers,
Mark
Verified answer

Paulie78 8,416 Moderator on 01 May 2022 at 20:21:30

Like (1)

Report
Re: Extract email address from MS Form result

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 😘
Heartholme 1,278 Super User 2024 Season 1 on 01 May 2022 at 14:22:31

Like (1)

Report

Re: Extract email address from MS Form result

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
GeorgiosG 1,013 Super User 2024 Season 1 on 01 May 2022 at 14:21:45

Like (1)

Report

Re: Extract email address from MS Form result

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))