I've been able to query the O365 connector to pull a number of fields into messages, providing a more personal experience. However we have one field (Employee ID) which is not stored in O365, but instead on-premise AD.
How could I go about pulling this in?
Hello @johnbradbury
At this time Power Automate cannot connect to Onprem AD.
You will have to use a third party software like LDAP API, etc.
There is an idea posted already for this feature, please vote for it:
https://powerusers.microsoft.com/t5/Flow-Ideas/Support-for-on-premise-Active-Directory/idi-p/135567