Forum Discussion

Ohhhhhhfffs's avatar
Ohhhhhhfffs
Regular Visitor
4 years ago
Solved

Fetching User ID and Name Together.

Hi,

 

This (Fetching User ID and Name Together) should be simple right?

 

Its not, ive spent several hours just trying to grab this information however it is either you can have just the names or just the IDs. I dont want to manually create a List saying random GUID user ID is equal too Jon Smith.

 

Ive gotten just the user names from

= OData.Feed("MYSITE.com/_vti_bin/listdata.svc", null, [Implementation="2.0"])

 

Ive gotten just the user IDs from MS Shifts using
= OData.Feed("https://graph.microsoft.com/beta/teams/MYTEAMSID/schedule", null, [Implementation="2.0"])

 

Ive gotten just the user IDs again

= OData.Feed("https://graph.microsoft.com/v1.0/groups/MYTEAMSID/members", null, [Implementation="2.0"])

 

It appears that you cannot have a list from somewhere with the UserID and Their Name together without manually exporting an azure user export.

 

Please tell me im wrong and the solution is nice and simple and im a moron.

 

Thankyou.

1 Reply

  • Ohhhhhhfffs's avatar
    Ohhhhhhfffs
    Regular Visitor

    To the sexy people who are reading this,

     

    This is the link i found the solution in https://janbakker.tech/use-power-automate-for-your-custom-dynamic-groups/

     

    This is a quick of how i did it, (You may have to add groups etc, i didnt)

    I logged into and used https://developer.microsoft.com/en-us/graph/graph-explorer put in my graph odata filter query and found what permissions i needed and then i went to the azure portal and registered an app (using the first link i provided for examples) then i added the permissions for both app and delegations (approved it by being admin) and ran a HTTP connector flow using get and WHAM BAM THANKYOU MAM! Beautiful sexy data, almost as sexy as the reader. Peace mofo's

     

    Sorted