Unanswered

How to check if a email is Group email or individual's email?

(0) Share

Report

Posted on by Community Power Pla...

Hi Everyone,

I have a Person Type column (Allowing multiple selections) in the SharePoint list and that column can contain Group email as well as individual email. Now my query is how can I check which email is a group email?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Anonymous,

Do you want to determine whether the email address is a group?

Actually, we could list all the groups we owned, and compare the individual email address with the group we owned.

ComboBox4_1.Selected.Mail in ForAll(Office365Groups.ListOwnedGroupsV3().value,mail)

Note that ComboBox4_1.Selected.Mail is a ComboBox populated with all the user emails.

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

Like (0)

Report

@v-qiaqi-msft Thank you for responding.

Yes, I have to determine whether the email address is a group email or an individual's email because the Person column which I am using a multi-select column so it can contain more than one email. Now I have to check all the selected email addresses and find out the group email.
ComboBox4_1 will contain multiple emails.

Note: I am not the owner of the group.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Anonymous,

Okay, just modify as below:

Concat(ComboBox4_1.SelectedItems,Mail,",") in ForAll(Office365Groups.ListOwnedGroupsV3().value,mail)

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

Like (0)

Report

Hi @v-qiaqi-msft

"Office365Groups.ListOwnedGroupsV3().value" will return only those groups which I owned or it will also return those groups which I am part of?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @Anonymous,

This operation returns a list of all groups that you own and belong to.

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

Like (0)

Report

Hi @v-qiaqi-msft

I have tried "Office365Groups.ListOwnedGroupsV3().value" and it is not returning the group of which I am part. Am I missing something here?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @Anonymous,

Could you please share your app configuration, show me how you set this formula?

If you are not the owner of the group, it does return nothing.

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

Like (0)

Report

Hi @v-qiaqi-msft

I am using "Concat(Combobox.SelectedItems,Email,",") in ForAll(Office365Groups.ListGroups().value,mail)" this formula in the Text property of label control. I am not an owner of any of the groups however I am a part of a group. Right now the above expression is returning false but it should return true because "Concat(Combobox.SelectedItems,Email,",")" this expression is returning all the selected emails of the combo box, and one of the selected emails is a group email of which I am part of (not the owner).
Now I want to identify that group email so that I can show it on a label.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Anonymous,

Okay, I think we should modify the formula since we want to make either of the selected email match to the groups:

CountRows(ForAll(ComboBox4.SelectedItems,Email in ForAll(Office365Groups.ListOwnedGroupsV3().value,mail)))>0

Note that I populate the ComboBox4 with the Choices() function, so I refer to Email parameter.

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

Like (0)

Report

Hi @v-qiaqi-msft,

This one worked well and now the only thing I require is that I want to fetch the specific distributed group email (not security Group) address among all the email addresses of the combo box. Is there any way from which I can get the distributed group email address so that I can show it on a label?

Note: I am using Distributed Group/Distributed List, not the Security group.

Thanks
Tarun

Was this reply helpful? Yes No