Send data by post message in a chat or channel ?

[Anonymous]

I use post a choice of options as the flow bot to a user as below.

and I use post message in a chat or channel for get answer to me.

But I user1  don't choose choice of options for send answer.

Power automate don't send choice of options to user2.

Please guide me about it.

[rakadakaka]

@Anonymous  : Can you please share the Options that you are setting in the step "Post a Choice of Options as the flow Bot to a User" .

It will help in further checking on the issue .

Flow bot sends the Option that you set from your step to Teams chat and will wait until the response is selected by the User and sent back .

[Anonymous]

@rakadakaka I want data from excel (choose apply to each) and send to many user.

But if I run.

Flow bot sends the Option to userNumber1 but if userNumber1 don't response is selected , Flow bot not send the option to other userNumber.

[rakadakaka]

Yes , the action will wait for the step to complete [once the user takes actions from Teams] then only it will move to next step and then on to next iteration of the loop .

It's the expected behavior .

The Problem you are facing is to sent the same Teams Option Flow bot message to different users at the same time .

You need the ability to spawn multiple threads at the same time , we can do it by following options , All the options mentioned below are asynchronous , If you want to build some logic based on the response you need to add some extra custom code .

1. Send Your message from Loop to Service Bus Queue/Topic and then from the Queue subscribe(create another flow) to the message and then send the Team Flow Options to different persons .

2. Create your flow in solutions and from the Parent call a child flow define the parameters of mail id and other custom parameters you want and call the child flow . Please note by default Parent-Child flow execution is synschronous , so you need to do workaround to make it asynchronous .

3. Used shared data source approach (from the 1st flow , extract all the emailIds where you need to send details) , Add all the details in some data source for example SharePoint list , SQL DB Table , Data Verse table .

Write another flow which will initiate once a new record is entered in the table and then send the notification from that table

Please let me know if you need more information .

If this helps , please mark it as solution. So, it will help others

[Anonymous]

@rakadakaka  I'm newbie power automate.

Please shared your flow example for explain to me.

[rakadakaka]

The below Sample Flow has been designed using Option 2 (Using Solutions , Parent-Child asynchronous pattern) approach mentioned in my previous reply :

ParentFlow Reference Example (just to simulate multiple mailID scenarios I have used JSON Array)

Child Flow Reference :

You can add steps after posting the Options to teams to capture the response , totally depends on you how you want to process , store , audit it .

Please let me know if you need more information .

If this helps , please mark it as solution. So, it will help others

[Anonymous]

@rakadakakaCould you shared code in activity Parse JSON to me please?

[rakadakaka]

@Anonymous: In my flow , it's just a sample step added , you need to extract the data from excel tables , so instead of the above step you will be using getRowsFromExcel step that you have been using.

[Anonymous]

@rakadakaka 

I don't understand if I have file excel in share point as below

File excel :  datasource 

If I want filter rows progress < 100% and status not equal completed , then send message in microsoft team in chat 1 :1

How to edit your flow?