Flow Failure

[P1g5purt]

I have a flow that triggers on excel file changes. It works on the whole library but I use a condition to limit the flow to a sub-section of the files ( we have a strict naming convention so I can identify the relevant files ). I have a condition that, if true, leads to some actions ( updating an Excel file ) and if false , terminates the flow. The flow is recorded as failing. I don't want any further action if the file isn't a relevant file. Terminating the flow for a non-relevant file is exactly what I want it to do. I'm very new to PowerAutomate so don't know whether it's acceptable to have a flow that fails 3000 times a day ( whilst doing exactly what I want )

[Nived_Nambiar]

Hi @P1g5purt 

There are 2 options

1. Since you have used Terminate flow action at No branch of the condition - so remove it so that flow does not appear failed in Run History 

2. instead of building condition action, use the trigger condition within the trigger where we can write the expression if we need to trigger the process if modified file is having name equal to. Refer this article for more details on trigger condition and how you can use them -

https://www.spguides.com/power-automate-trigger-conditions/

In this way using trigger condition- flow won't trigger until trigger condition turns out to be True.

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[P1g5purt]

Hi Nived,

Thanks for the detailed reply. I applied a trigger condition ( I've used the condition I applied further down the flow )

This what I've used @contains(triggerBody()?['{Name}'],'Qtrly @'). I've changed a file that contains 'Qtrly @" but it doesn't trigger. I'm also getting an error message 

InvalidTemplate. Unable to process template language expressions for trigger 'When_an_item_or_a_file_is_modified' at line '1' and column '68548': 'The template language function 'contains' expects its first argument 'collection' to be a dictionary (object), an array or a string. The provided value is of type 'Null'.'.

looking at "Raw Outputs" 

"{Name}": "AWRP Mgmt Accts June 24 (IRIS) - Draft",

which doesn't appear Null?

What have I done wrong?

Regards,

Ian