Search code examples
sharepointazure-active-directorymicrosoft-graph-apipowerappsoffice365api

Sharepoint List fed by Users Profiles in the organization


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.


Solution

  • 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!