Unanswered

Building flow to find string in converted PPTX doc

(0) Share

Report

Posted on by AutomatingMyJob

Trying to search text of PPTX for specific string (tech blueprint). Since you can't seem to use get file content alone as it returns binary I'm using Convert to PDF & Get PDF Text Layer

@contains(toLower(outputs('Get_PDF_Text_Layer')?['body/TextLayer']),'tech blueprint')

Says expression isn't valid, any suggestions?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

AutomatingMyJob 2 on at

Like (0)

Report

So I changed to
contains(tolower(outputs('Get_PDF_Text_Layer')?['body/TextLayer']),'tech blueprint')
and it saves, but then I get error:
InvalidTemplate. Unable to process template language expressions for action 'Check_for_Tech_Blueprint' at line '1' and column '30734': '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 'Boolean'.'.

Of course I'm trying to capture any case of the string with the ToLower expression.

Was this reply helpful? Yes No
rrovira Microsoft Employee on at

Like (0)

Report

Hello, @AutomatingMyJob!

I could be wrong, but I think the "@contains" is what's returning the boolean and the Get PDF Text Layer requires a "A Base64 encoded representation of the PDF file to be processed." as you can see here Get PDF Text Layer – Encodian Customer Help. Could you try creating a variable within a conditional that uses the @contains(tolower(outputs('Get_PDF_Text_Layer')?['body/TextLayer']),'tech blueprint')?

I'll keep researching, if I find anything useful I'll be sure to post it immediately!
Cheers

Was this reply helpful? Yes No