web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Power Apps Person or g...

Power Apps

Answered

Power Apps Person or group field

(0) Share

Report

Report

Posted on by Arunkumar333

18

Hi everyone ,

My doubt is , I have a person or group data field , I want to filter and show only people with particular mail id

ex - arun33@gmail.com

arun33kumar@yahoo.com

arun333@gmail.com

I want to show those whose email ends with gmail.com alone , (I tried filtering the office365user.serachuser , (but I guess by doing so the datatype is changing ) and this value is being patched to other power apps whose column type is person or group too

1. is it possible to filter and add it into person or group field , if so pls share the code

I dont want to change the data type because the change is huge if I need to change data type of column in SharePoint

limitations - I dont want to create group in SharePoint and use it as group since then it will be manual task .

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Arunkumar333 ,

Please try:

Filter( ForAll( Office365Users.SearchUser(), { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Department: "", Claims: "i:0#.f|membership|" & Mail, DisplayName: DisplayName, Email: Mail, JobTitle: "", Picture: "" } ),EndsWith(Email,"gmail.com"))

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation