Flow Designer - Cannot find the Requested Item Table

[Jerry kk Wong]

Hello, 

Can i ask the community for assistance as im trying to create flow via the Flow Designer and i cannot find the Requested Item Table as i need to perform a trigger and update on the record.

Thanks for your help all.

Jerry

[Maik Skoddow]

Hi @Jerry Wong 

you cannot select table sc_req_item for a "Updated" or "Created" trigger. This is because there is the "Catalog" trigger which you have to take instead.

If you want to react on RITM changes, you can implement Business Rules.

Kind regards
Maik

If my answer replied your question please mark appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.

[Jerry kk Wong]

Thank you @Maik Skoddow  for your help.  I have tried using a business rule to remove the on hold reason when the state changes from on hold to in progress.  This works from the UI form however when the customer is updating from the self-service portal form then the business rule does not work.  We have had similar issues with the incident form and used the flow designer to fix this issue.  Are you able to offer further suggestions on what i could try please?

[Maik Skoddow]

Hi @Jerry Wong 

are you sure, that your question is about records from table sc_req_item? It is rather unusual to have RITMs with a state "on hold".

And your statement regarding the Business Rule is also strange, because a Business Rules doesn't care about on which experience a record has been updated.

Kind regards
Maik

[Geoff_T]

Hi,

Yes sc_req_item is not available. As a workaround for a problem I had to solve just this week; I ended up creating a business rule on the table and called a flow from that using the FlowAPI.

Might be an idea 🙂

Geoff