How to Trigger flow when a record is created or updated in import set table

rksnow
Tera Expert

Hello, I have an import set table wherein data gets imported periodically. I have created a flow in designer to get triggered when a new record is created or updated in import set table and Run the action - update the "target record" in import set table record. But, the problem I am facing is, when the data is getting imported my flow is not getting triggered. Could you please suggest any other best possible way?

 

find_real_file.png

I tried changing the state to is "not pending" or "one of" but nothing worked.

13 REPLIES 13

Hi,

Now i will create on Transform and test this.

Thanks,
Ashutosh

Nope, It didn't work either.

Were you ever able to figure this out?  I'm experiencing something similar and am wondering if there is an issue with when the record is created on the database and when the trigger fires.  

PadmeshD
Tera Contributor

Hi @rksnow,

Use Create Code snippet on flow designer for generation of code snippet as shown below.

PadmeshD_0-1734521266394.png

 

Snippet:

PadmeshD_1-1734521409725.png

This snippet will come pre-configured with the inputs defined by your flow or subflow or action. You can then call it within an onBefore or onAfter transform script.

To implement this, simply create a new Transform Script within your transform map.

PadmeshD_2-1734521631789.png