cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ezequiel
Microsoft
Microsoft

Add a tab to an existing Excel

Hi

 

I need to duplicate a tab into an existing excel when a message is added into a Teams Channel and rename the new tab using a variable coming from the message (the "Message Subject") . Is that possible using Flow?

 

Thanks

 

Ezequiel

1 ACCEPTED SOLUTION

Accepted Solutions
JoCopin
Frequent Visitor

Hi @ezequiel ,

If you need to trigger a specific message you need to add a condition.

For example :

You use the key word "Excel Test : TabName" to trigger your flow

You will have to test if the message content contains "Excel Test" and then extract the Tab Name

 

To extract the Tab Name one can initialize a variable, and set it with substring

In my example : "substring(triggerOutputs()?['body/body/content'],13)"

 

Then use the variable in the table name of "create table" action

 

JoCopin_1-1600782557133.png

 

View solution in original post

2 REPLIES 2
ChristianAbata
Super User
Super User

hi @ezequiel you can try this

 

message.PNG

 

See make shure that you have a value in message subject



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
JoCopin
Frequent Visitor

Hi @ezequiel ,

If you need to trigger a specific message you need to add a condition.

For example :

You use the key word "Excel Test : TabName" to trigger your flow

You will have to test if the message content contains "Excel Test" and then extract the Tab Name

 

To extract the Tab Name one can initialize a variable, and set it with substring

In my example : "substring(triggerOutputs()?['body/body/content'],13)"

 

Then use the variable in the table name of "create table" action

 

JoCopin_1-1600782557133.png

 

View solution in original post

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
Users online (1,794)