Dear community,
I am on glide-vancouver-07-06-2023__patch9-hotfix1-05-22-2024.
We have a recordproducer that creates change requests in the change_request table.
When someone uploads a file to the catalog item form, then this attachment gets stored in table_sys_attachment with the table_name = YY_ZZchange_request. There are several documents on the web that describe this out of the box feature from ServiceNow.
I created a flow that has a trigger that when there is an update in the table sys_attachment and the field table_name=YY_ZZchange request, then the flow should adapt this value to just "change_request" to make the attachment visible in the change header.
This does not work.
It only works when I manipulate the table entry directly in the backend and write different values into the column "table_name" manually.
But when the table entry comes from RecordProducer the flow gets not started.
I realized that when I upload the attachment in the catalog form, then then entry in the table sys_attachment has the value table_name="YY_ZZsc_cart_item". And after clicking "Submit" in the catalog form, then this value gets changed to YY_ZZ_change_request.
So, I think this last update should be captured by the flow, but nothing happens.
Do you have an idea?
I attach 2 screenshot from my flow.
Many thanks
Best regards
Eckhard
