Answered

Want a trigger condition based on words in filename

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to build a trigger condition for my flow so the flow will only trigger if the condition is met. I want the condition to be if the filename contains the word 'drivers'.

I tried using this:

@contains(triggerBody()?['Name'],'drivers')

but got the error message:

InvalidTemplate. Unable to process template language expressions for trigger 'When_a_file_is_created_or_modified_(properties_only)' at line '1' and column '17042': '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'.'.

Thanks for any help you might have!

Categories:

General topics

All responses (4)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Figured it out - I was missing {} brackets, so a simple syntax error. Once I added them in, the flow worked great!

@contains(triggerBody()?['{Name}'],'drivers')

So whenever my filename contains the text drivers, the flow will trigger.
martintillbrook 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, possibly a stupid question here but how do you create a condition that allows you to just type in "@contains(triggerBody()?['{Name}'],'drivers')"?
If i create a condition it wants a value, operator and value - ie:
Some guidance please as you are doing exactly what I've been trying to do all morning!!
Thanks 🙂
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Not a stupid question at all, and it's one that took me a while to figure out. You want to set a trigger condition, which will prevent the flow from executing at all unless this condition is met. This is different from an in-flow condition, which requires the flow to be running before it checks a condition. You would want a trigger condition to help cut down on the number of times your flow runs. Why run it if the condition isn't met in the first place?

So to set this up, go to your trigger, then SETTINGS:

then down in the Trigger Conditions box, enter the formula:

Now my flow won't run at all unless the condition is met, saving a bunch of useless runs.

Hope that helps.
martintillbrook 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Awesome, many thanks - thats worked 🙂