Power Apps Person or group field

(0) Share

Report

Posted on by Arunkumar333

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 Platform Build Tools

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: Power Apps Person or group field

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