Hi, So I have a couple of tables:
[Table A] is my main entry table where I manage all of the data, one of the editable columns in Table A is “status”, status is an enum that can be “On time” or “Past Due” or “Closed”.
[Table B] is a reference table and is used to populate a calendar view, note Table B is not accessible and it’s entries are only automatically made via Workflow actions. There are 3 entries in [Table B] for each entry in [table A]
I am trying to create a new Workflow Action that when you go to edit a Table A part. (for example you go edit line 5 of Table A which has Serial No. 1234, the Workflow will find the 3 entries in Table B and change their status (that was copied originally) to the new status.
So far I have the following (which does not work):
- WorkFlow: Update Child Events:
- When TableA gets updated:
- Do Action: UpdateCall
Action UpdateCall on TableA:
For a Record on TableA
Do this: Data execute an action on a set of rows from reference TableB
Referenced Rows = LIST([Serial No.]) //(I want to find all the rows in TableB that have the same Serial No as TableA)
Refrence Action = UpdateStatusTableB
For a Record in TableB
Do this: Set the values of some columns in this row:
Set these columns: [Status] = text(SELECT(TableA[Status], ([Serial No.] = [_THISROW].[Serial No.])))
This doesnt work.