Hello everyone.
First time posting.
So first, it's very likely that my solution involves coding which is ok, but I have really basic knowledge about it so please take it easy on me and please, forgive me.
So just for context, my flow begins with someone filling a form, asking to look for an ID that may be in 2 tables from two diferents excel, after submitting the form, It will then send a Microsoft Team's chat with the information of some of the columns from the last row found that matches with that ID from one of those tables.
This is the flow:
Enumerar filas is the "List rows present in table" flow. Publicar mensaje en un chat is the "Post a message to a chat or channel" flow.
In those tables, that ID may repeat many times so I first fixed the "get the last row of this ID from this table" so that is ok now.
Now the problem is that I have totally no idea how to organize the data that "List rows present in table" gives me with the "Value" dynamic content.
I would like to make it easy to read but instead it returns with the following data
{"body":{"value":[{"@odata.etag":"","ItemInternalId":"19716ccb-1142-4025-a8e1-e6f6d2c15ccc","GESTION":"GESTIONADO-LEIDSANC","Solicitud":"EL CLIENTE REALIZO UNA TRANSFERENCIA DESDE LA CUENTA MAESTRA , SALIO EJECUTADO PERO NO DEBITADO DE LA CUENTA ","FITEXT":"02/10/2022 10:26 AM"}]}}
And in Microsoft teams it shows like this
I have read that I may need to use the compose flow, set the input to be the "value" and it may fix itbut... literally have no idea how to, beacuse after selecting value nothing happens or nothing else enables.
I also tried with "Create CSV table" that showed me kind of what I wanted it to be in the Teams message but didnt't work minus the first 2 rows that you can see in the picture.
Something else I wanted to point out is why in the left side it forces me to create the next flow within "Apply to each one" after selecting the dynamic content "Value", while the right one doesn't, I mean they work both fine but it is weird and I am just curious.
So now I am here asking for some help about how to improve my flow!
Thanks a lot for the help
Hi @Anonymous ,
That's an expected error, because the data returned from excel will always be considered as text. To fix this, you can use the type casting function "float", to convert the string into a decimal number.
Hope this helps 🙂
Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Hi Shaik, you're super professional and helpful on this.
I'm actually with a call center project along with many performance & ticket data dump.. I saw your reply for @scueter and make a same flow based on your steps and tested working.
My question is that how do I add some conditions? for example, if someone's untouched days greater than 5 days, they will receive a Teams ping? Basically it will be very helpful if you can let me know a way that use Excel table to make Teams notification when conditions are met.
Thank you a lot!!! Like a lot!!! I love you haha.
You are the best. Have a good day man!
Amazing help, detailed and step by step.
Just to add, in case anyone else needs this, in the "append to string variable" step you have to type it as html text, otherwise the dynamic content from JSON won't work (at least for me), but it was as simple as just adding a
<p> text <br>
text... </p>
Thanks again Shaik!
Greetings
Hi @scueter ,
I understand that you're trying to get the data from a ""List rows in a table" action and then send it to someone over the teams using "Post a message in teams chat or channel". Although if your Table is properly built on excel, it should give you the column names in output of your "List rows in a table" action. But assuming that you're only getting the "body" and "value" as the outputs, you can something as below,
{"body":{"value":[{"@odata.etag":"","ItemInternalId":"19716ccb-1142-4025-a8e1-e6f6d2c15ccc","GESTION":"GESTIONADO-LEIDSANC","Solicitud":"EL CLIENTE REALIZO UNA TRANSFERENCIA DESDE LA CUENTA MAESTRA , SALIO EJECUTADO PERO NO DEBITADO DE LA CUENTA ","FITEXT":"02/10/2022 10:26 AM"}]}}
​
Here's a screenshot of output on teams from a test I've run,
Hope this helps 🙂
Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2