Flow script to send payload based on condition

[CV1]

Hi All ,

I need to execute a flow based on Project Type is not one of a,b,c (if project type is not a,b,c then execute the flow)

 Trigger
Create or update
table AA
condition
State - changes to -True [AND]
SampleID - is not empty [AND]
Table AA . Project Name.Project Type - is not one of - A,B,C

In the trigger along with other conditions , i added Project type - is not one of - A,B,C

• when I try to execute , the flow does not execute.
• when I remove the project type condition it executes
• The condition is not satisfying properly ( it runs for all projects not filtering the condition)

Please guide how this can be handled or a sample script before payload to check the project type and then send the payload?

TIA 

[Amit Verma]

Hi @CV1 

Can you please put this condition in this way like Project Type is not A OR Project Type is not B OR Project Type us not C and try triggering the flow ?

Refer below snip for reference :

Please mark the answer as helpful and correct if it solves your problem.

Thanks & Regards

Amit Verma

[Maik Skoddow]

Hi @CV1 

dot-walking in Flow triggers is not possible (as you already found out).

Instead, use an if condition at the beginning of your Flow to exclude the certain project types. Then end the Flow if required.

Maik

[CV1]

Hi,

Tried both the above in the trigger but  still did not address the requirement (not filtering the condition).

Is there a way we can check in action to send payload only if the Project Type is one of (A,B,C) else ignore?

TIA

[Amit Verma]

Hi @CV1 

You can achieve this in an action as well. You can iterate through the table to get the value of variable Project Type from your newly created record and write a simple if condition to check if the value is not equal to A OR B OR C.

Thanks & Regards

Amit Verma