SOLVED

Message Teams from Excel with power automate

%3CLINGO-SUB%20id%3D%22lingo-sub-1187567%22%20slang%3D%22en-US%22%3EMessage%20Teams%20from%20Excel%20with%20power%20automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1187567%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3EI%20receive%20an%20erroe%20when%20I%20try%20to%20make%20an%20flow%20with%20Power%20Automate.%20Using%20the%20template%20that%20should%20update%20Teams%20from%20an%20Excel%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EError%3A%20Type%20is%20rquired.%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20where%20do%20I%20check%20that%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22error%20type.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172550i88386C8D4489F333%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22error%20type.PNG%22%20alt%3D%22error%20type.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BGeir%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1187567%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1189176%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Teams%20from%20Excel%20with%20power%20automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189176%22%20slang%3D%22en-US%22%3EThat%20template%20is%20using%20an%20old%20action.%20%E2%80%9CPost%20Message%E2%80%9D.%20Delete%20the%20action%20and%20add%20it%20back%20manually%20From%20the%20Microsoft%20Teams%20connector%2C%20the%20one%20labeled%20%E2%80%9CPost%20a%20message%E2%80%9D%20and%20it%20should%20work.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1192962%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Teams%20from%20Excel%20with%20power%20automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1192962%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BIt%20looks%20like%20that%20fixed%20it.%20The%20error%20is%20gone.%20But%20how%20do%20I%20trigger%20it%20to%20start%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%3CFONT%20color%3D%22%23FF0000%22%3EThis%20flow%20can%20not%20be%20triggered%20for%20testing%3C%2FFONT%3E%3C%2FP%3E%3CP%3E*%3CFONT%20color%3D%22%23FF0000%22%3EThere%20are%20no%20runs%20for%20this%20Flow%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3E-%20Geir%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22trigger%20flyt.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173420iC279A6EA35C307FD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22trigger%20flyt.PNG%22%20alt%3D%22trigger%20flyt.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1194239%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Teams%20from%20Excel%20with%20power%20automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1194239%22%20slang%3D%22en-US%22%3E%22Define%20a%20custom%20action%20to%20happen%20for%20a%20selected%20row.%20It%20could%20be%20sending%20an%20email%2C%20copying%20the%20row%20to%20another%20spreadsheet%2C%20or%20something%20else.%20You%20decide.%20To%20use%20this%20flow%2C%20your%20data%20must%20live%20in%20a%20table.%20Learn%20more%20about%20creating%20tables%3A%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fcreate-table-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fcreate-table-excel%3C%2FA%3E.%20To%20trigger%20the%20flow%2C%20select%20a%20row%20inside%20your%20table%2C%20go%20to%20the%20Data%20tab%20in%20the%20Excel%20ribbon%2C%20and%20select%20Flow.%22%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1198183%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Teams%20from%20Excel%20with%20power%20automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1198183%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BI%20added%20Flow%20to%20Excel%2C%20and%20it%20worked%20perfect.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3E-%20Geir%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

Hi.

I receive an erroe when I try to make an flow with Power Automate. Using the template that should update Teams from an Excel row.

 

Error: Type is rquired. 

But where do I check that?

error type.PNG

 

Best Regards 

 Geir

4 Replies
best response confirmed by Geir Hogstad (Regular Contributor)
Solution
That template is using an old action. “Post Message”. Delete the action and add it back manually From the Microsoft Teams connector, the one labeled “Post a message” and it should work.

Thank you @Chris Webb It looks like that fixed it. The error is gone. But how do I trigger it to start?

 

*This flow can not be triggered for testing

*There are no runs for this Flow

 

Best Regards

- Geir

trigger flyt.PNG

"Define a custom action to happen for a selected row. It could be sending an email, copying the row to another spreadsheet, or something else. You decide. To use this flow, your data must live in a table. Learn more about creating tables: https://aka.ms/create-table-excel. To trigger the flow, select a row inside your table, go to the Data tab in the Excel ribbon, and select Flow."

Thank you @Chris Webb I added Flow to Excel, and it worked perfect.

 

Best Regards

- Geir

www.000webhost.com