cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rency0722
New Member

Fill out MS Forms, Update the Excel sheet (Status column) to DONE, and Post a message in Teams Chat

Hi!

Just new here in Power Automate and we want to build 2 flows:

1. After filling out the MS Form, the Excel sheet is updated, and post a message in Teams chat.

rency0722_1-1634987350622.png

 

UPDATE: right now, the message is being posted but we wanted to enhance the message by pulling the details from the updated excel sheet from Forms and including it into the chat:

rency0722_0-1634987326609.png

 

2. Once the specific row has updated STATUS column to DONE, another automation will run to post a teams chat with the details of that specific row where I put the DONE cell.

 

rency0722_2-1634987461811.png

 

 

Hope someone helps! Thank you everyone!

2 REPLIES 2
v-LilyW-msft
Community Support
Community Support

Hi @rency0722 

If you want to send the updated information to Teams after updating the row, you can create an html table, then send message. I set up a flow, you can refer to the figure below:

In my test, Program Title matches in excel and Form.

vLilyWmsft_0-1635222634612.png

vLilyWmsft_1-1635222715909.png

vLilyWmsft_2-1635222790761.png

After flow runs, my channel will receive a message like this:

vLilyWmsft_3-1635223044830.png

Regarding your second Flow, MS Flow does not support similar triggers to monitor whether Excel tables have changed. If you want similar features to be supported by MS Flow, please consider voting for similar idea:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Triggers-for-Excel-Sheets/idi-p/78301

 

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lily!

 

I've tried to run the flow based on the screenshots you've presented and yielded a "FALSE" return on the condition. I have additional questions on your flow:

1. May I know what is listed on the "List rows present in a table" action? I used the Excel sheet associated to the MS Form and upon checking the result, since the form is regularly updated, the output of the action consists of a large array, or is it normal?

 

rency0722_1-1635419255341.png

 

rency0722_0-1635419232159.png

 

2. On the "Condition" action, what are the variables set for the condition? Program Title on the excel "is equal to" Program Title on the Form

 

rency0722_2-1635419340293.png

 

3. On the "Update a row" action, what are the variables that need to be set?

 

rency0722_3-1635419546210.png

 

Thank you!

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,259)