Hello,
I can’t figure out for the life of me why this isn’t working. I’m running aData: execute an action on a set of rows. based on the updates on the Tool_Inputs_Seperated table. Nothing happens when I run the bot, however, when I run the action when I run on an individual row in the detail view it works great. However, It doesn’t seem to be running when the Tool_Inputs_Seperated gets new values added. These new values are added from another automation process (not sure if that matters). Please see the attached Screen Shots. I have no idea how to fix this and I’ve lost a good chunk of time fixating on it.
What is your primary key in the Tool Inventory Table?
It’s the [tool_Wnum] column
Get Outlook for iOS<>
The Execute an action on a set of rows action is expecting a list of Primary Keys for the table that you want to modify. I would suggest you make that expression a SELECT(Tool Inventory[tool_Wnum],[toolWnum]=[_THISROW].[toolWnum])
Alternatively, you could just input LIST([toolWnum]) as the list of rows to update. It should return the same as the select.
> > > > > >
Thanks for reaching out Landon. I tried your response with no luck. Here’s the formula I originally used.
Select(Tool Inventory[Active_Job_Numbers], [_thisRow][Tool_WNum]=[ID].[Tool_WNum]) The Tools separated table is the child table to the tool inventory. Greatly appreciate the time.
If you want to cover this on a virtual call, please reach out to my email: (PII Removed by Staff)
