I am struggling to iterate through a table of data from forms and do different actions based on different columns in the table. In On Prem interacting with a table from forms was done through the For Each Row activity and would present tokens for each column in the dataset regardless of what column you chose to iterate on.
In Cloud we can only use the For Each Value activity which does not allow visibility to the other columns in the table when iterating. We can only use the Current Value.
For this use case, I am trying to recreate a simple Table Maintenance form we have used frequently in On Prem. Let's say it is the list of approvers with approverDisplay, approverUser, approverID (key) and a checkbox to indicate the approver row should be deleted.
We then in WF just iterate through all of the rows and evaluate in a conditional branch whether the row indicates it should delete, add or update the data in the approver table. If the delete checkbox is checked we delete. If the key is empty we add. Otherwise we just update. I cannot get this to work in Cloud.
I've tried both passing the table data as input parameters AND writing the data to a temp table then reading from the table, but either way I cannot evaluate the entire row of data and then write it to a table.