Action to create multiple Data Rows in Child Table

[Domearian]

I have a table of TBT documents and a separate table of Employees. I hold another table that records which employees have read which document (TBT Reads).

With this, I have a Virtual column in the TBT Documents table that checks who has not read the documents:

FILTER("Employee",TRUE) - SELECT(TBT Reads[SQEP List ID], [TBT Ref] = [_THISROW].[Unique ID])

I want to create a simple action that will copy TBT Document Field information for every employee that has not read the document into the TBT Reads data. The list of unassigned employees is already shown already created with the formula above.

[WillowMobileSys]

---

@Domearian wrote:

I want to create a simple action that will copy TBT Document Field information for every employee that has not read the document into the TBT Reads data.

---

It's not clear what this means/will do.  When you copy the information into the "TBT Reads" table, will it affect the virtual column of  Unassigned Employees?

Typically, you would use the "execute an action on a set of rows" type action and use your column with the list.  I assume, with your experience, you have already tried this and ran into an error?

If you use the Virtual Column and it is impacted by your action changes, I believe it would result in an error because the list would be constantly changing.  I have not totally investigated this so not 100% certain.  I just know some have encountered the "index out of range" error which I think was caused by the VC changing mid-execution.

If you were to , instead of the VC, replicate the exact same expression, MAYBE that avoids the error.  My thought is that this expression is executed once at the beginning of execute providing a static list to operate on.  But again, not certain.

I hope this helps!

[Domearian]

It does help yes. The VC is simply a by product of the expression and simply allows the user to see who has not currently been assigned the TBT Document.

The aim is to create an action that would assign the selected TBT Document to be assigned to all the users not yet assigned. By this I mean the results of the expression:

FILTER("Employee",TRUE) - SELECT(TBT Reads[SQEP List ID], [TBT Ref] = [_THISROW].[Unique ID])

The expression itself will look at all the employees in the employee Data and subtract the employee ID ([SQEP List ID]) where the [TBT Ref] in TBT Reads Data is equal to the selected TBT Document [Unique ID]. I didn't think it would be easy to create a action that would run through each employee to check. 

So we have 3 different data sources to examine for the action [Employees], [TBT Documents] and [TBT Reads].  Is it even possible?