cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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

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 !

 

 

Anonymous
Not applicable

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

Anonymous
Not applicable

@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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,738)