extract email from a sharepoint person list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No