Answered

How to loop all tables in GetTables function?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have the following Flow:

I have a "GetTables" function that reads from a specific Excel file. I want to loop through each table and then read all rows from each table in order to make some operations.

The "Apply to each" gets the value from "GetTables" function.

How can I achieve this?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (2)

Sort by

v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

If you want to loop through each table and then read all rows from each table in order to make some operations.

Please add a "Get rows"action inside the "Apply to each" , and refer to screenshot below to create the flow:

Best regards,

Alice

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Alice. Thank you for your answer.

With this solution, I can't get the Filter result in a next step. See:

How can I get in my "Select 2" the output value of the loop?

Thanks!

Was this reply helpful? Yes No
v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

If you want to use the output value from the Filter Array in the loop, you could move the "Select 2" under the "Filter Array" inside the loop.

Best regards,

Alice

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Alice
It's not working like that:
As you can see, I can't see the Output variable...
What I'm doing wrong?

Was this reply helpful? Yes No
Verified answer

v-yuazh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

Please move the "Select" and the following actions to under the "Filter Array" inside the loop.

Best regards,

Alice

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
I ended up doing the complete operations inside the loop, as the Outputs where not visible outside the loop, But this is useful as its is.

Alice, thank you for your help. It has been really helpful.

By the other hand, I'm trying to compare to a null string, with no luck. I put this code inside a Filter:

@not(empty(triggerBody()?['CADUCA']))
In order to filter all not null values in 'CADUCA' column. But with no luck. It doesn't filter anything at all. Any idea?
Thank you!

Was this reply helpful? Yes No
v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

If your first problem has been solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

And for your question to filter all not null values in 'CADUCA' column, please create a new forum for the issue with the screenshot of your flow.

Best regards,

Alice

Was this reply helpful? Yes No