Answered

Add members to new teams

(2) Share

Report

Posted on by MrGibbs

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

All responses (14)

Answers (1)

Verified answer

MrGibbs 33 on at

Like (2)

Report
Re: Add members to new teams

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!
MrGibbs 33 on at

Like (1)

Report

Re: Add members to new teams

@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?
Sayan 778 Super User 2025 Season 1 on at

Like (2)

Report

Re: Add members to new teams

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 33 on at

Like (1)

Report

Re: Add members to new teams

@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 778 Super User 2025 Season 1 on at

Like (2)

Report

Re: Add members to new teams

Hey @MrGibbs
can you please share the screenshot of excel file?
MrGibbs 33 on at

Like (1)

Report

Re: Add members to new teams

Sorry @Sayan
I am recieving the same error
Sayan 778 Super User 2025 Season 1 on at

Like (2)

Report

Re: Add members to new teams

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 33 on at

Like (1)

Report

Re: Add members to new teams

Hi @Sayan
After deleting these two from List rows present.
List_rows_present_in_a_table - Raw Output
Sayan 778 Super User 2025 Season 1 on at

Like (2)

Report

Re: Add members to new teams

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 33 on at

Like (1)

Report

Re: Add members to new teams

List of Rows Present in a Row
The Foreach.