Answered

Trigger Condition When an item or a file is

(0) Share

Report

Posted on by mtagliaferri

261

I am trying to set a trigger condition to initiate When an item or a file is modified step from a calculate columns based on number.

The flow works perfectly with the first two conditions, as soon as I add

@greater(triggerOutputs()?['body/Tot_x0020_Days_x0020_C'], 7)

The flow generates an error:

InvalidTemplate. Unable to process template language expressions for trigger 'When_an_item_or_a_file_is_modified' at line '1' and column '20782': 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.

I have also tried the trigger condition:

@greater(int(triggerOutputs()?['body/Tot_x0020_Days_x0020_C'], 7))

But I am getting the same error, I have tried to change the column to single text using the formula to return the number int he SharePoint library.

Screenshot (2).png

Any ideas on how I can add this trigger?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,857 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @mtagliaferri,

I have seen in a couple of blogs that calculated number fields are output as floats:
https://sharepains.com/2018/09/03/microsoft-flow-handling-calculated-fields-in-microsoft-flow/

Can you try this expression as a test instead?
@greater(float(triggerOutputs()?['body/Tot_x0020_Days_x0020_C']), 7.0000000000000)

Was this reply helpful? Yes No
mtagliaferri 261 on at

Like (1)

Report
Copy link

Link copied!

That’s done the trick! Thanks!

Was this reply helpful? Yes No
BernDog 2 on at

Like (0)

Report
Copy link

Link copied!

I know how to add the filename that was modified or added in an expression of a trigger but how can you add the user/name of the individual who actually modifed or added the file as well? The notification in MS Teams displays the owner of the flow but Id like the user to appear in the actual message, see ex below:

Was this reply helpful? Yes No