Unanswered

Flow with conditions based on content type or custom properties

(2) Share

Report

Posted on by CRM Unified Interfa...

Hello,

I am trying to create a Flow that moves a document when a new file is created in a document library where column X has a certain value.

When using a custom column (from a custom content type), I get this error:

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2024': 'The template language expression 'contains(triggerOutputs()['headers']['TipoWorkFlow'], 'Fax')' cannot be evaluated because property 'TipoWorkFlow' doesn't exist, available properties are 'Pragma, Retry-After, x-ms-file-id, x-ms-file-name, x-ms-file-path, x-ms-file-etag, x-ms-request-id, Cache-Control, Date, Location, Set-Cookie, Server, X-AspNet-Version, X-Powered-By, Content-Length, Content-Disposition, Content-Type, Expires, Last-Modified'. Please see https://aka.ms/logicexpressions for usage details.'.

Even knowing the custom column I am using is valid (named "TipoWorkflow"), the flow is unable to validate it.

I am getting this error:

Flow condition is like this:

After that, I tried using Content Type property of the document both using content type name and content type id and althought I dont get an error anymore, the conditions is not verified,

Using content type id:

Using content type name:

The only way I got a condition to work was using the File name property.

Can anyone help?

Thanks,

Miguel

Categories:

Using connectors

I have the same question (0)

All responses (14)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Hi Misidoro,

Please try to use “File name” contains .fax in the condition to see if it works.

Please check this thread for a reference:
https://powerusers.microsoft.com/t5/Flow-Forum/eMail-Attachments-to-SP-Library-CodeTwo-signature-images/m-p/22070#M5198

And about the “Column X”, could you provide more information about this column? Is it a column of the file content or anything else?

Best regards,
Mabel Mao

Was this reply helpful? Yes No
CRM Unified Interfa... 14 on at

Like (1)

Report

Hello Mabel,

Thanks for the response.

Using filename contais .fax wont work because file names may not contain fax in the name.

Column X is from a custom content type associated with the document library.

It is a choice column.

The thing is that flow interface only shows default properties like File name, file content type, etc and doesnt seem to recognize custom content types and doesnt allow its fields to be used in conditions.

Thanks,
Miguel

Was this reply helpful? Yes No
CRM Unified Interfa... 14 on at

Like (0)

Report

Hello Mabel,

Thanks for the response.

Using filename contais .fax wont work because file names may not contain fax in the name.

Column X is from a custom content type associated with the document library.

It is a choice column.

The thing is that flow interface only shows default properties like File name, file content type, etc and doesnt seem to recognize custom content types and doesnt allow its fields to be used in conditions.

Any other ideas on how we can create conditions based on custom metadata?

Thanks,
Miguel

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report

Hi Misidoro,

You could get the type of the file by right clicking on the file>Properties>Type of file. Then configure the Condition as FileName contains .(file type).
This condition works on .pdf and .xlsx, I guess it will also work on Fax file.
Please have a try on it.

About custom content of document library, it is currently not supported in flow, I have seen an idea at Flow Ideas Forum, please vote this idea at here:
https://powerusers.microsoft.com/t5/Flow-Ideas/Flow-custom-SharePoint-library-columns/idi-p/3344
I will also collect and report this from my side.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
CRM Unified Interfa... 14 on at

Like (0)

Report

Thansk for the reply and the user idea suggestions, I will take a look.
The solution based on file type although can be used in some scenarios, can't really be used in enterprise scenarios where what makes sense is to use custom content types to classify information.

Thanks,
Miguel

Was this reply helpful? Yes No
Ian Bruckner 4 on at

Like (1)

Report

seems like content type values (ID/Name) aren't returning... even though such attributes are showing up as selectable.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report
Currently trying to use A custom document set to determine if whether or not a flow should be initiated. Users should not be able to start a flow with a singular document, only when they submit a complete document set. Does anyone know when Document sets (33761) are going to be modernized?? because it was scheduled for Q1 and we are now in Q2..... After testing this thoroughly I was able to conclude that we cannot use Content Type as a condition it behaves irregularly.

I've tried the following:
Custom Content Document Set Types : Invoice Approval
Equals: Invoice Approval, Picture, Document, Document Set for parameters Content Type, Content Type Name, Content ID
Used a conditional , and tried a switch statement.
Used the GUID ID for the content types with and without the 01xGUID prefix
Tried inverse logic "if not equal to" document with only other option as "Invoice Approval"
Uploading a document will not work either no option to select a content type.
Conclusion: Flow does NOT like Content Type as a control condition AT ALL.
Resulting in mostly parameters did not meet criteria email being sent. Which means it's most definitely not seeing any of the content type.

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

We cannot use the Column Content Type, this is not a column we can lookup, it is generated by SharePoint (CAML)
You can make a workaround.

Create a choice column that contains the name of each content type, user will have to select this. Then we can lookup that column because it contains data flow can get.

Maybe we can use calculated columns, but even calculated columns cannot read from Content Type column.
Im struggeling with this myself, maybe we can use the following (Not Tested yet, will test tomorow)

SPREST-Versions (Get the data)
Select and map the column (Content Type)
Create HTML table (If we can see the output here we can use it in a condition.

I will type my results tomorow

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

We can extract and run a trigger on specific content type name or id using send http request.
I will update later today again.

I will just try a simple condition like Content type = Document

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

Seems like a condition works like Content type = Name of content type

Was this reply helpful? Yes No