I don’t think my issue here is that I’m trying to update columns in the same table (or is it?), I think I’m just missing something painfully obvious here. I do realize that I can (kind of) accomplish a similar approach without the use of actions/automations whatsoever, but please trust that this is the way I want to proceed here.
I have minimized my app down here to simply address my desired automation, which is as follows: users (self-service) define that they are in “Needing Help” (this part is actually not really pertinent this very moment as I am not yet incorporating it). Conversely, a user (in the same table) can be someone providing said help, by picking the users they want to help, which is stored in column “Providing Help To” (this is simple and working as desired). When a user needing help has been tagged by another to receive help from, ultimately I want the user in Need to be notified, but let’s just start simple, with recording the data in a column “Getting Help From”- and here is where my automation isn’t working.
I know that I want to use Data: execute an action on a set of rows (my action named “Update-Rows”, with Referenced Rows= SELECT(Testing[Name],([Providing Help To]=[_THISROW].[Name]),TRUE) because 1) I want to change rows other than what the user is entering and 2) I want this to support multiple selections (a user can provide help to multiple in need). It feels like I am getting step (action) part of the automation correct and that it must be breaking down with my 2nd action of Data: set the values of some columns in this row (my action named “Update-GetHelpFrom”, with Column Expression = ANY(SELECT(testing[Name],[Providing Help To]=[_THISROW].[Name])). Hopefully these screen captures help explain the situation:
