automation to create/update workflow with parent and child record

Hi. Can someone tell me what is wrong with this process ? 

My trigger [Status] initial value is "" (blank)

When the parent form is saved, i setted up the behavior in ux view to a data action. The data action is : set values of column row [Status] > "Run"

Then I have an automation where the condition is [Status] = "Run".
My issue is that the form saved behavior do not work, when I create or update a row my [Status] column don't change to Run so the automation don't start, but I don't really know why.

trigger : 

GFormMLH_0-1680680989033.png

UX form saved action : 

GFormMLH_1-1680681024765.png

Action : 

GFormMLH_2-1680681053760.png

Automation: 

GFormMLH_3-1680681087023.png

 

 

 

 

Solved Solved
0 7 206
1 ACCEPTED SOLUTION


@baba_sawane wrote:

My issue is that the form saved behavior do not work, when I create or update a row my [Status] column don't change


 

Also please check whether you have set up the event action on a correct form. In the image shared, you are using the system generated form and you are setting the action on this form. Please ensure that form you are using in actual app and not some other form on slice on teh table or manually generated form.

View solution in original post

7 REPLIES 7

Please try the below condition instead of [Status]="Run"

AND([_THISROW_BEFORE].[Status]<> [_THISROW_AFTER].[Status],  [_THISROW_AFTER].[Status]="Run")

Hi @Suvrutt_Gurjar , thanks for your idea ! I tried, without success. 

When doing a form with only one child record, there are only two changes in sync queue : 

  1. Save parent record
  2. Save child record

But my action gets ignored somewhat ๐Ÿ˜ฎ

I checked my slice actions and it's there

I also tried to manually launch the run action and it works... but i want it to be automatic when saving the form

Could you update what is the "Clear The trigger" step in the automation?

Of course : 

GFormMLH_0-1680684208246.png


When the event is triggered, initial trigger returns to default value and after that the pdf is generated


@baba_sawane wrote:

My issue is that the form saved behavior do not work, when I create or update a row my [Status] column don't change


 

Also please check whether you have set up the event action on a correct form. In the image shared, you are using the system generated form and you are setting the action on this form. Please ensure that form you are using in actual app and not some other form on slice on teh table or manually generated form.

face-palm-scherezade-shroff.gif

I - i have โ€ƒno words except thanks a lot !

You are welcome. No problem. We all err once in a while. 

 


@baba_sawane wrote:

When the event is triggered, initial trigger returns to default value and after that the pdf is generated


Also it may be a good practice to set the step to reset the trigger after the PDF is generated. You may need to test it though. 

 

Top Labels in this Space