Trouble understanding "call a process"

[eddie61]

Hi all

I've set up the following bot:

Show More

Event: Monatlicher Export -> Trigger Monthly Schedule

Process:

Task 1: Generate Excel Zeitlog -> Generates a .xlsx file from a sliced "Zeiterfassung" table (<- this works fine, each time i "Run" the bot)

Task 2: Call a process -> Call process "Change genehmigt to exportiert"

Process "Change genehmigt to exportiert"

Table: Zeiterfassung

Action: Run action on rows

Referenced Table: Zeiterfassung

Referenced rows: 

FILTER(
 "Zeiterfassung",
 [status]="3-genehmigt"
)

Referenced action: "Set exportiert"

 

Action "Set exportiert": Data: Set the values of some columns in this row

I'm unsure what to add to the call a process window. My goal is that the .xlsx file is generated (which works) and then it should just invoke the other process, changing all the [status] values of the filtered rows. I get the following error in the monitoring app:

I struggle to get my head around this "call a process". Hope I could explain my bot and my problem somewhat and would appreciate some guidance.

Thanks in advance.

Adrian

[WillowMobileSys]

The message is explaining that the column "projektid" in the row with key "2e91a397" either

1) has "Required" turned on and is NOT being set

OR

2)  has a "Required_IF" expression and the assigned value(s) do not satisfy the expression.

Even in automation, when assigned values,  all column properties for Valid, Required, Editable and the like are still honored.

[eddie61]

Thing is that, a row with the key "2e91a397", doesn't exist in my database. My guess is that the app tries to add a new row. But what I want is, with the process that I added in the "call a process", to get a list of all rows that match the condition and then change the column [status] of all these rows.

What I'm not sure is, what I have to do in the "call a process" step. I tried picking "Lookup" but then I need to add columns and values to it. But I simply want to "call a process".

I start to think that I'm getting this whole "call a process" wrong.

[WillowMobileSys]

The row wouldn't appear in the datasource if it was a new row being added.  The error prevents that.

Please show us what you have so far for the automation so we can guide you in what to change.

[eddie61]

I put the bot / automation in the "Show More" tag in my first post.

[eddie61]

I try to explain my problem a little better.

I have this bot (the one I put in the Show More tag) on my first post. The bot basically just generates a .xlsx file on a monthly schedule.

What I know try to do is the following:

1. The bot creates the .xlsx file at the beginning of the month (this works)
2. The same bot should trigger a process that changes values of rows that I filter with the following formula: 

FILTER(
 "Zeiterfassung",
 [status]="3-genehmigt"
)

Normally, I would do this with a "run a data action" step. But upon choosing "run a data action", the view on the right, where normally you can choose the step settings, is empty.

So I tried integrating this "run a data action" step in another process and used "call a process" to call this new process. Unfortunately, it seems I have to pass on some values, but I can't figure out how this works, as I don't need values to pass to the other process.

Am I completely getting this "call a process" wrong?

Any help is much appreciated.

Adrian