Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 6nx+vAWJl5+DyUvJVEukvA
Power Automate - Building Flows
Answered

how to show output of "List Row Present in a table"

Like (0) ShareShare
ReportReport
Posted on 15 Dec 2022 22:45:31 by 235

Hi, I have a flow that triggers when file is loaded on share point library. 

 

Flow: Get's file -->Creates Table-->Gets Table -->Uses an action "List Row Present in Table" 

 I want to append this Data to my list on sharepoint. Before I add the data to the list, I am using "Compose" action to test what outputs look like. In the input section of "Compose" action - (Dynamic Content) I was expecting to see "List Rows Present in a table" where I would choose the columns I created earlier. However, I only see "Current Item" option (as in image 2 below).

 

Summary: I just want to show the output of "List Rows Present in Table" before I can add it to list. 

 

Sorry for being so confusing lol! 

 

 

tanveal_1-1671143712677.png

 

 

tanveal_2-1671144047259.png

 

  • Verified answer
    v-bofeng-msft Profile Picture
    on 16 Dec 2022 at 03:20:04
    Re: how to show output of "List Row Present in a table"

    Hi @tanveal ,

    Should I initialize the variable after "get tables" action? 

    vbofengmsft_0-1671160793765.png

     

    and does the name of the variable be same as "table name" ?

    NO, that is not necessary.

     

    Best Regards,

    Bof

  • hongdet Profile Picture
    133 on 16 Dec 2022 at 03:06:32
    Re: how to show output of "List Row Present in a table"

    *EDIT START*

    Sorry! I think I misread your requirement, please refer to answer provided by @v-bofeng-msft . Don't let mine confuse you 😛  

    *END EDIT*


    Hi @tanveal ,

     

    Yes indeed, your flow does look quite weird. 

     

    I don't think you should even place a "List rows within a table" inside an "Apply to each". It doesn't make too much sense I guess to get all the row over and over again. The "List rows within a table" action would have already obtained all the row within the table and get it ready to be used. 

     

    If you would like to identify a specific row to be updated, simply add a "Update a row" action.

     

    • Key Column <- The column you need to select needs to contain something unique (eg. Serial Number Column)
    • Key Value <- The value that you would like it to do the lookup (eg. Serial Number) 

    hongdet_1-1671159872707.png

     

    Hope I get your question right 🙂

     

    BR,
    hongdet

    _________________________________________________________

    If I have answered your question, please mark your post as SOLVED.

    Solved questions helps users in the future who may have the same issue or question quickly find a resolution via search.

    If you liked my response, please consider giving it a THUMBS UP. Thank you! 

  • tanveal Profile Picture
    235 on 16 Dec 2022 at 03:05:52
    Re: how to show output of "List Row Present in a table"

    thanks, should I initialize the variable after "get tables" action? and does the name of the variable be same as "table name" ?

  • v-bofeng-msft Profile Picture
    on 16 Dec 2022 at 02:56:20
    Re: how to show output of "List Row Present in a table"

    Hi @tanveal ,

     

    We can't get the return value of the action inside the loop outside the loop , but we can use variables to pass values.

     

    1\Initialize a variable of type array before executing the loop.

    2\Assign a value to this variable in the loop

    3\Call this variable outside the loop

     

    Best Regards,

    Bof

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 87

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard