1

I received a request to create a Power Automate flow for HR managers as follow:

  • The HR Manager will add the user name inside a SharePoint list >> then the flow will automatically start

  • The flow will import all the email groups from Azure Ad and show them to the user.

  • The flow will allow the user to chose what groups they want the user to be part of

  • The flow will allow the user to choose the user work location from a list

  • The flow will allow the user to choose the user role

  • The flow will allow the user to choose the user manager

  • Then the flow will create the user automatically on the local AD

Can we create such as workflow inside power automate ?

Improve this question
9
  • 2
    You will need user interface for selecting location/role/manager, etc. So, I think you need to develop a Power App for this requirement. Only Power app or Power App + Power Automate solution.
    – Ganesh Sanap - MVP
    Commented Jul 29, 2021 at 6:38
  • @GaneshSanap can you advice more on this please? how i can use Power app to do so.. so you mean i can select the Groups, locations, roles and managers using power automate then populate those values inside power app forms? but where i will be storing the values for locations, roles, managers and groups?
    – John John
    Commented Jul 29, 2021 at 8:40
  • @GaneshSanap can you advice more on this please? how i can use Power app to do so.. so you mean i can select the Groups, locations, roles and managers using power automate then populate those values inside power app forms? but where i will be storing the values for locations, roles, managers and groups?
    – John John
    Commented Jul 29, 2021 at 8:41
  • 1
    You want your users to choose the groups/locations/roles/managers fetched dynamically from Azure AD. In order to choose these fields, user will require the user interface which is not possible by using Power Automate only. So, you have two options: 1. SPFx web part (developer experience required) 2. Power App (faster/low code solution). & If you want to store the user selections for groups/locations/roles/managers, you can store those in SharePoint lists.
    – Ganesh Sanap - MVP
    Commented Jul 29, 2021 at 8:56
  • 1
    Yes, you can show options for groups/locations/roles/managers in power apps (dropdown/combo-box or any other supported controls). Even you might be able to call AD connector methods in Power apps & bring the data in your app if the connector is supported in power apps.
    – Ganesh Sanap - MVP
    Commented Jul 29, 2021 at 9:43

1 Answer 1

Reset to default
1

You want your users to choose from the groups/locations/roles/managers fetched dynamically from Azure AD.

In order to choose the options from these fields, user will require the user interface which is not possible by using Power Automate only.

So, you have two options:

  1. SPFx web part (developer experience required)
  2. Power App (faster/low code solution).

If you want to store the user selections for groups/locations/roles/managers, you can store those in SharePoint lists.

Below are the rough steps you need to perform:

  1. Create Power App
  2. Connect it to Azure AD to get all the Manager/locations/roles/groups and populate different controls inside power app form
  3. When the user saves the power app form, power automate (or power app functions if possible) will create the new user based on the data inside the power app form

Here's documentation of connectors available: Connector reference overview

Improve this answer
1
  • Hi @john Gu , Please Upvote(^) and accept as an Answer if it helped you in any way & it will help others with similar question in future to find the correct answer easily. It also removes this question from "Unanswered questions" list.
    – Ganesh Sanap - MVP
    Commented Sep 2, 2021 at 16:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.