Hi @Kennypurnomo
Is the content of the “SOP Category ID” field in the “SOP Inject” table all “S01.01.1”? If so, you can directly use the “SOP Category ID” field in the Find Records action, setting it equal to the variable value from the “SOP Category ID” field in the “SOP Inject” table.
However, if the “SOP Category ID” field in the “SOP Inject” table contains other values besides “S01.01.1” (e.g., “S01.01.2”), then in the Find Records action, you may not need to use the “original component” directly (e.g., SOP Category ID = S01.01.1).
the result is array empty, see below
The content of the “SOP Category ID” field in the “SOP Inject” table can be anything, see below
The setup i did as you did but no luck, see below
Did you trigger the automation by clicking “Run Test,” or did it run automatically based on the trigger conditions set in the “SOP Inject” table?
Because you have set conditions, clicking “Run Test” cannot retrieve the corresponding data, so it returns empty.
Because your automation is not enabled, you need to turn it on and ensure that the trigger meets the conditions set for your automation
I have just enabled your automation. Now, you only need to perform operations in the “SOP Inject” table to ensure the trigger meets the conditions, and the automation will run normally.
of course i tried using “run test” button before activating the automation. I believe this is the correct practice to try it first before move on to production
Hi @Kennypurnomo
This is because the Action depends on certain conditions from the previous trigger. Since those conditions are not met, clicking “Run Test” returns empty data.If you want to return data, you can remove the filtering conditions in the action
What do you mean by the condition didn’t meet? The trigger i have had a condition that i meet
Even if your trigger conditions are met, there may still be filtering conditions set in the Action. If these conditions are not met, the Action will not return data.
If you want the Action to return data, you need to remove the filtering conditions set in the Action so that the data can be returned properly.
Why i need to remove the filtering? i want to filter it! It is like doing filterByFormula = {SOP Category ID}=‘S01.01.1’.
What I mean is that if you want to click the “Run Test” button to run automation debugging and need it to return the correct data, you can remove the filtering conditions in the Action. If the conditions set in the Action are not met, the Action will not return any data
So for my case, how can i debug it? i need to find a record based on filter and then do the next action based on previous result
Hi @Kennypurnomo
Trigger the automation as configured, and proceed with debug normally
