Answered

Contain condition always false

(0) Share

Report

Posted on by pbobyrev

Hello!

I know there is a lot of similar questions withing the topic, but none of solutions seems working to me. So, the problem is that the "contain" condition always claiming "False" when trying to copy a a file matching the condition from one share-point site to another. Here is a screenshot (sorry for the russian interface, but hope the meaning is clear)

My condition is: @contains(triggerOutputs()['headers']['x-ms-file-name-encoded'], 'Summary').

Thanks for any help!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @pbobyrev,

Do you want to check if the file name of the new created file contains 'Summary'?

Do you create your flow using the "Copy files from one SharePoint Online account or folder to another" built-in template?

I think there is something issue with the trigger within your flow. The File name dynamic content the "When a file is created" trigger returned is the base64 representation of the file name rather than the file name. The screenshot as below:

I have made a test on my side and please take a try with the following workaround:

Add a "When a file is created (properties only)" trigger, specify Site Address and Library Name.

Add a Condition, left input box set to File name with extension dynamic content of the trigger, right input box set to Summary, middle drop down, choose contains.

or you could click "Edit in advanced mode", type the following formula:

@contains(triggerBody()?['{FilenameWithExtension}'], 'Summary')

Within "If/yes" branch of Condition, add a "Get file content" action, specify Site Address, File Identifier field set to Identifier dynamic content of the trigger.

Add a "Create file" action, specify Site Address (Another SharePoint Site) and Folder Path, File Name field set to File name with extension dynamic content of the trigger, File Content field set to File Content dynamic content of the "Get file content" action.

Image reference:

The flow works successfully as below:

Best regards,

Kris

Was this reply helpful? Yes No
pbobyrev 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you, Kris!

It works!

Was this reply helpful? Yes No
paula_flaherty 6 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Crimsonhobbit 2 on at

Like (0)

Report
Copy link

Link copied!

This solution doesn't apply now that 'Edit in Advanced Mode' is no longer available.
I'm trying to send an email when a file is added or modified in a sharepoint folder. The Flow builder makes this look like a piece of cake and it should be but no matter how I try to do this the result is always False.
If I hover over the condition File name box I can see it's looking for x-ms-file-name-encoded rather than x-ms-file-name. If I replace the left box with the edited code to remove '-encoded', it still doesn't work.
Is there another way of achieving this ?

Thanks

Was this reply helpful? Yes No