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

(0) Share

Report

Posted on by tanveal

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!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
tanveal 235 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
hongdet 133 on at

Like (0)

Report
Copy link

Link copied!
*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)

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!

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @tanveal ,

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

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

NO, that is not necessary.

Best Regards,

Bof

Was this reply helpful? Yes No