cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Noona
Helper II
Helper II

send message chat in MS Team

I have file excel 4 column as below.

 

Name UserName CaseProgressStatusmail
AAAA Report45%On the wayasd@aa.com
ABSummary report100%Completedaase@aa.com
ACADR Report100%Deployatre@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.

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Achavan
Resolver II
Resolver II

Hi @Noona ,

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

Achavan_0-1622992521669.png

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

Achavan_2-1622992599904.png

 

Achavan_1-1622992562279.png

 

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

Achavan_3-1622992644684.png

4. Multiply progress by 100

Achavan_4-1622992677640.png

5. add condition

Achavan_5-1622992697462.png

6. Step to send email

Achavan_6-1622992712873.png

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

Achavan_7-1622992762311.png

 

Hope this helps !

 

 

View solution in original post

4 REPLIES 4
Achavan
Resolver II
Resolver II

Hi @Noona ,

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

Achavan_0-1622992521669.png

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

Achavan_2-1622992599904.png

 

Achavan_1-1622992562279.png

 

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

Achavan_3-1622992644684.png

4. Multiply progress by 100

Achavan_4-1622992677640.png

5. add condition

Achavan_5-1622992697462.png

6. Step to send email

Achavan_6-1622992712873.png

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

Achavan_7-1622992762311.png

 

Hope this helps !

 

 

View solution in original post

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

@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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,182)