News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows extract email from a s...

Power Automate - Using Flows

Answered

extract email from a sharepoint person list

(0) Share

Report

Report

Posted on by Community Power Pla...

i have a person column in sharepoint list , how do i extract the email from this person column so i can send email?

How do i set condition so that in 50 days, it will send out a email to the person? In 40 days, send to the supervisor?

All responses Img

All responses (3)

Answers Img

Answers (1)

v-bofeng-msft on at

Like (0)

Report

Re: extract email from a sharepoint person list

Hi @Anonymous :

You can find a parameter in Dynamic content whose name is composed of "filedname" and "Email". Because the name of my person colum is "PersonColumn", the parameter in Dynamic content is named "PersonColumn Email".

Note:The person column do not allow multiple selelctions

Best Regards,

Bof
Community Power Pla... on at

Like (0)

Report

Re: extract email from a sharepoint person list

hI,
Can u show of ur filter query and how do u extract the email from the person/group list column (in sharepoint)? There is no email column,
Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: extract email from a sharepoint person list

Hi @Anonymous :

Could you tell me:

Does the person column allow multiple selections?I assume it do not allow multiple selections.

What does 'in 50/40day' mean?Do you need to send mail within 50/40 days after the item is created?

If so,I've made a test for your reference:

For the convenience of testing, I assume that the email will be sent on the 30th day after the item is created.

1\My SP List

2\My flow

Trigger the flow everyday

List all items form the SP list

Filter out items created 30 days before the current date

Iterate through these items, find the user's email and his manager

Send email

Expression Reference:

1\

formatDateTime(addDays(utcNow(),-30),'yyyy-MM-dd')

2\

formatDateTime(addDays(utcNow(),-30),'yyyy-MM-dd')

Best Regards,

Bof

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,524 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans