Hi! Coming from SharePoint -> Drupal forms / workflow?

Hi folks, I’m hoping there’s someone here who either has come from the SharePoint world and/or can offer suggestions regarding forms and workflow in general.

What’s a current great way to migrate from an InfoPath and Advanced Workflow world to Drupal?

In general terms here are the very basic requirements:
• Web-enabled form
• The form should obviously gather info and insert data into a table somewhere (that’s the easy part)
• Can Drupal forms hide sections and only reveal them based on criteria?

(Active Directory integration)
• Can 1 or more emails be sent with fields from the above table once the form is submitted?
• Can user/employee lookup happen and autocomplete things in the form?
• User/manager lookup?

Thx in advance while we’re in the middle of this evaluation.

Drupal version: 

Source: https://www.drupal.org/taxonomy/term/37/feed