Answered

How to extract the sender's name from an email address

(0) Share

Report

Posted on by shikha_ru

Hello! I'm creating a flow to transfer new emails from Outlook to an Excel spreadsheet. I need to get the sender's name, but the "From" variable extracts the email address. What expression can I use to get the name instead? Uploaded an image for reference below. I'd appreciate any suggestions/help, thank you!

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@shikha_ru use get user details action and pass From from trigger. You will get name of the employee.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
shikha_ru 18 on at

Like (0)

Report

Thanks for the quick response. Would I need to do user details action before "add a row into a table" action? Currently, my first step is "When a new email arrives in a shared mailbox" and second is "add a row into a table"

Was this reply helpful? Yes No
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@shikha_ru use after shared mail box trigger. So that you can use it in your add row action.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
shikha_ru 18 on at

Like (0)

Report

Got it! Thanks a lot

Was this reply helpful? Yes No
KayFax 99 on at

Like (0)

Report

HI,

I got a similar scenario, but the "Get User Details" only works for users within my organization, or?
Not for outside users (i.e. mails sent from yahoo, apple, or Gmail accounts?)

Any way to extract the sender's display name for emails that are sent to a shared inbox?

Maybe with the HTTP-Get Action for Outlook?
Thanks!

Was this reply helpful? Yes No
PowerAutomate15 22 on at

Like (0)

Report

Have you found a solution for outside users?

Was this reply helpful? Yes No
KayFax 99 on at

Like (0)

Report

hey,
nope, I have not. But also think this is to complicated and for me it was not super important.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Use "Export email" action and parse the headers.

Was this reply helpful? Yes No