Hello Everyone
I have requirement when Sc_task's work note updated and if it contains the text ' file creation failed' need to create the incident using flow designer.
I tried it but its not working as expected can you please help me on that and have look at below screen shot.
do this as alternative and it should work fine for you
1) create flow variable of type True/False
2) then use Set Flow Variables flow logic to set that flow variable based on matching condition
3) then use that Flow variable in your IF logic
If my response helped please mark it correct and close the thread so that it benefits future readers.
To implement your requirement, here are the detailed steps to create a flow that triggers when a worknote containing "file creation failed" is added to a Catalog Task.
1. Create a Flow with the Following Trigger:
Trigger: Updated
Table: Journal Entry [sys_journal_field]
Condition:
Name is sc_task
Element is work_notes
Value contains file creation failed
This will ensure that the flow triggers whenever someone posts a worknote on a Catalog Task containing the text "file creation failed".
2. Add the Following Steps:
Step 1: Lookup Record Action
Add an action to Lookup Record in the Catalog Task Table (sc_task).
Set the filter condition:
Sys ID = Trigger - Record Updated > Journal Entry Record > Element ID
Item = {SELECT YOUR REQUIRED CATALOG ITEM}
- Set Don't fail on error as checked
This step will fetch the Catalog Task record associated with the worknote, but only if it's for the desired catalog item.
Step 2: Add an IF Flow Logic
Add an IF flow logic to check if the record exists.
This ensures that an Incident will only be created for the Catalog Task associated with the specified catalog item when the worknote contains "file creation failed"
Step 3: Create Record on Incident Table
Under the IF condition, add the action "Create Record" on the Incident table.
This action will create a new Incident record based on the conditions you’ve set.
Successful Execution Screenshot
Here’s a screenshot of the flow successful execution:
Positive case:
Negative Case: when the catalog item was not the selected one
If my response helped, please mark it as the accepted solution so others can benefit as well.
Hence this is your only way to use CONTAINS operator on sys_journal_field like in your case in flow designer, work_notes to check the CONTAINS text.
To implement your requirement, here are the detailed steps to create a flow that triggers when a worknote containing "file creation failed" is added to a Catalog Task.
1. Create a Flow with the Following Trigger:
Trigger: Updated
Table: Journal Entry [sys_journal_field]
Condition:
Name is sc_task
Element is work_notes
Value contains file creation failed
This will ensure that the flow triggers whenever someone posts a worknote on a Catalog Task containing the text "file creation failed".
2. Add the Following Steps:
Step 1: Lookup Record Action
Add an action to Lookup Record in the Catalog Task Table (sc_task).
Set the filter condition:
Sys ID = Trigger - Record Updated > Journal Entry Record > Element ID
Item = {SELECT YOUR REQUIRED CATALOG ITEM}
- Set Don't fail on error as checked
This step will fetch the Catalog Task record associated with the worknote, but only if it's for the desired catalog item.
Step 2: Add an IF Flow Logic
Add an IF flow logic to check if the record exists.
This ensures that an Incident will only be created for the Catalog Task associated with the specified catalog item when the worknote contains "file creation failed"
Step 3: Create Record on Incident Table
Under the IF condition, add the action "Create Record" on the Incident table.
This action will create a new Incident record based on the conditions you’ve set.
Successful Execution Screenshot
Here’s a screenshot of the flow successful execution:
Positive case:
Negative Case: when the catalog item was not the selected one
If my response helped, please mark it as the accepted solution so others can benefit as well.
