Flow - create team and add members from SP list?

[Oskarkuus]

I have a list with two columns

Title | Members

Title = team name (text field)

Member = People to become members of the team (Sharepoint Person column, multiple selection allowed)

Then i have a flow that is triggered by a button atm (Testing phase)

It gets items from the list

It creates the teams (title as team name)

But then i have problem adding members to it.

Anyone able to help?

Se pictures

[Expiscornovus]

Hi @Oskarkuus,

From the screenshot it looks like you are using the Email address for the AAD id field in the add a member to team action.

You can use the Get user action to retrieve that id based on the user principal name.

Below is an example of such a setup.

[Oskarkuus]

Thank you. But i am still stuck. I get a new error and tried to do as you did on your picture.

Se pictures.

[Expiscornovus]

Hi @Oskarkuus,

Can you use the TeamMembers field (Medlemmar) instead of the Current Item field in your second apply to each loop?

[Oskarkuus]

I still get this error "Request to Azure Resource Manager failed with error: '{"error":{"code":"InvokerConnectionOverrideFailed","message":"Could not find any valid connection for connection reference name 'shared_azuread' in APIM tokens header."}}'."

I only get this error when using either the Office365 connection or the Azure connection. Tried to remove all connections to them and reconnect the connections, but still the same error.

[Expiscornovus · Accepted solution]

Hi @Oskarkuus,

@Jay-Encodian has written a good blogpost about this. Can you try one (or both) of these solutions:

https://blog.encodian.com/2020/10/fix-the-request-to-azure-resource-manager-failed-with-error-in-pow...

[Oskarkuus]

Great, that worked!

Thank you.