I have file excel 4 column as below.
Name User | Name Case | Progress | Status | |
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.
Solved! Go to 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 !
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 !
@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.
@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
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.
User | Count |
---|---|
26 | |
25 | |
22 | |
22 | |
11 |
User | Count |
---|---|
45 | |
33 | |
31 | |
30 | |
30 |