Lookup by Department

[Worrelpa]

I had a request to enable people to lookup by department.

From research and experimentation I found the APIs for Office365 users were limited to a set number of return records and criteria as some of the calls don't return the department field. A lack of consistency Microsoft's side on that. Also MSGraph API calls were a bit complex.

All I could do was extract the data put it into a table and then update it with a cloud flow once a week to get new people added, account for department moves and remove disabled accouns. (I still have to build that flow). For now I just used a dataflow to import a manually imported extract from AAD from an excel file to use as a lookup. It works but not the most efficient way of doing it.

I see the notifications table keeps the department field, but because not everyone in AAD has a record for lookup so people are missing.

Any suggestions on a better way to do this?
I want to run a flow from the app if possible.

[stuartridout]

Let me ponder on that (I’m away on holiday currently).  The notification records table has the list of users and includes department so we can list them by department on the View By Site page without doing lots of Office365Users calls which can be quite lengthy.  StuartOn 26 Oct 2022, at 13:25, Worrelpa ***@***.***> wrote: I had a request to enable people to lookup by department. From research and experimentation I found the APIs for Office365 users were limited to a set number of return records and criteria as some of the calls don't return the department field. A lack of consistency Microsoft's side on that. Also MSGraph API calls were a bit complex. All I could do was extract the data put it into a table and then update it with a cloud flow once a week to get new people added, account for department moves and remove disabled accouns. (I still have to build that flow). For now I just used a dataflow to import a manually imported extract from AAD from an excel file to use as a lookup. It works but not the most efficient way of doing it. I see the notifications table keeps the department field, but because not everyone in AAD has a record for lookup so people are missing. Any suggestions on a better way to do this? I want to run a flow from the app if possible. —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>