Unanswered

Power Automate - Conditional contains

(0) Share

Report

Posted on by nnvm

Hi Community,

I wondering if you can help with the following flow: I`m trying to trigger an approval flow when a file is created or modified on a SharePoint folder. I added a condition to identified if the file name contains certain information but the output of this condition is always false even though i am adding the correct information in the file name. I would like to know how i should do it in order the condition identify the file name.

I have the same question (0)

All responses (9)

Answers (0)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

Re: Power Automate - Conditional contains

@nnvm

Hey there. Can you show us a pic of the condition? Maybe the input (filename) as well? It might be something as simple as quotes or something, but would like to see what you have first.

Thanks!

-Ed

Was this reply helpful? Yes No
nnvm 12 on at

Like (0)

Report

Re: Power Automate - Conditional contains

Sure, here you have.

Was this reply helpful? Yes No
RobElliott 10,286 Super User 2025 Season 2 on at

Like (1)

Report

Re: Power Automate - Conditional contains

@nnvm at the risk of stepping on @edgonzales' answer, the text in the condition is case sensitive so it is looking for LAX whereas your file has Lax.

Rob
Los Gallardos

Was this reply helpful? Yes No
ScottShearer 25,254 Most Valuable Professional on at

Like (2)

Report

Re: Power Automate - Conditional contains

@nnvm

I believe thie issue is that string comparisons are case sensitive. Try wrapping the left side of your conditions in an toUpper() expression which will convert the string to upper case.

Was this reply helpful? Yes No
nnvm 12 on at

Like (0)

Report

Re: Power Automate - Conditional contains

Thanks for your solution but it did not work. 😔

The following error appeared: Unable to process template language expressions for action 'Condition' at line '1' and column '2664': 'The template language function 'toUpper' expects its parameter to be a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#toUpper for usage details.'

I also tried modifying the original flow From LAX to Lax in order to match the file name but it is still bringing as result false.

Was this reply helpful? Yes No
ScottShearer 25,254 Most Valuable Professional on at

Like (3)

Report

Re: Power Automate - Conditional contains

@nnvm

Try wrapping the expression that you have in a coalesce() expression which will provide a default value if your first value is null:'

coalesce(toUpper(triggerBody()?['{FilenameWithExtension}']),'NoValue')

Was this reply helpful? Yes No
nnvm 12 on at

Like (0)

Report

Re: Power Automate - Conditional contains

Unfortunately it did not work either. I continue getting the same message

Unable to process template language expressions for action 'Condition' at line '1' and column '2664': 'The template language function 'toUpper' expects its parameter to be a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#toUpper for usage details.'.

Was this reply helpful? Yes No
ScottShearer 25,254 Most Valuable Professional on at

Like (2)

Report

Re: Power Automate - Conditional contains

@nnvm

Sorry about that....

What I should have posted is this:

toUpper(coalesce(triggerBody()?['{FilenameWithExtension}'],'No Value'))

The concept is that the text No Value will be returned if the file name is null.

Was this reply helpful? Yes No
Gus 136 on at

Like (0)

Report

Re: Power Automate - Conditional contains

case sensitive test fixed my issue. ty

Was this reply helpful? Yes No