Findrow in 2 different tables

Community Discussions
,
1

I have 2 tables Table 1 and Table 2. Table 1 has incoming data and Table 2 has the data I want to keep.

I want to add an item to table 2, then with an automation delete the item from table 1(It has to exist in table 1 to be added to table 2).

I have tried in the automation to delete when row added to Table2
=FINDROW(table1,"table1[ID]=%",(FINDLASTROW(table2,"table2[ID]")))

I am obviously missing something, any help would be appreciated.

3

Hi @Buildit123,

Thanks for reaching out.

You can achieve the desired output using below query:

=FINDROW(table1,"table1[ID]=%",FINDLASTROW(table2)[ID])

Hope this helps, feel free to reach out if you have any more question.

5

Thanks, that worked.

2 Likes
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.