Answered

Post message as flow bot to multiple users

(0) Share

Report

Posted on by yashm

Hey all,

As it is clear from the subject, I wanted to use the flow bot to send messages to me and one of my colleagues. I came across this post where @Pstork1 and @v-yamao-msft clarified that Teams was not designed to do this but we could use a for each loop as a workaround.

So, I did the following by storing my and my colleagues email address in an excel sheet and using the email column:

The above flow works perfectly fine. I just want to know if there is a better way of doing this where you don't need to create a separate spreadsheet just to store email addresses and be able to do it within the flow itself.

P.S. - I was a bit confused with the 'initialize variable' and similar functions and hence used the above method as a workaround. Any explanation on using the same to make this better would be appreciated! Thanks.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report

Two things

1) If you want to communicate with a specific group of users, and its always the same set of users, then create a Team, make them all members and post the message to the Team Channel as the bot. Everyone who is a member of the Team will see it then.

2) If you need to communicate with different groups of users occasionally then the way you are doing it is probably about as good as it gets for Teams. You do need somewhere to store the list of emails. Excel is one possibility and SharePoint is another. Excel is probably easier to change who is in the list.

Was this reply helpful? Yes No
yashm 92 on at

Like (0)

Report

Hi, thanks for your response. I avoided creating a Team because for some reason I am not getting pop-up notifications even when I have turned on all notifications.

Glad to hear that doing this with Excel is one of the best ways. Thanks again.

Was this reply helpful? Yes No