Filter for Bot - Multiple children failing

[StephenSaid]

When I have more than 1 item related to a parent, I am getting the following error:

It seems to be working fine with one item!

The two keys listed are the correct keys which I need to update. 

I can't figure out what is wrong now!

[Suvrutt_Gurjar]

If you could share more details on bot configuration right from bot -> Event> Process -> Step with maybe parent /child table names and their relevant column details with what you are trying to achieve with the bot, the community could help better.

[StephenSaid]

@Suvrutt_Gurjar 

Sure thing. Thanks for coming back to me about this.

The Event is triggering on Table updates only.
Table: TransferHeaders (this table contains the parents)
Condition:  

AND(
[_THISROW_BEFORE].[Status] <> [_THISROW].[Status],
[_THISROW].[Status] = "Submitted"
)

I have two process being run:

1. Update QtyCheck (this is the problem)
2. Send a notification (this is working. at least when QtyCheck works)

QtyCheck 

This calls a process called 'Update QtyCheck'.

The Lookup expression is:

ref_rows("Transfers", "TransfersHeaderID")

Update QtyCheck process

This Process is based on the table called 'Transfers'. This table contains the children. 

I think I provided all the info. Let me know if I missed anything.

Thank you for looking into this.

[Suvrutt_Gurjar]

Thank you for the details. Is it correct understanding that you wish to update two columns [QtyCheck] and [Checked] in all the related rows of the child table "Transfers" from the parent table "TransferHeaders" [Quantity] column and [Checked] to "No when the [Status] column in the parent table changes to "Submitted"

[StephenSaid]

@Suvrutt_Gurjar 

Almost.

I want to update two columns:

[QtyCheck] from [Quantity] in the same Transfers table
[Checked] simply setting it as false... this is not necessary, since the initial value is already false.

[Suvrutt_Gurjar · Accepted solution]

Okay, thank you. I think you could achieve this with a "Run Data Action " step in the bot.

So the process of the bot could look like below

In the above screenshot [Related Transfer Details] is the reverse reference column in the "TransferHeaders" table that references child table "Transfer"s records. Please change with the actual name you have for that reverse reference column. I think it will be [Related Transfers]

And the referenced action "Set Quantity" could look like below. Please create it under the Behavior -> Action option.

[StephenSaid]

Thanks. That worked as expected.

Learned something new again.

[Suvrutt_Gurjar]

You are welcome. Good to know it works per requirement.