Trigger based on update of a specific field in a list?

(0) Share

Report

Posted on by klarson

Hi,

I am trying to create a flow that seems like it should be fairly simple, but I can't figure it out.

I have a sharepoint list that tracks incoming project requests. The list get's updated several times, where someone is assigned to review the request and determine if permits are required. If permits are required, the new project is approved to be created. I've created an example list below to illustrate. In the actual list, the "Ready to Schedule" column is actually a status column that is updated at each stage, from "request received" to "review in progress", to "request denied", or "ready to schedule." What I would like to do is send the project manager an email notification only when the project is "ready to schedule."

I used a tutorial I found where I've created a "trigger column" whose default setting is "ready to schedule." Then I've been using "when an item or a file is modified" as my trigger, and in the settings created a statement to say that the columns should match:

@equals(triggerOutputs()?['body/Stage_x0020_of_x0020_EPR_x0020_R/Value'], triggerOutputs()?['body/ProjectCreation_Trigger'])

Then the flow simply gets the items from the list and sends an email notification to the project manager. The problem is that it is sending an email for each item on the list where the columns match, not just the single one that had a change.

Thanks in advance for your help!

Kirstin

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

JonDoesFlow 1,304 on at

Like (1)

Report

@klarson it could be the field in the trigger condition isn’t correct, I think the word “value” should come after the “body”.

however, I have written a blog post on how you can use the filter array action to help you correctly form trigger conditions with the correct syntax.

https://www.jondoesflow.com/post/filter-array-ftw

---------------------------------------------------------------------------

If I have helped you with an answer, please accept this post as a solution and thumbs up my reply. Thanks !

Blog - JonDoesFlow
Twitter - JonDoesFlow
YouTube - JonDoesFlow

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (1)

Report
I'd probably just do something like that below for the trigger condition:

@equals(triggerOutputs()?['body/Stage_x0020_of_x0020_EPR_x0020_R/Value'], 'ready to schedule')

You would also need to check if the Status has changed since last time the item was modified, otherwise it would continue to trigger every time you made changes after the Status was changed to 'ready to schedule'.

Have a look at the logic below.

Was this reply helpful? Yes No
klarson 61 on at

Like (0)

Report

Hi GrantJenkins, thank you for your suggestion. I tried it, and the flow failed on step 2 (Get changes for an item or a file (properties only). There is an error message that says "Bad Request," and in the output body field it says:
Any suggestions?
Thanks,
Kirstin

Was this reply helpful? Yes No
klarson 61 on at

Like (0)

Report

Also, maybe I should mention that I checked the list settings, and versioning IS turned on (that seemed like the logical first thing to check...) I assume this has something to do with the "trigger window", but don't know how to address it.

Update: I changed the versioning settings to capture minor updates as well, and the flow is seeing that there is a change, but there is no output to feed into the condition. Here are screenshots to illustrate what I'm trying to explain:

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

It looks like it's going into the Yes branch if the Status has changed. However, there is something within your inner condition and/or actions within the Yes branch that isn't working by the looks of it.

Do you happen to have a Terminate action within the Yes branch anywhere?

Was this reply helpful? Yes No