AddRow should return the row just added, not the "action"

Given that the default formula for Activating a row after adding it is

Activate(AddRow([My Table]))

You would think that AddRow returns the row that was just added. However, that seems not to be the case, rather it seems that it returns the action. So, this works as you would expect:

WithName(AddRow([My Table]), deal, Activate(deal))

But,

WithName(AddRow([My Table]), deal, 
  AddRow([Other Table], [Other Table].[Creation Date], deal.[Creation Date])
)

Does not work.

I’m trying to get the Url of the new row so that I can open it with a specific layout.

2 Likes

Current workaround for this issue is to grab the most recently created row from the table. But that’s not an ideal solution due to race conditions.