cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheAlf
Regular Visitor

Split Teams Message into excel columns

Hey there 🙂
We used to have Google Services in our company, but got converted to Office 365 😄
My boss, the department manager for maintenance, had built a script himself, that scanned defined Hangouts-Chats on a regular schedule and entered the messages in a spreadsheet. It was basically our logbook for the machines and the spreadsheet was also our task-list.
After our "GO365"-campaign, as our management staff called it, this solution was gone. I found out about Power Automate recently and tried to replicate this with Teams and Excel. It works with "when I am mentioned in a channel message" and an "add row to table".
My problem: 
is it possible to split the message body, so that I get a nice looking spreadsheet?
On the Google solution, the message was filtered for a vertical stroke. Every vertical stroke means a new column. That way we got: Plant ID|Machine ID|Machine name|problem type|problem|solution|status|person, the task is assigned to. 
Can you help me with that?

Thanks in advance!

5 REPLIES 5
nandan
Helper I
Helper I

I am not sure I understand your problem. There is a split function in that can be used on a separator
image.png You are probably aware of it.

 

Another way to do it in a good way, is to use adaptive cards in teams. 
image.png

TheAlf
Regular Visitor

Thanks for the quick response!
As I wrote above, I learned to know Power Automate just recently and only dipped my toes there.
My problem is: I have a dynamic content (message body), that needs to be separated into multiple parts to be written in several columns in excel. 
I hope, that makes the question a little bit better understandable 😄 To make things even worse: I am a native german speaker and, for no reason, my company decided to set our Office 365 language to German and lock the language settings for us mortal users :') That makes things a little bit harder to try out. But never mind, your help is very well appreciated!
I tried the split function, but probably the dynamic content has to be written in a string variable beforehand, am I right?

 

@TheAlf  you can configure the actions in flow as below screenshot

 

annajhaveri_0-1615210523035.png

 

 

1. Add Initialize Variable action, provide a name to the variable, select type as Array, and use following expression in the value property

split(triggerOutputs()?['body/body/content'],'|')

2. Add apply to each action, select the Array variable from dynamic content 

3. Add "Add a row into a table" action inside apply to each action, and select Current item (apply to each) from dynamic content to get the split data value.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.
TheAlf
Regular Visitor

@annajhaveri 
I tried your solution, but it is not working yet. 

2021-03-10 09_19_23-Flow bearbeiten _ Power Automate und 14 weitere Seiten - Geschäftlich – Microsof.png

I get a "Bad Request" Error on the initialisation, when I test this setup. It says, that the variable with the type Array cannot be initialised or actualised with a value of type string. 

@TheAlf  you need to provide the expression from dynamic content -> Expressions, please see screenshot below

 

annajhaveri_0-1615380063952.png

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

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.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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.

Users online (2,364)