Copy only the rows with data from table to another table

(0) Share

Report

Posted on by frixel

969

Hi all,

I will copy only the rows with data from a table to another table.

I think i must make a filter array but where and what is the command for to do that🙄

Categories:

Building flows

I have the same question (0)

All responses (20)

Answers (1)

manuelstgomes 6,625 on at

Like (1)

Report

Re: Copy only the rows with data from table to another table

Hi @frixel

Try this:

You can add all the fields you want to check or only a few.

Can you please check if and let me know if you have any questions?

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
frixel 969 on at

Like (0)

Report

Re: Copy only the rows with data from table to another table

Hi @manuelstgomes

Thanks for your quickly response.

What do you mean with the "Own"?

Was this reply helpful? Yes No
frixel 969 on at

Like (0)

Report

Re: Copy only the rows with data from table to another table

Hi @manuelstgomes

I don`t have "fields" in my 'Dynamic content" like the Colomn names.

Was this reply helpful? Yes No
chrissahagun 197 on at

Like (0)

Report

Re: Copy only the rows with data from table to another table

I'd say yes, filter array. Make the condition "is not equal to" and leave the value blank.

Was this reply helpful? Yes No
chrissahagun 197 on at

Like (1)

Report

Re: Copy only the rows with data from table to another table

I think the input of your Apply to each must now be Value from your Filter Array, not from List Rows

Was this reply helpful? Yes No
frixel 969 on at

Like (0)

Report

Re: Copy only the rows with data from table to another table

@chrissahagun @manuelstgomes

I don`t have a Value from the Filter Array.
I don`t understand what to fill in the Filter array, do you that mean with 'let it blank'?

Was this reply helpful? Yes No
frixel 969 on at

Like (0)

Report

Re: Copy only the rows with data from table to another table

@chrissahagun @manuelstgomes

I have now this but always the empty rows in the table.

Was this reply helpful? Yes No
chrissahagun 197 on at

Like (1)

Report
Re: Copy only the rows with data from table to another table

To Clarify...

In Filter Array:
First box: any column in your dynamic content "List rows present in a table"
Second box: "is not equal to"
Third: <leave this blank>

In Apply to Each:

input is "Body" from Filter Array.

And then in assigning values to each column in "Add Row To Table", use the expression:

items('Apply_to_each')?['put_your_colum_name_here']

Was this reply helpful? Yes No
frixel 969 on at

Like (1)

Report

Re: Copy only the rows with data from table to another table

@chrissahagun @manuelstgomes

Now i get this 😥

Was this reply helpful? Yes No
chrissahagun 197 on at

Like (0)

Report

Re: Copy only the rows with data from table to another table

Note my blue ink... do that. 🤞 And don't forget to make it "not equal to"

Was this reply helpful? Yes No