Flow - create team and add members from SP list?

(0) Share

Report

Posted on by Oskarkuus

1,097

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

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Expiscornovus 33,768 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Oskarkuus 1,097 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Expiscornovus 33,768 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Oskarkuus,

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

Was this reply helpful? Yes No
Oskarkuus 1,097 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,768 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

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-power-automate/

Was this reply helpful? Yes No
Oskarkuus 1,097 on at

Like (0)

Report
Copy link

Link copied!

Great, that worked!
Thank you.

Was this reply helpful? Yes No