BPA Projection Workflow to add or replace a value

Thanks, 

I tried with a process enrichment element right after I made the post and it worked!

Hi ​@CurAnneaL and ​@kamnlk I ran into a similar problem 

I created a workflow that gets triggered after a user is adds an Expense Details from the dialog. It’s a user interaction workflow because we needed the user to enter a value for a custom attribute during the creation of the expense detail. The newly created row information does not get passed into the workflow so I cannot update the custom field in the same workflow. I get the “CFT rowkey cannot be null” error.

I have got to the point where my workflow1 has exported the Process Enrichment variable for the custom attribute value after the workflow is complete but now I want to use that variable to update the newly created flow.

How were you able to use the process enrichment variable to update the custom field attribute?

Thanks for your help!

hi ​@jamie.maiquez 

its bit unclear on the requirement, can you explain more on what you are doing?  what is the projection you are using to trigger the workflow? 

if i am to guess from what i understand you could read in the newly created record inside the workflow and after the user form you can perform and update to the record.

Hi ​@kamnlk

The requirement is to force a user to enter a value for a custom attr before they can save an Expense line (for a specific expense code) from the Expense Sheet Detail page. Since we cannot add the cust attr through page configuration, we want to trigger a ‘user interaction’ workflow that will ask the user for the value right after they go through the assistant/dialog for adding/editing an expense line.

The workflow triggers on projection TravelExpensesManagerHandling on the call AddOtherExpense (this is the request made when the user enters a specific expense through the dialog).

Your solution works for editing an expense line but it does not for new lines. An “Index 0 out of range for length 0” error occurs before the Read shape because on a new row, the SeqNo is null and that is a key needed to search for an ExpenseDetail record to update.

I thought I could trigger the workflow on an ExpenseDetailEntity create call but it’s not an option when I search for it.

​@jamie.maiquez 

The tricky part is the seqno is not passed into the workflow as that is auto generated when creating the records. As a suggestion we could read in the ExpenseDetails records for the specific expense code inside the workflow and get the record with the latest sequence number (eg: sorting the records by seqno and getting the last one) then based on the information from the userform we can do the update

Hi ​@kamnlk this worked perfectly on new lines. Thank you!