Query Microsoft 365 to pull contacts

MMRHC

Testing using ITFlow for our internal HD. We have a single 365 tenant for the entire company. Wanting to use Microsoft 365 user account information (Name, email, etc) as a data source to automatically pull new/update existing contact information within ITFlow.

Is there a script or template for this?

wrongecho

Hey,

Have a look at this thread and let me know your thoughts:

https://forum.itflow.org/d/32-cloud-importsync-per-client

MMRHC

I saw that. Maybe a Microsoft power apps query to pull the data, or even powershell? Perhaps powerapps/automate can push the data into itflow then?

Looks to be an api to api data transfer then. Any example scripts of Microsoft power apps pushing data to ITFlow?

wrongecho

MMRHC

You probably want it running as a logic app rather than power automate as it's then not tied to a specific user account. Last I checked, Logic Apps are able to natively pull user details using the Azure AD connector. You'd then submit a HTTP GET/POST request against the ITFlow API for each user within the Logic App.

We did this at a previous business for Snipe IT. The core idea is the same so I'm pretty sure it'd work. Sadly, Microsoft took away my free dev tenant so I can't test or provide useful examples of the Logic App side anymore.