How to get Email address from a Person type column from Collection

(0) Share

Report

Posted on by hkmamun

106

I have a SharePoint List named "SupportPersons" and it has only two column with below type

Column Name Type

----------------- -----------

SupportPerson Person

MobileNumber Text

In PowerApps I have created a Collection named "SupportPersonList" which is taking values/data from that SharePoint list.

Collect(SupportPersonList,ITSupportPersons);

Now how I can get Email Address from the Person type column from this Collection i.e "SupportPersonList" in Power Apps?

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@hkmamun

To get the email of the First person in the collection

First(SupportPersonList).SupportPersons.mail

Or to get a column containing all the emails for every person

SupportPersonList.SupportPerson.mail

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
hkmamun 106 on at

Like
a
(0)

Report
Copy link

Link copied!
@mdevaney I have used you way but it is giving error "Name isn't valid. This identifier isn't recognized." Below is my code
If(MyProfile.Mail in SupportPersonList.SupportPerson.mail,Set(isSupportPerson,true),Set(isSupportPerson,false));

Thanks!
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@hkmamun

It would be helpful to share a screenshot. I don't know where that error is occurring in your code without it.

If its occurring here...

SupportPersonList.SupportPerson.mail

Type the text in manually. After you type each dot '.' see what fields are avialable.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
hkmamun 106 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney the mail property part of below code giving the error

SupportPersonList.SupportPerson.mail
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@hkmamun

Type SupportPersonList.SupportPerson. in the formula bar and then browse through all the available options that appear.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
hkmamun 106 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney nothing is coming after . (dot)

Thanks!
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@hkmamun

If there are no autocomplete options either it’s not a person column or your haven’t populated it with any data.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @hkmamun :
Could you tell me:
Does the 'SupportPerson' field allow multiple sellections?
Whether to assign a value to the isSupportPerson variable based on whether MyProfile.Mail exists in SupportPerson?
Firstly,let me explain why you encounted this error.
The value of SupportPersonList.SupportPerson is a list of sub tables.Directly referencing a field in a list of sub-talbes will result in a syntax error.
The correct way is to traverse the records in the data source.
Secondly,please try these soutions:
Case 1:Multiple choices are not allowed.
Please try :

If(MyProfile.Mail in ForAll(SupportPersonList.SupportPerson,SupportPerson.Email),Set(isSupportPerson,true),Set(isSupportPerson,false));

Case 2:Allow multiple choices.

If(MyProfile.Mail in Ungroup(ForAll(SupportPersonList.SupportPerson,SupportPerson.Email),"Value"),Set(isSupportPerson,true),Set(isSupportPerson,false));

Best Regards,
Bof