Help with Trigger Conditions

[Tmalonson]

Okay, this one is pretty simple; I just don't have the knowledge base to do it myself.

I am trying to eliminate a clunky "loop-kill" condition within my flow by using a trigger condition to prevent the flow from running.

Problem is, I don't know how to do that... 😅😐

Here's the set-up:
I have a SharePoint Document Library.
Within the properties, there is a Date/Time column called "Flow Modified"
This is necessary because the flow updates file properties within the Document library (but it also triggers on creation/modify);
so, at the end of the flow it updates the Flow modified column with the current timestamp.

I have a loop-kill condition in the flow that used to work well, but I think Power Automate made some back-end updates when they moved over to the new editor that has made it less-viable.
So, I could really use some help; here are the conditions that it should trigger on.
1. IF[ Flow Modified is Null ]
2. IF[ Flow Modified is NOT Null ] AND IF[ Flow Modified is <= to UTCnow(minus 10 minutes) ]

These conditions result in the following:

The flow will only trigger if the Flow modified column has a timestamp older than 10 minutes.

How do I code those into this?

Thanks,

[v-yueyun-msft · Accepted solution]

Hi , @Tmalonson 

According to your description, you want to set the trigger condition, you can try to refer to this code :

or(
 equals(triggerOutputs()?['body']?['Flow Modified internal name'] , null ),
and( not(equals(triggerOutputs()?['body']?['Flow Modified internal name'] , null )) , lessOrEquals( triggerOutputs()?['body']?['Flow Modified internal name'] ,addMinutes(utcNow(),10) ))
)

And you can turn on the "split on" in the setting of the trigger.

The column internal name you can get in the sharePoint url.

How to find the internal name of list or library columns – SharePoint Stuff

Best regards,

Yueyun Zhang

[Tmalonson]

Yes, thank you; I knew I needed to set trigger condition, I simply am not adept at coding 😅
I'll give this a try and get back to you.

[Tmalonson]

I am receiving the following error, (I have verified that the column name is 'FlowModified' within SP setting and by inputting a dynamic action elsewhere).

"The power flow's logic app flow template was invalid. The template condition expression 'or( equals(triggerOutputs()?['body']?['FlowModified'] , null ), and( not(equals(triggerOutputs()?['body']?['FlowModified'] , null )) , lessOrEquals( triggerOutputs()?['body']?['FlowModified'] ,addMinutes(utcNow(),10) )) )' at line '1' and column '985' is not valid template language expression"

Also, it seems like turning on "Split" results in not being able to access the individual data outputs from the trigger, only a body/value list. Is it required?

[v-yueyun-msft]

Hi , @Tmalonson 

Thanks for your response! You need to add the '@' in the first of the expression , like this:

Best Regards,

Yueyun Zhang

[Tmalonson]

Hey Zhang,
Sorry for the late response, I had other things to worry about last week.

I actually ended up re-working the whole process and removing the self-trigger conditions entirely.
I do believe that this would've worked and I am going to mark it as the solution.

[Tmalonson]

Hey Yueyun,

I think I actually will still need to use a portion of this trigger condition to prevent this from running when a new source folder is created as opposed to the subfiles being uploaded (when I want it to run).

I should be able to use the second portion of the code you provided, seeing as When the file is created, the flow modified column is filled using utcnow().
Currently, the flow runs anyway and fails to no consequence (because the trigger-file being created already has all of the correct property information, which is what the flow is meant to populate).
So, I tried to use your provided solution.

@
or(
 equals(triggerOutputs()?['body']?['FlowModified'] , null ),
and( not(equals(triggerOutputs()?['body']?['FlowModified'] , null )) , lessOrEquals( triggerOutputs()?['body']?['FlowModified'] ,addMinutes(utcNow(),10) ))
)

Here is the problem which this presents;
Now, when I try to use a For Each loop in reference to the Trigger Item, it says that the body/value Array is invalid and null. 
So, I turned on spilt tracking and entered the @triggeroutputs()?[body/value] as you had previously shown and this did not seem to fix the issue.

When I tried to select the for each and correct the source, it did not give me the option o select the body/value outputs.

What would cause that, and how can I fix it?