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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (932)