Add members to new teams

[MrGibbs]

Hi

I am a teacher and create 10+ new class teams per semester. What I would like to create is a flow to add members to the new teams. 

Ideally it would trigger when a new Excel file is dropped into a folder in OneDrive. I can easily create tables for each class with their email address and TeamID as the columns. 

I have tried several things but have failed so far. 

Can someone please help with the setup of this flow?

Thanks

[MrGibbs]

This is my current approach.

[Sayan]

Hey @MrGibbs 

As I am using Corporate Laptop, so I don't have to Access to MS Team, so I am unbale to create the Flow and Test it. Just Created the Template.

You can refer the following solution hope it will work: 

Create the Flow:

• Select the trigger "When a file is created in a folder" for OneDrive.

Get the File Content:

• Add an action "Get file content" to read the Excel file.
• Use the file identifier from the trigger.

List Rows Present in a Table:

• Add an action "List rows present in a table" from the Excel connector.
• Choose the location, document library, file, and table where the email addresses and Team IDs are stored.

Apply to Each:

• Add an "Apply to each" control to loop through each row in the Excel table.
• Use the value from the previous step.

• Add Members to Teams:

  • Inside the "Apply to each" loop, add an action "Add a member to a team" from the Microsoft Teams connector.
  • For the Team ID, use the corresponding column from the Excel table.
  • For the User ID, use the email address from the Excel table

Provide the Table Name Manually.

Hope It will work!

------------------------------------------------------------------------------------------------------------------------------

If my suggestion helps you, please give it a Thumbs up 👍  and Mark as a Solution ✔️. It motivates to solve more problems.

Thanks,

Sayan Patra

RPA Developer

[MrGibbs]

Thanks @Sayan 

This solution feels like it is the closest I have been to a working flow. This is the error I am recieving:

[Sayan]

hey @MrGibbs 

can you please share the Advanced Properties of List of Rows Present in a Row and The Foreach.

Thanks

Sayan Patra

RPA Developer

[MrGibbs]

List of Rows Present in a Row

The Foreach.

[Sayan]

Hey @MrGibbs 

can you please delete the Last to Actions and Run the workflow and please share the Raw Outputs.

In "List Of Rows" what input parameters you have given I am unable to see.

------------------------------------------------------------------------------------------------------------------------------

Thanks,

Sayan Patra

RPA Developer

[MrGibbs]

Hi @Sayan 

After deleting these two from List rows present. 

List_rows_present_in_a_table - Raw Output

[Sayan]

Hey @MrGibbs 

Is the problem Solved or not.

if the issue is not solved, please share the current error.

Thanks,

Sayan Patra

RPA Developer

[MrGibbs]

Sorry @Sayan 

I am recieving the same error

[Sayan]

Hey @MrGibbs 

can you please share the screenshot of excel file?

[MrGibbs]

@Sayan 

Here is my test table I setup with one student. 

Also those two advanced parameters you asked me to delete keep reappearing after I run a test. I delete them, save, run the test and then they are there again. 

[Sayan]

Hey @MrGibbs 

For me "List rows present in a Table" working Fine.

Please try it hope it will work:

Create Change connection and use the new connection in List rows present in a Table.

Hope it will works.

Thanks,

Sayan Patra

RPA Developer

[MrGibbs]

@Sayan 

This is the current error.

Action 'Get_files_(properties_only)' failed: SharePoint Site Address '/drives/b!uBmfnuiOdUWDJtmoHV3Tetv0rcx4UU5Jth_zpRnQHErmB2J67NO2TqIDi0bRaMic/root:/Teams automation/members v11.xlsx' is not valid clientRequestId: 70a27de0-c2b9-4b25-8c8b-280b86e0e602

When I made the change, I had to redo a lot of settings maybe I messed something up. Does this look correct?

[MrGibbs · Accepted solution]

After a long run of all your ideas @Sayan and lots of time with ChatGPT and Copilot I have the solution. 

This is working now.

• It triggers on an interval to check a table in an Excel File in OneDrive. 
• It lists the rows in the table. 
• It correctly provides the Email and TeamID for the Add a member to a Team iteration. 

My plan is to add informtion to the table at the start of the semester, run the flow and then turn it off once the members have been added. 

Thanks for your help!