Hello,
I have a project table and a Data table which contains a reference to the project table, I would like to create an automation which each time a new Project is created adds data to the Data table, I manage to do it except for the project column ( of ref type) of the Data table where I would like to add the name of the project created (which triggers the automation) The table selected for Add row to this table is Data and I cannot find the expression which will allow me to insert the name of the project created in the Project column.
Thanks in advance for your help.
Solved! Go to Solution.
Have you tried setting the expression simply to [_THISROW] or [_THISROW].[ROW ID]? Note though that this assumes a relationship as in Key Value from the other table vs just the name of the Project.
Are you utilizing the function 'create a row in another table using data from this row' in your automation?
No, I am creating an automation with data adds ( in the Projects Table) as the trigger event. Using the action add a new row to another table using values from this row will not allow the automation I need
Would highly suggest posting some screenshots with sensitive information redacted. Otherwise my only suggestion is using MAXROW() in conjunction with a column [CreatedTimestamp] to fetch the last row created in the other table. However, depending on how many people create records in that table at the same time, you could accidentally link wrong records because of syncing to tables from different users. Using an additional filter in MAXROW() that filters on the [_UserEmail] should help with that though.
Here are some illustrative images, my current problem is that I cannot define the name of the project recently created as a value for the Project field which is of reference type, in the Data tablethe project table
the data table
the trigger event
the process to run
Have you tried setting the expression simply to [_THISROW] or [_THISROW].[ROW ID]? Note though that this assumes a relationship as in Key Value from the other table vs just the name of the Project.
Thanks a lot, just adding the expression [_THISROW] it works!
User | Count |
---|---|
19 | |
13 | |
8 | |
3 | |
2 |