Flow runs successfully but it doesn't add users

[chicgotech]

I created a flow to add users to Microsoft team group. The flow runs successfully. However, t doesn't add any users. What could be the problem?

[chicgotech]

Also, when I try to Edit columns in the flow, I get "Something went wrong. Please refresh the page or try again after some time".

[chicgotech]

I re-created it and have the same issue.

[Rhiassuring]

Are you able to show us the configuration of the flow? 

In the screenshot above, I see two Excel actions, but not any user / Teams / groups actions.

[chicgotech]

Rhiassuring,

See the code above. Thank you and look forward to receiving your reply. 

[Rhiassuring]

@chicgotech  I don't see any additional screenshots? 

I still just see this:

Which, as I mention, doesn't show any "add users" activities - only 2 Excel activities. Did you mean to post an additional screenshot?

[chicgotech]

{

  "type": "Recurrence",

  "recurrence": {

    "frequency": "Month",

    "interval": "1",

    "startTime": "2023-11-23T16:00:00.000Z"

  }

}

{

  "type": "OpenApiConnection",

  "inputs": {

    "parameters": {

      "source": "me",

      "drive": "b!TKmIsp4smU67QeAi6JQ-mutwf2YQ26pBi9NkOqyZmBc6HPvCzJLnQbWLGKjDOIuI",

      "file": "016MKGSKPEF2UW7Y7JWVB3QIK277K33XNB",

      "table": "{8C1BCEE4-446B-4EC0-88F4-0C8E80E13892}"

    },

    "host": {

      "apiId": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness",

      "connection": "shared_excelonlinebusiness",

      "operationId": "GetItems"

    }

  },

  "runAfter": {},

  "metadata": {

    "016MKGSKPEF2UW7Y7JWVB3QIK277K33XNB": "/Test.xlsx",

    "tableId": "{8C1BCEE4-446B-4EC0-88F4-0C8E80E13892}"

  }

}

{

  "type": "Foreach",

  "foreach": "@outputs('List_rows_present_in_a_table')?['body/value']",

  "actions": {

    "Add_a_member_to_a_team": {

      "type": "OpenApiConnection",

      "inputs": {

        "parameters": {

          "body/userId": "@items('For_each')?['Email Address']",

          "teamId": "043dc0a6-3d64-428d-8854-e6f17956e986"

        },

        "host": {

          "apiId": "/providers/Microsoft.PowerApps/apis/shared_teams",

          "connection": "shared_teams",

          "operationId": "AddMemberToTeam"

        }

      }

    }

  },

  "runAfter": {

    "List_rows_present_in_a_table": [

      "Succeeded"

    ]

  }

}

{

  "type": "OpenApiConnection",

  "inputs": {

    "parameters": {

      "body/userId": "@items('For_each')?['Email Address']",

      "teamId": "043dc0a6-3d64-428d-8854-e6f17956e986"

    },

    "host": {

      "apiId": "/providers/Microsoft.PowerApps/apis/shared_teams",

      "connection": "shared_teams",

      "operationId": "AddMemberToTeam"

    }

  }

}

[chicgotech]

Sorry, I thought I post the code. Can you see the code now?

[Rhiassuring]

Yes, thank you, but it's very hard to picture through the code. Could you post screenshots instead, please?

[chicgotech]

[Rhiassuring]

Sorry, I mean, I want to see the parameters of each. Not the Code View. 

I'd also like to see the raw output from List Rows in Table (screenshot of it is fine) to make sure that you're actually getting data out of it.

[chicgotech]

[RouxJMM]

Try adding a 'Get user profile (V2)' action just before 'Add a member to a team' action.

[chicgotech]

Like this? But that doesn't fix the problem. The flow runs successfully. But no members are added. 

[Rhiassuring]

@RouxJMM is right, but the next step is that you need to use the output of "mail" into the "A User AAD ID for the user to add to a team"

CHeck out this thread - they had the same issue as you, and resolved it this way:

https://powerusers.microsoft.com/t5/Building-Flows/Create-a-Flow-to-add-members-to-Teams-site-based-...

[chicgotech]

I can't make it work. Which user (UPN) do you put there? I try both the Team group IP and email address,

but they all get user not found. 

[Rhiassuring]

Using the email to get the User Profile works, and then using the "User Principal Name" to add them to the Team works.

The problem you're having is with your Apply To Eachs. 

Are you trying to add everyone from your Excel Table to the Team? Are you trying to filter the Excel sheet and add only a certain person / people at certain times? What's the goal?

[RouxJMM]

@chicgotech 

Oh! Did you grab those email addresses from your on Prem AD?  Only users in Entra can be added to Teams.  To make sure the emails in your spreadsheet are also in Entra (you want the 'userPrincipalName'), try this action.

[chicgotech]

1. I used only two domain accounts' email to tests. 

2. In my initial test, the flow runs successfully as shown below. Your flow ran successfully, Add a member to a team without errors, the Team group ID is correct, I also received email sent from the flow. 

3. As suggestion, the problem could be flow doesn't get user profile. However, not matter I have tried, I can't make the get a user profile work. It always says user not found. 

[chicgotech]

Ok, I find the problem. Since the problem is "get a user profile", I create a flow to get a user profile. If the email is an individua email, "get a user profile" works.

If the email is Team email, "get a user profile" flow gets "user not found". I have tried 3 Team groups and all of them have the same problem.