send message chat in MS Team

[Anonymous]

I have file excel 4 column as below.

Name User	Name Case	Progress	Status	mail
AA	AA Report	45%	On the way	asd@aa.com
AB	Summary report	100%	Completed	aase@aa.com
AC	ADR Report	100%	Deploy	atre@aa.com

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

Ex. From table above ----> I want send message in microsoft team to AA ( asd@aa.com ) detail message in chat as below.

Hello AA.

Now usecase AA Report progress 45%.

please update % in current to me please.

Please guide me for create flow about this case.

[Achavan · Accepted solution]

Hi @Anonymous ,

I tried replicating this use case -

Please find below steps

1. I used excel online to retrieve rows 

Action Used -  List rows present in a table

2. Initialize a variable of type integer , here count is the row of your excel

3. Convert progress into float as in my excel progress type is percentage

4. Multiply progress by 100

5. add condition

6. Step to send email

7. After condition, add increment variable -> select count -> 1

Hope this helps !

[Anonymous]

@Achavan  Do you mind sharing your power automate file with me?

[Anonymous]

@Achavan  If I want to send chat in microsoft teams (1:1) by email user instead send mail.

How to solve it?

Please guide me about it.

[Achavan]

@Anonymous 

as far as I am aware this is not possible

you can upvote here
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Flow-post-a-message-to-a-Teams-chat/idi-p/148021