Trigger adding a value to another table

[Colin_Lough]

Hi,

I’m trying to add a value to another table when a new user is added to my ‘users’ table. Based on the email added in the users table, I’d like to add this same email into the ‘filters’ table.

I have this workflow…

and this action…

Upon adding a new user to the users table, the filters table is not updated.

[James_McFarlane]

Hi @Colin_Lough,

You can accomplish by adding the action to form saved action. Add the Add new user to filter table action to the Event Action: Form Saved on the Behavior section.

[Colin_Lough]

Thank you @James_McFarlane.
Where I have ‘test@email.com’ listed as the new value of the useremail column, what would be the expression used to find the most recently added value of the ‘useremail’ column in table ‘users’

I’m looking at maxrow() but can’t figure that one out.
Thanks

[khuslid]

Easiest way to find the latest record is to add a column with “Reset on edit” and initial value “NOW()”

[Steve]

Colin_Lough:

what would be the expression used to find the most recently added value of the ‘useremail’ column in table ‘users’

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), "My Table", "_ROWNUMBER", "Wanted Column" ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()

[khuslid]

I did this. From ACCES to FILTER
Used the action: Add a new row to another table using values from this row.
Then the value Email to Filteremail. (I made a REF from ACCES table)
And then only if this condition is true:
NOT(IN( [Name.[Email], FILTER[Filteremail]))
And I trigger the action when saving the form in ACCES.

[Colin_Lough]

@khuslid, thank you. Can you explain the 3rd point for me please?
What do you mean (I made a REF from ACCES table), where did you add that?

1. You have an access table and are updating that email address to filters table.

2. Used the action: Add a new row to another table using values from this row

3. Then the value Email to Filteremail. (I made a REF from ACCES table)
   And then only if this condition is true:
   NOT(IN( [Name.[Email], FILTER[Filteremail]))

[Colin_Lough]

Or I just missed the now completely obvious solution