web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : Znn++EB4+mRVMd8UHWiUdP
Power Automate - General Discussion
Answered

Need help with List rows present in table

Like (0) ShareShare
ReportReport
Posted on 12 Feb 2022 01:23:04 by 5

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:

flow.JPG

 

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

teams.JPG

 

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.

input.JPG

 

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. 

tabla.JPG

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

  • Mister_Shaik Profile Picture
    1,006 on 21 Feb 2023 at 03:09:57
    Re: Need help with List rows present in table

    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.

     

    Filter 2 Expression.png

     

    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.

  • Community Power Platform Member Profile Picture
    on 21 Feb 2023 at 01:28:44
    Re: Need help with List rows present in table

    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.

    Weixuan_Chen_1-1676942680942.png

    Weixuan_Chen_0-1676942520254.png

    Weixuan_Chen_0-1676943976099.png

     

     

    Weixuan_Chen_1-1676944043975.png

     

     

     

  • scueter Profile Picture
    5 on 14 Feb 2022 at 02:00:12
    Re: Need help with List rows present in table

    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

  • Verified answer
    Mister_Shaik Profile Picture
    1,006 on 13 Feb 2022 at 04:59:38
    Re: Need help with List rows present in table

    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,

     

    1. Create a string variable to store all your table data,
      1. initialize variable.PNG
    2. Add a "Parse JSON" action to get the parsed output of your table data, and the schema is the output of "List rows in a table" action without the Odata tag,

     

    {"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"}]}}
    ​

     

    2. parse json.PNG

    • Now you can use a append to string variable to format and store all your data. The data is output from the Parse action. I've added breakline html tags to make it look cleaner. Also you don't need to add the "Apply to each" loop manually, once you try adding data from parse action, the loop will get automatically attached.
      3. create variable.PNG
    • Now you can use the data from the variable in your "post a message" action,
      4. post message.PNG

    Here's a screenshot of output on teams from a test I've run,

    output.PNG

     

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete