Sharepoint List fed by Users Profiles in the organization

Question

this is my first post in StackOverflow, I hope I am doing it well, I am beginig with a bit of lowcode/nocode development. My first task assigned is to create a SharePoint List fed by Office 365 Users, or Graph, or the same Sharepoint Users profile. But I need to add extra custom attributes as the skills or an about me, the idea is to make a Power Apps Canvas where the user can fill this up and also change their User Profile. If you can give me a hand with an start point I will appreciate it a lot. Thanks in advance.

does this help? https://stackoverflow.com/q/45817185/6271132 — mabiyan, Mar 23 '22 at 13:35
Not really but thanks! I actually found it in the Power Apps forums — mamacona, Mar 24 '22 at 14:11

score 0 · Accepted Answer · edited Mar 24 '22 at 19:12

I got my answer thanks to one user in the Power Apps Community forums Link here

At the end I used the Office 365 Users connector with Power Apps Canvas, this and the Sharepoint Connector, we created a ForALl to loop into the users, and with a comparison with the Mail column we could update the records and create them in case they are not, else create them.

Patch(
    'Org',
    ForAll(Filter(Office365Users.SearchUser(), AccountEnabled=true),
    With({ _rec: LookUp('Org', MailColumn = Mail) },
    {
        ID: _rec.ID,
        Title: DisplayName,
        MailColumn: Mail,
        JobTitleColumn: JobTitle,
        DepartmentColumn: Department,
        Manager: Office365Users.Manager(Id).DisplayName
    }
)

Thank you anyway!

Sharepoint List fed by Users Profiles in the organization

1 Answers1