Condition with Onedrive

[GauthierCRP]

Hello Everyone,

I'm beginner with Power Automate. I'm currently trying to establish a flux in order to sort different files, in different directories, based on the file name of each file.

I use the "condition" tool, with the contains expression, as you can see in the scrennshoot below. The main issue is that the result of the condition is always "false" even if, the name of the file contains the right expression.

Can you help me figure what i'm doing wrong, syntaxe, expression ?

Many Thanks in advance,

Gauthier

[MarconettiMarco]

Hello @GauthierCRP ,

try to include 302852 in single quotes.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[GauthierCRP]

Hello @MarconettiMarco,

I tried, but unfornately, I have same results. All files are move to "false" directory, even if the name of the file contains 302852...

Any idea ?

Many Thanks and Best Regards,

Gauthier

[MarconettiMarco]

After the trigger, try to add "Compose" action and add into the OneDrive file name. Then run the flow and see what is the Compose Output.

Let me know

BR,

Marco

[GauthierCRP]

Sorry @MarconettiMarco but what is a "compose" action ? I'm very beginner with Automate.

[MarconettiMarco]

Hello @GauthierCRP ,

np.

Add the following action after the trigger:

Then in the inputs add your field on which yoy want to apply the condition.

Run the flow and see what is the Compose output like below:

BR,

Marco

[GauthierCRP]

Hey @MarconettiMarco,

No 'Compose' operation for me. I'm turning mad with it ! 🙂

Best Regards,

[MarconettiMarco]

Hey,

try Message action.

sorry but it’s in french…

[dominikmad]

You'll do yourself and everyone else a huge favor, if you switch the power automate language to english. Maybe you're also using the wrong output for the condition, the thing that starts with "nom de ..." - what does it mean in english and is it the unformatted name of the file? You can check what it "outputs" if you just go back to the flow, click on it and then click on one of the executions (at the bottom):

There you can see, what value he uses in your condition function, and maybe youre just using the wrong one.

[GauthierCRP]

I Everyone, unfortunaltely,

The language is set and blocked by my enterprise administrator...

Nom du fichier = Name of the File in English

When I check the raw Inputs and Output, I see that the "Nom de Fichier" / "Name of file" is a sequence of characters with unrelated with the existing name of file I'm trying to sort.

Any idea, why ?

Thanks

[MarconettiMarco · Accepted solution]

Hi  @GauthierCRP ,in the Condition add the following expression instead of "File name":

triggerOutputs()?['headers']['x-ms-file-name']

Please let me know.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[GauthierCRP]

Hi @MarconettiMarco,

The result is ALWAYS, false, false false and false... 😞

Even If the "Name of the File" complies with the condition "Start with"

What I'm asking to Power Automate is so simple, I can't believe that it's so hard to set ! I am the only one trying to sort file by "File Name" ?

By the way, many thanks for your help.

BR.

[MarconettiMarco]

Add the Compose action before the Condition and put in the same expression.

What is the output?

BR,

Marco

[GauthierCRP]

Marco, I'm really sorry, and I don't now why, but I don't see the "Compose" option.

Analyser JSON = Analyze JSON

Créer un tableau CSV = Create à CSV table

Créer un tableau HTML = Create an HTML table

Filtrer un tableau = Filter a table

Jointure = Join

Message = Message

Selectionner = Select

So where is this compose option ?

Thanks

[MarconettiMarco]

Hi @GauthierCRP ,

please change in English language.

Anyhow it should be your "Message" action.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[GauthierCRP]

The Output, is the Name of the File, correctly writed... But then, the condition does not work on it.

Best Regards

Gauthier

[MarconettiMarco]

ok @GauthierCRP ,

for me it's working correctly because the condition says contains "302852", but your file name contains "30582".

BR,

Marco