cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
ToniRantanen

Support for on-premise Active Directory

Submitted by Advocate IV on โ€Ž07-12-2018 10:35 PM

Hi!

 

It would be nice if Flow would support on-premise Active Directory like it supports already on-premise SQL Server.

 

I'm sure this would help multiple organizations to automate their HR and IT routine tasks (new employees, leaving employees, etc.).

 

Best regards,

Toni Rantanen

Status: New
15 Comments (15 New)
Comments
RyderMC
Frequent Visitor
โ€Ž02-22-2019 11:47 AM

This would be great.  I need a way to retrieve AD user names using a parameter such as email address, and can't find a method...

daniels471
Helper II
Helper II
โ€Ž05-07-2019 01:51 AM

this would be a useful feature to have , currently using csvs and a powershell script we run , but this isnt the most user friendly solution , and somewhat cumbersone to use .

 

Hedgehog
New Member
โ€Ž01-26-2020 12:43 AM

Since Microsoft recommend a hybrid solution for exchange I am shocked that there is no connector for On Prem Active Directory.

 

I am also now facing same issue trying to automate new starters using Powerapps form and Flow but unable to connect to onprem AD. Since Azure doesnt write new accounts back to the onprem AD server I cannot create them directly in AAD. 

 

The only possible way i can think of working this would be if its possible to execute an on prem Powershell script to create local AD accounts.

 

Anyone know has there been any progress with connecting to onprem AD with flow/powerapps or anyone have a link with advise on how to run an on prem powershell script as part of a flow ?

AZHockeyNut
New Member
โ€Ž07-09-2020 07:50 AM

Amen to this! sure would ease the transition from on-prem to hybrid to cloud for a lot of orgs, especially ones where the on-prem ad is long in the tooth and chock full of heaven knows what. all the how tos and examples are always of the simplest version and minimal data. these blog writers should learn to try it with some massive forests and  multiple on-prem ad's etc. If you can make the connector for AAD that does the sync and such, why only one direction? 
also, what about the azure app gateway, that tool helps a ton with on prem apps, can't they connect it to their own stuff?

ok off my soap box now

domtuck96
Regular Visitor
โ€Ž07-09-2020 07:58 AM

Probably not overly helpful to this (not sure how technical everyone is etc) but we got round this by writing some .Net scripts to import AD data into our own Data Warehouse then used the SQL server query options in the power platform to then pull in our on prem AD data. would be nice if it could inherently do so but it's a decent workaround in the meantime