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

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

Sort by

MrGibbs 33 on at

Like (1)

Report
Copy link

Link copied!

This is my current approach.

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (2)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
MrGibbs 33 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MrGibbs 33 on at

Like (1)

Report
Copy link

Link copied!

List of Rows Present in a Row
The Foreach.

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MrGibbs 33 on at

Like (1)

Report
Copy link

Link copied!

Hi @Sayan
After deleting these two from List rows present.
List_rows_present_in_a_table - Raw Output

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hey @MrGibbs

Is the problem Solved or not.
if the issue is not solved, please share the current error.

Thanks,
Sayan Patra
RPA Developer

Was this reply helpful? Yes No
MrGibbs 33 on at

Like (1)

Report
Copy link

Link copied!

Sorry @Sayan
I am recieving the same error

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No